Lamprey13 (2/17/2010)

---

Here is a reply from Paul Randal (at the time the Dev Lead, Microsoft SQL Server Storage Engine) about why is shrinking a database not a good idea.. and...

Yes, the patch does update SQL Server and changes the version level.

Okay - releases space to be used by...

First, make sure your client tools have been upgraded to at least the same version level as the server you are accessing. If your client tools are SP2 or...

The update from 9.0.4035 to 9.0.4053 was done through a windows update security patch. You can find more information at: http://support.microsoft.com/kb/970892

What is the full error you are getting?

GSquared (2/16/2010)

---

This is what I can find on the subject:

http://support.microsoft.com/kb/919155

DBCC CHECKDB does take a lock on tables. The above is about DBCC itself recording a timeout, but in a...

I am not going to say whether or not it is - I am just going to say that you should not even consider it. Shrinking database files will...

Really bad idea to schedule a shrink of the databases every night. Why do this, just so the database can grow the next day,...

Sorry - you still have to modify the startup parameters using SQL Configuration Manager. I believe you might have to modify the registry directly to get the changes to...

Database files don't automatically shrink when you delete data - that is normal. If you really need to recover the 23MB of space, then you use SHRINKFILE to shrink...

SQL Iron Chef (2/15/2010)

---

Yeah it's missing the semi colon thats why it thinks its a part of the file path. We don't need the traceflag anymore so I wanted to...

Google is your friend, first three items when I searched for that error are:

http://support.microsoft.com/kb/889646

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

http://support.microsoft.com/kb/925744

That should get you started on fixing this issue.

Is the SQL Browser service running?

Are you running SQL Server 2005 Express Edition? If so, is the system it is running on joined to the domain?

When you create a...

CirquedeSQLeil (2/13/2010)

---

The restore will take longer. A restore will "zero" out the data file and grow it if necessary. Due to this kind of IO it should take...