SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Copy Standby/Read-only database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 11/11/2013 :  20:32:05  Show Profile  Reply with Quote

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.

Constraint Violating Yak Guru

351 Posts

Posted - 11/12/2013 :  09:17:28  Show Profile  Reply with Quote
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.

Go to Top of Page

Starting Member

15 Posts

Posted - 11/17/2013 :  07:02:58  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000