Move Database To New Machine
- From: "Charles MacLean" <charlesmaclean@xxxxxxxxxxxxx>
- Date: Sat, 19 Aug 2006 00:11:26 GMT
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 with a slightly different 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
.
- Prev by Date: Recommendation for tools converting access databases to SQL
- Next by Date: Re: Recommendation for tools converting access databases to SQL
- Previous by thread: Recommendation for tools converting access databases to SQL
- Next by thread: where to start learning
- Index(es):