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.
| 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 |
 |
|
|
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'saMCITP - Database Administrator 2008http://sqlerrors.wordpress.com |
|
|
|
|
|
|
Copy Standby/Read-only database