SQLDBAgeeks
Contact Us
Home
Contact
Services
Tuesday, March 15, 2011
How to migrate databases from MS sql 2000 to MS SQL 2005/2008
There are 4 ways to migrate databases from one server to another:
backup bak files and restore to new server
copy the mdf and ldf files to new server and attached the databases to new server
use the migration wizard to move the objects and databases over
script the entire restore process and run in sqlcmd
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment