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 |
|
DB King
Starting Member
21 Posts |
 Posted - 2006-06-28 : 05:45:08
|
| HiSetting up log-shipping can only be done at 1 database at a time. Is there any way of automating the Wizard in SS to setup it up for all databases on a server to another server using VB, c#, vbs, wmi, DMO or SMO ? Am I missing something real easy or doing sommin wrong ?Regards |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-28 : 10:46:47
|
| you can do a regular tlog backup and restore instead1. initially, full backup and restore2. then regular tlog backups, copy to destination, restore with sync users, delete or move restored file to another directoryyou can use jobs so everything is scheduled--------------------keeping it simple... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-28 : 12:00:55
|
| http://www.mindsdoor.net/SQLAdmin/LogShipping.htmlmay helpKristen |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-28 : 21:58:01
|
instead of norecovery, i use standby, this gives me the option to verify if the restore was successful (random checks ofcourse)  --------------------keeping it simple... |
|
|
|
|
|
|
Log shipping all databases (automating setup)