Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  What's your backup performance?

Author  Topic  Kristen Test 22859 Posts Posted - 2010-08-01 : 01:14:17 I'm curious to know how our backup performance compares. I checked the FULL backup files this morning (server is quiet early on a Sunday morning). Database backup files is 5.6 GB Full backup was made at 04:00 and took 133 seconds - 42.8 MB/sec BACKUP DATABASE MyDatabase TO DISK = 'NUL' WITH COPY_ONLY 55.002 seconds (94.208 MB/sec). BACKUP to NUL is 2.2 times as fast as to disk. Is that good? bad? or indifferent?