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)
 Restoring Databases

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-12-13 : 07:42:13
Chris writes "Hello,

I would like to hear your opinion about restoring a database, which have been backed up using SQL Server Management Studio
(SQL Server 2005), to Miscrosoft SQL Server 2000.
I get the following error :

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)


If there is a command-line function that i can use to bypass this error i would really appreciate it if you could tell it to me."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-12-13 : 07:43:11
Restoring a database to a previous version of SQL Server is not supported:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58603
Go to Top of Page

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-12-14 : 07:42:40
Hi,
Please refer the same issue from SSP :

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11849

:-)
Regards

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
Go to Top of Page
   

- Advertisement -