When transferring a db from own server to another (different locations), and going from SQL 7 to SQL 2000, is it better to make a backup file from one and restore it to the other, or to copy the .log and .mdf files and put them on the next server? What are the advantages and disadvantages of each way?
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.