September 1, 2011 at 3:13 am
harita (8/31/2011)
perry,but there are some scripts i guess i saw some people doing it
If you want to concoct your own scripted LS process that would be viable, either way the database may only ever be in the restoring state. The link Ignacio posted is one example, i'm sure there are many more if you search
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 6:52 am
Hi All
Thank you all guys i got some scripts with your help and hope these will work, keep you posted
Thank you All
September 2, 2011 at 1:38 am
More you test the scripts... less problems you will get.:-)
-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
September 2, 2011 at 4:50 am
Hi,
You can do this , better you can create your custom scripts for backup and restore instead of MS standard log shipping. this makes you job easier.Just backup the logs and restore it in your Dev environment. Are you going to use that database (Dev) for any reporting purpose ? what is the requirment behind this work ?
Reagrds
Raju
September 2, 2011 at 4:52 am
Hi,
You can do this , better you can create your custom scripts for backup and restore instead of MS standard log shipping. this makes you job easier.Just backup the logs and restore it in your Dev environment. Are you going to use that database (Dev) for any reporting purpose ? what is the requirment behind this work ?
Reagrds
Raju
September 2, 2011 at 5:47 am
rajughy_ghy (9/2/2011)
Are you going to use that database (Dev) for any reporting purpose ?
Hopefully not, as the log shipped database would have to be recovering (standby is not an option when upgrading) and hence inaccessible
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply