BACKUP SQL Server 2005

[NickCorlett]

Has anybody else noticed an increase in the time taken to backup a database to a dump device in SQL Server 2005.

The following code:

"BACKUP DATABASE MyDb TO MyDbDump WITH NOFORMAT, INIT, NOSKIP, NOREWIND, NOUNLOAD" is taking 25% longer to backup in SQL 2005 than SQL 2000, this is also on a faster server!!

Strikes me as being a bit strange

 

[mrdenny]

I did not notice that after my last upgrade from SQL 2000 to SQL 2005. Backup and restore times stayed the same. Have you checked the drives and network to make sure that nothing is running slower than it used to?

Is your dump device a tape, network share, local disk, SAN disk, etc?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog