February 23, 2011 at 7:54 am
Here's what I have
Server A on the east coast is configured as a log shipping source to server B in chicago.
We're shipping a single 670 GB database periodically from A to B
Our Implementation Team wants to periodically capture a copy of the database without distubring the log shipping any more than necessary. They need this to do conversions of the source database to our application.
Is there any way I can grab a copy of the database on server b (in standby mode) to give to them that they can attach or restore? For SQL 2000 it looks like the answer is no. It's been so long since I worked with log shipping on SQL 2000 that I'm not 100% sure and google keeps turning up 2005 and 2008 references to my searches.
I was thinking that I could possibly code my own log shipping system instead to get around this, but even then I have the issue with a standby database.
February 23, 2011 at 8:00 am
Just noticed this on 2000.... been too long for me as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply