| Author |
 Topic  |
|
|
cvacumar
Starting Member
5 Posts |
 Posted - 02/15/2007 : 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)
Singapore
16745 Posts |
Posted - 02/15/2007 : 00:34:37
|
You can't restore a 2005 database to 2000.
KH
|
 |
|
|
raclede
Posting Yak Master
Philippines
180 Posts |
Posted - 02/15/2007 : 00:41:26
|
Just use DTS to transfer data between SQL Servers if restoring isn't possible.
|
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 02/15/2007 : 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
Netherlands
111 Posts |
Posted - 03/28/2007 : 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!
|
|
|
| |
Topic |
|
SQL 2005 backup data to SQL 2004 SP4
Forum Locked
