Also, backing up your transaction logs will increase your disaster recovery options by allowing point-in-time recovery.

jpSQLDude (3/16/2010)

---

I haven't forgotten this thread, and I am STILL working on this (I will know everything there is to know about SQL backups very soon!)

One other really funky thing...

As said above, it's been covered many times here. You can start by reading about all the real world problems we post here and try to find solutions, and...

And hope it's...

I've also used Idera's Diagnostic Manager & was satisfied with it.

However, tools change, new features get added, so it's probably best to get current demo versions and give them a...

YSLGuru (3/10/2010)

We have no jobs or operators nor any SSIS packages, no nothing outside of the user DB and a SQL Login the application uses to connect....

Thanks here too. I just had a need for this.

You can query the system tables to see if it completed.

YSLGuru (3/10/2010)

---

Third – I’ve not had to create any maintenance plan on SQL Server to do any of this. BTW – If you are using SQL Servers Maint Plans...

kwilt (3/10/2010)

---

Due to some unusual transactional migration efforts, we have a log file that has completely taken over all available space on the disk. I have tried to shrink...

YSLGuru (3/9/2010)

---

First off thanks to everyone who has taken the time to contribute, it is appreciated as always.

What has been said so far in each reply is in agreement...

The system databases are so small, there's no good reason not to back them up.

Trying to see how much you can get away without doing isn't really a good approach.

It also depends how the LUNs on your SAN are configured. In my previous job, our LUNs could configured across specific spindles, so that LUN_1 was made up of...

Why don't you like Sarab's answer ?

The way you have it now, you're telling SQL to insert into Stopped Date, but you're not telling SQL what to put in that...

Off topic, but it's not a best practice to start stored procedures with "sp_" . That's generally reserved for SQL system SPs.