Is it possible to restore a SQL 2005 backup to a SQL 2000 server?
-ShawnNo.
Since SQL 7.0, you can always restore to a later version, but you cannot
restore to an earlier version.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Shawn" <Shawn@.discussions.microsoft.com> wrote in message
news:66BDA08B-3247-4C39-8B7B-49EB2EE5D01B@.microsoft.com...
> Is it possible to restore a SQL 2005 backup to a SQL 2000 server?
> -Shawn|||Script database.
Execute it on SQL Server 2000.
Use DTS or Integration Service to transfer data.
Regards
Amish Shah
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment