SQL Server Performance Forum – Threads Archive

Diff betn logshipping and migration

hi!
is there any difference between log shipping and database server migration from sql 2k on 1 server to sql 2k on dest server.
if nay diff point out those..

Log shipping is a process to feed transaction logs from database to another on constant basis with regular interval schedule. And it is a part of database migration, as you can use either BACKUP/RESTORE statements or ATTACH/DETACH process. This allows you to have a backup server and also provides a way to offload query processing from the main computer (the source server) to read-only destination servers. SQL Server 2000 Enterprise Edition must be installed on all servers used in log shipping.
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.

]]>