decreasing backup time

[beechill4]

Hi,

I have a sql 2000 server with 190 databases. Most are approx 70 mb in size and all need to be backed up.

The backup takes about 2 hours every night. Is there any obvious way of speeding that up?

Thanks

 

[ptheriault]

Not using the SQL Native backup tools. That's really not that long for that many databases.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

2 Hours isn't that long. What's the need to increase the backup time?

If you changed the backup job to backup half the databases, with a second job to backup the other half you might increase the speed of the backups. Just make sure that each backup job is writting to a different disk.

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)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com