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.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Copy Standby/Read-only database

Author  Topic 

songket
Starting Member

1 Post

Posted - 2013-11-11 : 20:32:05
Hi,

warning: i'm newbie in this field

I have a Standby/Read-only database from log shipping (eg: LS_Database1) and would like to copy that Standby/Read-only database into read-write database in the same server for daily testing purpose.

I want to use backup and restore approach, but then the Task > Backup (button) is disable. I have tried the Task > Copy Database but result error at the last step Execute SQL Server Agent Job.

Thanks in advance.

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-11-12 : 09:17:28
When a database is in Standby/Read-only you can look at the data (run a SELECT query) within the database but you would have to do a restore on the database. See: http://msdn.microsoft.com/en-us/library/ms176039.aspx however this breaks log shipping.



djj
Go to Top of Page

Prav4u
Starting Member

15 Posts

Posted - 2013-11-17 : 07:02:58
you can also take a backup from production server with copy_only option then restore that copy for testing purpose.

Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Go to Top of Page
   

- Advertisement -