It is sad but true that most of what occurs is lack of understanding or laziness.  Being a SQL Server consultant I am given access to a lot of different...

Hi this is Greg Robidoux, founder of Edgewood Solutions.  I just wanted to respond to the reference to our company in the prior posting.  Edgewood does sell products for Idera, Imceda,...

The location is Bethesda MD.

Another product you can look at is SQL LiteSpeed. It allows you to compress SQL Server backups on the fly up to 95%. It is also faster then...

Another alternative is to use SQL LiteSpeed. It mimics the native SQL Server backup and restore commands, but allows you to compress your backups on the fly and also...

Edgewood Solutions is a reseller of SQL LiteSpeed and we can assist you with any questions you may have about SQL LiteSpeed. You can call us at 888-788-2444 or...

Currently you need to write a process that removes the old files. This can be done either through DTS or a T-SQL script.

One thing you could do...

Chris,

Thanks for the great input. I wasn't sure how detailed to write the article, so I did a very high level for now to get people interested. I...

Here are a couple of pages that explain latching. This info is on books online.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_4kok.asp

and

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0odj.asp

What do your memory and disk counters look like. Are...

Greg, have you thought about using the TOP or SET ROWCOUNT command? Not sure if it matters what record you get, but this will ensure only one record is returned.

Greg...

Based on the number of backups and the size of the backups you should take a look at SQL LiteSpeed.

This could reduce your backup time by 50% as...

There is not a 4GB limitation with SQL LiteSpeed.

Some of our clients are using it to back up 100+ GB databases and there is one client that is...