Copy a standby/readonly database

Any idea to copy a standby/readonly database. We a have a standby/readonly
DB from logshipping for hot standby and we would like to make a copy of this
standby/readonly DB into a read/write DB in the same server for daily
testing. Thanks in advance!Hi Stephanie
Why not take a backup of the original database and restore it?
John
"stephanie" wrote:

> Any idea to copy a standby/readonly database. We a have a standby/readonl
y
> DB from logshipping for hot standby and we would like to make a copy of th
is
> standby/readonly DB into a read/write DB in the same server for daily
> testing. Thanks in advance!|||The original DB is in another server. This is a daily restore in standby
server and the database is about 50GB. it will be heavy load to copy the
files through the network and time consuming to restore the full backup.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Stephanie
> Why not take a backup of the original database and restore it?
> John
>
> "stephanie" wrote:
>|||Hi
If you had only wanted a readonly database you could have included it in the
log shipping, but I know of a other way of doing this to make it writable.
You may want to look at Litespeed
http://www.quest.com/litespeed_for_sql_server/ to improve the performance an
d
compression of your backups.
John
"stephanie" wrote:
[vbcol=seagreen]
> The original DB is in another server. This is a daily restore in standby
> server and the database is about 50GB. it will be heavy load to copy the
> files through the network and time consuming to restore the full backup.
> "John Bell" wrote:
>|||stephanie wrote:
> Any idea to copy a standby/readonly database. We a have a standby/readonl
y
> DB from logshipping for hot standby and we would like to make a copy of th
is
> standby/readonly DB into a read/write DB in the same server for daily
> testing. Thanks in advance!
>
As John suggest, a backup/restore might do the job. Otherwise you can
look at Replication which can replicate your data to another database.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator