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