Saturday, February 25, 2012

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/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!|||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:
> 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/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
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 and
compression of your backups.
John
"stephanie" wrote:
> 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:
> > 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/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!|||This is a multi-part message in MIME format.
--090606030107070301080608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
stephanie wrote:
> 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!
>
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
--090606030107070301080608
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
stephanie wrote:
<blockquote cite="midA6738B2B-39F0-4753-AE5D-ACBD170FDA74@.microsoft.com"
type="cite">
<pre wrap="">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!
</pre>
</blockquote>
<font size="-1"><font face="Arial">As John suggest, a backup/restore
might do the job. Otherwise you can look at Replication which can
replicate your data to another database.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--090606030107070301080608--

No comments:

Post a Comment