Is it possible to backup/restore a SQL database from a 64-bit, SQl 2008 R2 instance --> 32-bit, SQL Server 2000 instance? I am thinking its not - just looking for confirmation.
Thanks!
Printable View
Is it possible to backup/restore a SQL database from a 64-bit, SQl 2008 R2 instance --> 32-bit, SQL Server 2000 instance? I am thinking its not - just looking for confirmation.
Thanks!
No, you can not restore to older version of SQL Server. Your one choice is to use SSIS to copy tables and data.
Thought so. Sounds like I need to upgrade that server.
Thanks for the confirmation.