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.