Does anyone have a similar script for SQL 2005 - please share

U can setup email to be sent on completeion of the task within sql server...

Doesn't enabling deadlock graph take performance hit on the system.....true or not? As on our systems i have seen some performance hit when deadlock graph is enabled.

Azad there are 2 different things -

1 page being corrupt

2 The sector on the HD being corrupt

If its just the page then u should be fine and can be...

Waz r the tempdb not available due to the db placed on a different drive that was not available to the server due to some issue? I had seen this...

We take full backup of the db's daily and all of a sudden we start seeing this error for last 3 days for one particular db. Nothing has changed and...

That was a neat workout...it did not occur to me and have saved the same for future use (Near future). Should have read all the comments before my last post...

Looks like u do have a run away transaction like one of them emntioned. Either terminate that session and run shrink or wait for it to finish. There is no...

Good question though it sounds very simple. I havn't tested system db's restore in years...time to check one and see how it goes.

One other way is to use Vormetric software to encrypt the drive itself where the files are located. Its got pretty good encryption and is widely used enterprise solution.

Just thinking loud- If you have mdf and ldf files can't we use those files for a db....i mean create a db with similar name (mdf and ldf file names)....

As suggested apply sp3 and then work on maint plan. In sql 2005 u can have all the maint tasks in a single plan. But as best practices it would...

sure. Since it was related topic posted it here. ty.

has anyone come across this error and any solution :

Msg 3132, Level 16, State 1, Line 1

The media set has 2 media families but only 1 are provided. All members...

Apart from shrinking you need to set a standard size for the tlog based on observations over a period of time. Shrinking tlog frequently will cause performance degradation -...