February 4, 2011 at 10:49 am
Hi,
We have a SQL 2000 Std Edition server running on WIN Std x32. The SQL databases are on SAN storage. We need to migrate to another server running WIN2008 x64 and SQL 2008 Enterprise Edition x64.
The size of the largest database is 1.2TB spread out over 5 files.
Since the databases reside on the SAN can we do a detach and attach?
What do we need to do to migrate?
February 7, 2011 at 1:53 pm
you will get an error when trying to attach a sql 2000 db to a sql 2008. it is best you upgrade the db first or run the sql upgrade advisor.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
February 8, 2011 at 5:58 am
Thanks for the reply. We have other databases running in SQL2008 with a compatibility level of 2000 (80). So your recommendation is to do a side by side upgrade to 2008 on the existing server (32bit) and then can I detach-attach on new server?
Yes we plan on running upgrade advisor on the existing server.
thanks again.
February 8, 2011 at 4:05 pm
Hi, I didn't make any recommendation. MS has a great white paper that address your upgrade question, it can be found here:
but yes, if you plan to do a sidebyside upgrade, afterward, you should be able to attach/detach the db to another sql 2008 server.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply