SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

cvacumar
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???
ASAP Plz

khtan
In (Som, Ni, Yak)

Singapore
17598 Posts

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


KH

Go to Top of Page

raclede
Posting Yak Master

Philippines
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

eyechart
Flowing Fount of Yak Knowledge

USA
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:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1

I have not verified the steps myself, so YMMV.



-ec
Go to Top of Page

Kristen
Test

United Kingdom
22403 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.

Kristen
Go to Top of Page

neutcomp
Posting Yak Master

Netherlands
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?

Thanks
Bjorn

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.09 seconds. Powered By: Snitz Forums 2000