It wouldn't change a thing by cycling the service - SQL Server has to rollback all of the transactions in the batch. If the job you killed is a...

There must be something else going on here - as I can take a backup from prod (mirrored) and restore it to QA (non-mirrored) with no problems.

Is it possible that...

Apurva - if that is a process you perform on a regular basis, then yeah - it's really a waste of time to shrink it because you are going to...

Nope - can't suggest anything more than setting the max memory. SQL Server will take the max memory you assign it - and shouldn't take any more than that.

What...

Do me a favor - lookup REPLACE in Books Online and post what you have tried so far. I am more than willing to help you out, but I...

Apurva (8/31/2009)

---

Shrinking data file is useful only if you have delete or truncate operations going on in your database. Most of the time production databases do not delete data. So...

Timothy.Cloud (8/31/2009)

---

Let me give you all a little more info, I do apologize for being so vague.

The application server in question is running HP Support Manager 7.0.

That particular application is...

Not sure why you would be worried about that - since you have control over the max memory setting for SQL Server. If you set the max memory -...

Why are you rebuilding all of the indexes? You should only be rebuilding those indexes that need to be rebuilt, that is - on indexes with greater than 1000...

In addition to what Gail has stated - remove that maintenance plan that shrinks your databases. You shouldn't be scheduling a shrink of data files (or log files) anyways.

You...

Nope - no problems. I am currently running Windows 7 x64 - accessing SQL Server 2000/2005/2008 instances running both x64 and x86 with no problems.

Brad (8/31/2009)

---

I understand this may sound overly cautious, but if you store SSIS packages on the server then there is always the chance that someone could hack in and get...

Item 1: Not necessarily...packages can either be stored in the file system (on the SSIS Server), or in a SQL Server store, or in MSDB for a particular instance. ...

sqlbuddy123 (8/31/2009)

---

Could anyone tell me , if we install SSIS on a seperate server dedicated for SSIS, should we also install SQL Server DB Engine on that machine? Also, should...

Using SSMS to connect to reporting services, the first thing you need to do is select Reporting Services as the type of connection, then type in the instance name you...