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.
| Author |
Topic |
|
Revuca
Starting Member
19 Posts |
 Posted - 2003-01-15 : 04:30:08
|
| What is the best way to back up different databases in a sequential order on different servers. Ie, I have 4 databases on 3x different servers that I want to back up. When one completes I want to start backing up the next one. I don't want to set schedules (preferably not) on all servers and have the possibility of them overlapping as I'm backing up to a network drive. Are master/target servers an option ? Can I backup all db's from one job on one server ?thanksMike |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-15 : 04:48:51
|
quote:
What is the best way to back up different databases in a sequential order on different servers. Ie, I have 4 databases on 3x different servers that I want to back up. When one completes I want to start backing up the next one. I don't want to set schedules (preferably not) on all servers and have the possibility of them overlapping as I'm backing up to a network drive. Are master/target servers an option ? Can I backup all db's from one job on one server ?thanksMike
you can map the network drive and create a backup device with that drive using the UNC name of the destination server and have the backups on the network.Expect the UnExpected |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-15 : 12:31:27
|
| You can backup all of the databases from one job on one server by using UNC or mapped network drives. You do not have to create a backup device, but you can if you want to. |
|
|
|
|
|
|
Backups on multiple servers ?