Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have sql 2005 logshipping. Is it possible to backup current state this database, when is database restoring ? Because i need database from previous day for testing.

share|improve this question
up vote 2 down vote accepted

It's no possible to backup database in warm-stanby mode.

You can backup your primary database with COPY_ONLY option (BACKUP DATABASE database_name TO … WITH COPY_ONLY …). It preserves the existing log archive point and, therefore, does not affect the sequencing of log shipping transaction logs backups. Then restore this backup at specified point of time using SQL Server Management studio or sql script using 'RESTORE DATABASE ... WITH STOPAT ...' command.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.