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 |
|
california6
Starting Member
38 Posts |
 Posted - 2008-08-15 : 14:21:40
|
| I have few databases (close to 70)on one of my database server. Instead of running single database backups for each DB - is there a script which does this job?Cali |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 14:25:35
|
| Use maintenance plan and schedule it. |
 |
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-15 : 14:38:06
|
| I want to run this one time and take all the backups to another server. isnt there a script to do this?Cali |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 14:49:32
|
| Then run it one time by selecting all your database and pointing to other server's drive. Or copy all .bak files to other server and restore as you like. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-15 : 16:35:20
|
| tkizer you are the best. the scrip is great and this is what i was looking for.Cali |
|
|
|
|
|
|
Backup Script
Tara KizerMicrosoft MVP for Windows Server System - SQL Server