See SQL ORACLE's comment about stopping MSSQL and rollback occurring. It's still going to happen. You're simply delaying the process.

Well your "sanity-check" appears right on for you business needs. If your small and can do the maintenance jobs daily, cool. I personally think daily rebuilds are overkill in a...

Differentials are not an option in the maintenance plan but you can script it into a job. Daily index rebuilds - is that really necessary for your environment? Backups to...

You can use DBCC INDEXDEFRAG. I'm sure there will be some type of performance hit but you can run this while the application is in use.

Jeff, Checked out your article and besides complimenting you on it, I have a question..how did you get this article into the future? Is that another of your many skills?...

Can you post the SQL statement that is failing?

I'm not firewalled from the site but cannot get in. They appear to be having issues or have shutdown. I cannot find any copies, yet. I will re-post if I...

Amazing how many times I've seen a similar post over the past couple of weeks! One of the first tasks a DBA must do when getting the job is to...

I agree with maintenance plans. All system databases weekly, all user databases, minimum, nightly (that's OUR strategy and may not fit your needs). With All user databases checked, if someone...

Please provide detail. What are you attempting to do? What tool(s) are you using? Provide the scripts if possible. Not really sure what you're asking other than "Backup Failes". Not...

I was getting a SQLHandShake failure from time to time on some backup jobs going to a remote server. Added the entry to the HOSTS file and haven't seen the...

With just a little extra effort, it's amazing what you can do! Boo to the naysayers!

Or better yet, avoid using reserved words as a column or table name! You'll also need [ ] around any names that contain spaces, i.e. [Data Base], when referencing them...

I'd use Profiler. You can trap all kinds of info. Be aware of potential performance degradation if you're running it on a lot of events for an extended period of...

I have to agree with Philip about the disk subsystem. Are any errors being raised? Can you backup a smaller database using Redgate? I don't believe it's the backup software....