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 |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2003-07-03 : 04:46:49
|
| Hi Reader,Each day I have to back up 7 databases to our local server and wondered if there is some kind of script I can run to do this.The databases are called ebenchmark006 to ebenchmark012 and are located over serveral servers. I have to copy all the data from all the tables to our local server for each database. For each database I backup I create a new databases called EB012Backup-2003-07-03, so basically the databases name and date.Any help would be great.Thanks.Leah |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-07-03 : 06:33:14
|
| can you not use the maintenance wizard in the enterprise manager to do all this for you ?!====Paul |
 |
|
|
|
|
|
Backing up Databases