SQL 2005 backup data to SQL 2004 SP4

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

Old Forums

CLOSED - General SQL Server

SQL 2005 backup data to SQL 2004 SP4

Author

Topic

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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-15 : 00:34:37

You can't restore a 2005 database to 2000.

raclede
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.

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

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

I have not verified the steps myself, so YMMV.

-ec

Kristen
Test

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.

Kristen

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

Thanks
Bjorn

If you need more information just let me know!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources