|Subject:||Move Databases on SQL 2000 Machines|
|Posted by:||Charles MacLean (charlesmacle…@sbcglobal.net)|
|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.