Wednesday, March 28, 2012

Log shipping to another server with a different database name.

SQL Server 2000.
What are the steps for log shipping a database to another server ,b ut you
want to use a different database name on the secondary server?Delton
start with
http://www.sql-server-performance.c...og_shipping.asp
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:uqvSzqD3GHA.4924@.TK2MSFTNGP05.phx.gbl...
> SQL Server 2000.
> What are the steps for log shipping a database to another server ,b ut you
> want to use a different database name on the secondary server?
>|||Delton Blackwell wrote:
> SQL Server 2000.
> What are the steps for log shipping a database to another server ,b ut you
> want to use a different database name on the secondary server?
>
If you're using your own scripted log-shipping solution, simply change
the RESTORE command that restores your backups. Change it to create a
database with a different name.
If you're using the log-shipping wizard gizmo, then I have no idea, I've
never used it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment