SQL 2000 Standard Edition : Log Shipping copy problem..
From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 11/29/04
- Next message: Paul Ibison: "Re: replication user"
- Previous message: SouRa: "Re: Setting SEED value for a existing column"
- In reply to: Zul: "SQL 2000 Standard Edition : Log Shipping copy problem.."
- Next in thread: Zul: "Re: SQL 2000 Standard Edition : Log Shipping copy problem.."
- Reply: Zul: "Re: SQL 2000 Standard Edition : Log Shipping copy problem.."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 02:54:28 -0800
I am not too clear on the question, but if the full
database backup has been transferred and restored to the
standby server and log shipping is set up, there is no
further requirement to transfer the database backups. If
it is not yet set up, then if you establish a time when
users can't access the system, you can backup the primary
server's database, zip it up and transfer it. Unzip at
the other end and restore with no recovery or with
standby, and then set up log shipping from scratck while
selecting the option that a database backup is not
required.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
- Next message: Paul Ibison: "Re: replication user"
- Previous message: SouRa: "Re: Setting SEED value for a existing column"
- In reply to: Zul: "SQL 2000 Standard Edition : Log Shipping copy problem.."
- Next in thread: Zul: "Re: SQL 2000 Standard Edition : Log Shipping copy problem.."
- Reply: Zul: "Re: SQL 2000 Standard Edition : Log Shipping copy problem.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
