SQL Server Performance Forum – Threads Archive

Log-Shipping & SQL Server 7 (Recovery Model)

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?

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.

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.

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.

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!

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.

]]>