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.

Could it be something like another process having a lock on a common table used by the SP ? So there's a conflict when they are run at...

sqlguy-549681 (2/28/2010)

---

Guys,

really appreciate the valuable info I have got.. But so far I didn't get a solid way or clear steps to calculate my database required storage. I have...

Yes, if you can keep the old drive, and...