Move Databases on SQL 2000 Machines

Giganews Newsgroups
Subject: Move Databases on SQL 2000 Machines
Posted by:  Charles MacLean (charlesmacle…
Date: Sat, 19 Aug 2006

I need to move our production database to a brand new machine on our LAN.
Both machines are running SQL2K.  I'd like to place the production database
in a directory on the destination machine with a slightly different path
name than the source SQL server.
How can I shrink the transaction log to the minimum size before I try the
move?  What is the best way to move the database to the new machine?  We
have Veritus Backup Exec.

Charles MacLean