SQL Server Performance

Log-Shipping & SQL Server 7 (Recovery Model)

Discussion in 'SQL Server Log Shipping' started by hmekhsian, May 19, 2004.

  1. hmekhsian New Member

    What's the equivalent of turning on 'Full' recovery in SQL Server 7?

    I'm guessing I need to uncheck the 'Select Into' and 'Truncate Log on Checkpoint' options, but I'd rather ask than do this on a live server.

    Anything else that needs to be done on SQL Server 7 (compared to 2000), before LS can be set-up?

    Thanks

    Bonus Question: Will LS work between a SQL Server 2000 and SQL Server 7 database?
  2. satya Moderator

    What's the equivalent of turning on 'Full' recovery in SQL Server 7?
    Yes, unchecking both 'Selct/Into & Trunc.log at chkpt.' will enable this recovery model and you will be able to perfrom transaction log backups.

    Log shipping is introduced in SQL 2000 and will not work for ver.7 server, rather you can design your own log shipping as stated in this article :http://www.sql-server-performance.com/sql_server_log_shipping.asp



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. hmekhsian New Member

    Thanks satya.

    Regarding the second question... I did use that guide to create my LS on 2000, very helpful. I'm just wondering if I can ship the logs of SQL Server 7 Database to a SQL Server 2000 database.

    In other words, the warm-standby database is on a SQL Server 2000 Server, and the live database is on a SQL Server 7 Server.

  4. satya Moderator

    Yes with user-defined process for BACKUP & RESTORE logs you can deploy the log shipping, but here you would be having issues whenever the secondary server (Sql 2K) to be used as primary and you will not be able to restore SQL 2K logs onto SQL 7 databases.

    To ease the log shipping process, ensure both primary and secondary servers has similar version including service packs on SQL & OS.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. hmekhsian New Member

    Thank you satya... Final question!

    Can these two options ('Select Into' and 'Truncate Log on Checkpoint') be turned on and off on a live database without repurcussions? I.e. no restarts, no outage, etc...

    Thanks!
  6. satya Moderator

    Yes ofcourse.
    If they are ON then ensure you maintain regular backups in scheduled intervals as the recovery is based on the end of any backup.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page