Attaching databases of sql 2000
I have few databses of sql 2000 on windows 2000. Can I attach these databases to another instance of SQL Server 2000 on anothermachine having windows 2003 installed?? D开发者_如何学Gooes attach and detach of databases are platform independent??
You should be able to attach and detach databases of the same SQL Server version across different Windows OSes.
I believe you can detach and re-attach from the same SQL version; however this can cause issues so it would be best if you backed up the database from the original server, create a new database on the new server of the same name and then restore it into it.
Windows version shouldn't make a difference.
精彩评论