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 |
|
cwalston
Starting Member
25 Posts |
 Posted - 2007-12-12 : 16:07:44
|
| Hi All!! Finally upgraded to Enterprise Edition got Log Shipping up and running. But, unless I'm really doing something wrong...it won't copy the Full backups over to my DR site! What the heck were they thinking??? What if I need to do a point in time recovery an hour before a disaster??Now I can make a job to go through the MSDB tables and grab the file names of the latest full backups and then generate a copy job, but...REALLY??? This cannot be the correct way to handle this problem. Another problem I would have if I build my own copy job is aging off the dumps on the DR site. I guess I could write some dynamic DIR code to then create a dynamic delete code...but again....REALLY?? Any advice would be greatly appreciated!Thanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 16:23:25
|
| Yes that is true about log shipping. We setup a copy job on the primary server to get the full backups over, and the a delete job on the secondary server to purge the old backups.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Log Shipping doesn't do what?!?!?