Diff betn logshipping and migration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Diff betn logshipping and migration

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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.