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

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQL 2005 backup data to SQL 2004 SP4

Author  Topic 

Starting Member

5 Posts

Posted - 2007-02-15 : 00:24:59
Hi All
I have a problem in transferring a 2005 backed up database to SQL Server 2000 SP3.
i got an error message, crux of it is
"too many backup devices specified only 64 allowed"

the i browsed MICROSOFT help, downloaded SQL 2000 SP4 - mentioned as a fix for the above error.

Now get a message,crux of it is
"current version of Database in 611 and destination version is 536"

Is there a solution????
should i download any other patches or
Should i tweak the SQL 2005 backup process???

In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-15 : 00:34:37
You can't restore a 2005 database to 2000.


Go to Top of Page

Posting Yak Master

180 Posts

Posted - 2007-02-15 : 00:41:26
Just use DTS to transfer data between SQL Servers if restoring isn't possible.
Go to Top of Page

Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-15 : 01:37:18
I also ran across a detailed walkthru in a thread about downgrading a database from SQL 2005 to SQL 2000 that you might find useful:

I have not verified the steps myself, so YMMV.

Go to Top of Page


22859 Posts

Posted - 2007-02-15 : 05:45:10
I've read the steps and they look good to me.

I'm not sure it covers copying Logins/UserIDs from 2005 -> 2000 ... nor any scheduled JOBs ... but I reckon it does a good job for the Database structure, tables and data.

Go to Top of Page

Posting Yak Master

111 Posts

Posted - 2007-03-28 : 10:28:37
Hello everyone,

Great Tutorial only the last step to restore the Foreign Keys and Triggers is not working for me:

----- Action -----
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Account]') AND type in (N'U'))

----- Result -----
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.

I hope someone can tell me what I am doing wrong. I did the tutorial twice I thought maby I did something wrong... but I think i did to it exactly as he told me so.

Maby the problem is that the two servers (2000/2005) are running on the same machine?


If you need more information just let me know!
Go to Top of Page

- Advertisement -