November 5, 2003 at 2:32 pm
I have approximately 60 databases on one SQL server (2K sp3). I need nightly dumps of each. Each database is under 500 MB in size. Any harm in running all 60 backups at one time, other than performance? Or would it be wiser to run maybe 20 at a time? Each dump runs to disk and is swept to tape at a later time in the evening.
Terry
Edited by - tosscrosby on 11/05/2003 2:34:06 PM
Terry
November 5, 2003 at 5:56 pm
How big are they? I've got 30 on one and run backups sequentially. Do all of them in about 9 minutes using Litespeed.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 6:41 am
All databases are under 500 MB. Currently I do them sequentially as well, about 5 minutes apart. I use Litespeed on our VLB reducing backups from about 3 hours to about 20 minutes but don't need to license it for this server, yet.
Terry
Terry
November 7, 2003 at 8:55 am
We have about 125 db's ranging from 50MB to 3GB. There are about 40 of then that are about 2.5GB. They are run in sequence without any time interval. Though i don't use any software for that. Just generic backup script and it takes about 40 mins. This also depends on your hardware config as well and what kind of harddrives you have. U can comfortably do all the backups in a single go...good luck.
November 7, 2003 at 10:42 am
Are these backups to DAT tapes on the same server or mapped networked drives ?
Cheers
Mike
November 7, 2003 at 12:14 pm
These are jobs scheduled through the SQL Agent, each individual to a local drive. The tape sweep occurs once the jobs have completed.
Terry
Terry
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply