Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sql 64 bit and 32bit issue

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-02 : 07:59:44
Jaison writes "Dear team,

Could you please help me to clear the below doubts.

1)Restoring a database from sql 2000 32bit to sql 2000 64bit.
2)Restoring a database from sql 2000 32bit to sql 2005 64bit.
3)Restoring a database from sql 2000 64bit to sql 2000 32bit.

Please help me to get these doubts clarified."

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2006-03-02 : 16:23:43
No problem for any of those scenarios. Restoring to and from 64bit from 32bit is a supported scenario. The only thing to remember is that once a database has been restored to SQL2005 you cannot subsequently restore a new backup of that database to SQL2000 as the database will have been upgraded.

HTH
Jasper Smith
Go to Top of Page
   

- Advertisement -