Roy,

thanks for your answer.

I already tried that. Trying to set the distribution database offline will hang forever, because it is being blocked by some of...

Nice one Lynn. Very good question... and something learned 🙂

"around 11 gb of data on their personilized desktops." on a production SQL Server??? I didn't even mention to look into this because i assumed that there *should* be no...

Usually the C drive should only be reserved for Windows. Any other Application, including SQl should be installed on, lets say D with the Database files on others.

You...

We have a database DDL trigger in place that records any changes made to any object. This allows to rapidly go back to a previous version if something breaks. Developers...

homebrew01 (4/26/2010)

---

So ... you would advise against creating a...

... just realized that when I saw your post... 🙂

In any event, seems the OP has other issues at hand here....

You might want try running that dmv with the 'LIMITED' option:

FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, 'LIMITED')

as it will have better performance, specially if it is a big...

Dave, great article. very detailed and nicely outlined. Kudo's......

You can also use 3rd party backup software like Quest LiteSpeed, Red Gate SQL Backup Pro or Idera SQL Safe backup which allow you to get a compression of about...

I know that, but when you have a TB database size, compressed down to about 207GB... that still would be about 52 files!!!!

Toby White (4/12/2010)

---

Redgate and quest also provide object level restores with their backup solutions. Additionally Quest offers the ability to save a backup as a self extracting .exe file that...

Gary,

what disks are those? 30 hours for 550GB seems to be EXTREMELY slow. We backup natively with SQL 1 TB in about 2.5 hours on our SAN.

...

....an even scarier thought is such a long database recovery chain.... if any of the log backups in the interim is kaputt, you can only go back as far as...

You should probably just leave the default format and pick out the columns you need:

DECLARE @tasklist TABLE (taskname NVARCHAR (500))

INSERT INTO @tasklist

EXEC xp_cmdshell 'tasklist'

DELETE FROM @tasklist WHERE taskname IS NULL...