Posted by Charles MacLean on 08/19/06 09:09

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.

Regards,
Charles MacLean

[Back to original message]