Great replies everybody.

One more question, in his article Paul mentions "Detecting corrupted database pages". How often is this really a problem?

Do you think it is worth worrying about and studying things like clustering, replication, mirroring, etc if they aren't a part of your current position or do you think that...

Sorry if this was already mentioned. I just skimmed the thread. It's long!

Logon to the web server, right-click My Computer > Manage > IIS. Right click on whatever the website...

That is an excellent suggestion--however, each data fix case is different and involves different tables so there isn't any way I can anticipate which tables out of several thousand to...

Looking forward to part 2, especially strategies on table backups/restores.

I agree with Terry. Doesn't sound like there is anything wrong.

In order to effectively manage this database you need a better handle on the application that writes to this...

As a follow up, everything worked as noted here. I did the detach+attach without taking any special backups. We let connections drop off the web servers and then took them...

Thank you. A few more questions...

We are doing this because I need to move log files onto a bigger drive. I have the option of adding new log files and...

Thanks. So far I think good on the following:

- Adding the LUN to the cluster using Disk Management.

- Adding the Resource to our SQL Server Group in Cluster...

Is it possible to further qualify the query and modify the stored procedure accordingly?

In other words, is there a reason you need to pull 2 full years worth of...

Have a look at http://msdn.microsoft.com/en-us/library/system.string.replace(VS.71).aspx. Gives examples for VB.NET and C#.

As far as I can tell, it is stored in the command column of msdb.dbo.sysjobsteps as an argument passed to master.dbo.xp_sqlmaint. Look for something like:

-DelBkUps 3DAYS

I don't see it anywhere...

If you don't need to do transaction log backups, change the database recovery mode to SIMPLE. Otherwise, start taking regular transaction log backups and your transaction log won't grow wild....

Like another poster said, if it is your LDF that keeps growing then maybe you just have to take more frequent transaction log backups.

You shouldn't shrink an MDF unless you...

You can use an Execute T-SQL Task in your maintenance plan and script the backup exactly as you want it.