Hi there,
Just wanted to ask is it possible to 'restore' a SQL Server 2005 backup file into SQL Server 2000.
What I mean is that we are being supplied with a SQL Server 2005 backup file, but we currently use 2000? Can we use this or do we need to upgrade etc?
Thanks.
Simon Jefferies
Ho, you can′t use that. You will have to do an export of the database from SQL Server 2005 and import the exported content inot the database. If you have a direct connection between the two instance you can use any export / import wizard (like dts) for the work.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||by using import/export wiz we can only import/export tables & views, what about other objects like SP, triggers, user functions etc?
No comments:
Post a Comment