YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Can you restore SQL2005 to SQL2000 Server? Options
Previous Topic · Next Topic
Potter
#1 Posted : Thursday, August 06, 2009 5:52:03 PM
Rank: Newbie

Groups: Registered

Joined: 7/20/2009
Posts: 3
Location: Pa
I am trying to restore a database that used to be on a SQL 2000 server, it has since moved to a 2005 server but no changes have been made to the DB since the move. When I try to back it up and restore it to a SQL 2000 box I get an error about to many devices. I know I can always script it and recreate it, and I can export and import the data. But for future reference wanted to know if anyone knew of a way to do this? Thanks
Back to top
 Report Abusive | Report SPAM
barrob326
#2 Posted : Thursday, August 06, 2009 5:58:42 PM
Rank: Member


Groups: Registered

Joined: 7/10/2009
Posts: 21
Location: So California
Everything I have read say's you cant get there from here. You cannot backup a SQL 2005 database and restore it to SQL 2000. Microsoft changed it enough that SQL 2000 just does not like it.
Please submit any questions or comments through my website.

http://www.qualitysoftwaredesign.com
Back to top
 Report Abusive | Report SPAM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

FlatEarth Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.3 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.089 seconds.