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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQL 2005 backup data to SQL 2004 SP4
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

5 Posts

Posted - 02/15/2007 :  00:24:59  Show Profile  Send cvacumar a Yahoo! Message
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 - 02/15/2007 :  00:34:37  Show Profile
You can't restore a 2005 database to 2000.


Go to Top of Page

Posting Yak Master

180 Posts

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

Flowing Fount of Yak Knowledge

3575 Posts

Posted - 02/15/2007 :  01:37:18  Show Profile
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


United Kingdom
22859 Posts

Posted - 02/15/2007 :  05:45:10  Show Profile
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 - 03/28/2007 :  10:28:37  Show Profile  Visit neutcomp's Homepage
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000