Options

How to skip backup/copy while setup log shipping ?

awuawu Posts: 15
edited January 15, 2008 1:16PM in SQL Backup Previous Versions
:?:

We are seting up log shipping from SQL Server 2000 to SQL Server 2005, but the wizard always trying to backup frist and copy over , how can skip this two processes ? Thx.
xunren
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    You could perform a full backup on the production server, and restore it on the standby server in norecovery/read-only mode. If you do this, you can skip the full backup and restore process.

    Is this what you are referring to?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Options
    awuawu Posts: 15
    I know, Peter, and that's what i did -- perform a full backup on the production server, and restore it on the standby server in norecoverymode.

    But when i setup a log shipping using the wizard, it do it again, i did not find a way to bypass the two process.
    xunren
    · Share on Twitter
Sign In or Register to comment.