February 12, 2009 at 12:09 am
Error msg SQL-DMO(ODBC SQLSTATE:42000
this is the error message i am just trying to restore the backup from MSSS2K5 to MSS2K. PLEASE HELP
February 12, 2009 at 1:02 am
You can’t restore a database to an older version of SQL Server then the SQL Server that the database was backed up from. If you have a backup that was done on SQL Server 2005, you can restore it on SQL Server 2008 or SQL Server 2005, but not on SQL Server 2000.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 12, 2009 at 7:06 am
You can, however, script the 2005 database, create it in 2000 and then export the data. As Adi stated, you cannot restore a backup to an older version.
-- You can't be late until you show up.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply