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 |
|
avipenina
Starting Member
44 Posts |
 Posted - 2007-11-11 : 16:11:09
|
| Hi,I've setup a log shipping successfully,and i'm wondering how i can setup new log shipping with all the task that log shipping do in TSQL statement?I've try to export all the log shipping that i've created into query window but it's not do the entire log shipping plan (backup the new DB and restore it on the secondary server and so on).Thx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-11 : 20:04:59
|
| You can try script it, but why do that? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-12 : 12:09:21
|
| I tried to script it a few years back by running SQL Profiler on both the primary and secondary servers. It was a nightmare. After several hours of spinning my wheels, I gave up. It is very easy to script out the manual log shipping, just not the custom built-in one.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
avipenina
Starting Member
44 Posts |
Posted - 2007-11-13 : 03:54:10
|
quote:
Originally posted by tkizer
I tried to script it a few years back by running SQL Profiler on both the primary and secondary servers. It was a nightmare. After several hours of spinning my wheels, I gave up. It is very easy to script out the manual log shipping, just not the custom built-in one.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
I'll tell you what i need to achievei want every time that a new DB is created i want i automatically to be logged ship into the secondary server and start the log shipping sequence automatically.how can i achieve that? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-13 : 13:05:48
|
| Good luck on that. Like I said in my last post, it was a nightmare when I tried to script it so I gave up. I spent hours on it too.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-13 : 22:43:25
|
| In db properties -> log shipping page in ssms, there is 'script configuration' button. Try it and modify the script for other db. |
|
|
|
|
|
|
recreate the entire log shipping task in script