A couple of items missed in the recommendations might help out:

Data Compression

Page Compression

Either (or both) of the above options could reduce the storage requirements and also improve IO performance. ...

When you setup a maintenance plan - by default, reporting is enabled. You get to this reporting by clicking on the Reporting & Logging button next to the Manage...

You need to modify the command line when executing maintenance plans. The reason for this is because of the sub-plan capability, which just creates separate containers inside a single...

That error indicates that there was an issue with the network. When backing up across the network, if there are any issues with the connection it will cause the...

loki1049 (12/22/2010)

---

Ok, ya I'm probably not being too terriblely clear here. I have two tabs open. One is just the standard SQLQuery tab where I am writing my query to...

Grant Fritchey (12/20/2010)

---

If you're just trying to execute the create statements as a batch, SQLCMD is the tool.

You could, with only a little bit more work, take advantage of...

Only if you are moving the files is a restart necessary. If you are only adding...

Gail has a couple of posts starting here: http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

This should help you understand what you are seeing.

Are you - perhaps - using a third-party backup utility?

Another thing to validate...is the include sub-folders box checked? If so, are the backups in a sub-folder under that folder?

Jason Norsworthy (12/15/2010)

---

Thanks for the response Gail,

I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had...

View the history on the maintenance plan - not the history on the job.

BTW, you do not appear to be backing up the transaction logs frequently enough. If all...

If the database was not backed up while in single user mode, then it will not be restored in that condition. So, no - you won't need to set...

I would recommend investing in one of the backup compression tools that are available.

Quest Litespeed - I use this one

Redgate SQL Backup - also a very good tool, and less...

Is there any possibility of getting copies of a backup prior to the corruption? Normally, you would be sending your backups offsite somewhere for DR.

If so, you could restore...

david.jobin 9674 (12/14/2010)

---

From my observations .... On Windows 2008 / R2, this behaviour is expected.

To make it work, you have to elevate the process with administrative privilege (UAC)

So you open...