January 17, 2005 at 7:49 am
Hai,
Is it possible to restore a SQL 2K Backup at SQL 7
I tried it, it is giving error
any suggestions ?
January 17, 2005 at 7:57 am
No, but you can use dts to export/import the data.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 17, 2005 at 7:58 am
No, I don't think this is possible in that direction. Probably the easiest way is to use DTS or BCP.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 17, 2005 at 12:07 pm
I wonder if setting the database compatibility level to 70 will work?
Restore the backup to SQL Server 2000. Then, within enterprise, select the properties of the database and go to the options tab. There, you will see the compatibility level. Set that to 70 and then back up the database to a new file. Try to restore in 7.0.
Sorry I can test this. It's just a theory right now.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply