question

Ramon avatar image
Ramon asked

CREATE AN ONLINE COPY OF A STANDBY DATABASE

HI,

I have log shipping setup between 2 offices through WAN. In the second offce the DB is on standby. I would like to create a database from the standby db so developers can test it, so it will be in read/write mode.

I know i cant backup/restore and sdanby db, i have try using copying but is not working neither, what other options do i have? can i just create an sql query that will copy everything from one DB to another?

I am using MS SQL 2005 Ramon

standby-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.