Thank you Jason - couldn't have said it better myself...in fact, I didn't 🙂

schleep (2/19/2010)

---

Yes, destination is set to full recovery. A full backup is done immediately prior to transfers.

No tran. log backups required, since there is no other activity on the...

If the history on the maintenance plan shows as successful, you have a backup file for all system databases and the job has failed, most likely the reason is because...

AndrewSQLDBA (2/19/2010)

---

Instead of using a Maintenance Task, why not simply create an SSIS package that performs the backup. It is very simple to write a package. I have never relied...

Is the destination database set to full recovery model? If so, are you running frequent transaction log backups?

That is not going to help your situation. Adding more log files won't have any affect because SQL Server writes to the log file sequentially.

AndrewSQLDBA (2/19/2010)

---

I always drop the "sa" account, and re-create it and assign no permissions and assign it to public group

SQL BOL

System Administrator (sa) Login

System administrator (sa) is a special login...

AndrewSQLDBA (2/18/2010)

---

You should never use the sys admin account for anything. That is only for backwards compatibility. Not sure why it is even still in here.

Create a simple SQL user...

I have found that the only time the owner of a maintenance plan (or Agent job) has any issues is when that owner account is a domain user account. ...

GT's

Sorry - quoted wrong post. Meant to post the one above yours.

Not true - in a disaster recovery scenario you will probably be restoring...

Did you happen to copy/restore the system resource database at some point? If so, that would cause this kind of issue since that database has been upgraded - but...

Lamprey13 (2/17/2010)

---

Jeffrey Williams-493691 (2/17/2010)

---

And I would disagree with shrinking a database if you are setting it to read only. Why would you fragment the indexes then set the database...

twm (2/17/2010)

---

hmm...

Any idea why it only changed the SQL Server version AFTER I started the instance in Single User Mode? Because when I initially installed S2K5/SP3 and rebooted, it...