SQL2000 database used to build back up sql2005 database can not be reversed
SQL2000 database has been backed up in sql2000 Enterprise Manager restore point there is no problem now with SQL2005 Enterprise Manager, as the first step to restore a new database of the same name, this database and then right-point task> to restore> Database> ; Point document> selected to back up the database, suggesting a different database! !
to solve urgent! !
version of the question I would like it.
do you say if you give it a try, you put the data in SQL 2000 with lead EXCEL Out.
And then guide it in SQL 2005 to take a look, “
Then you restore your SQL 2000 is the path of a physical address.
..Version may be incompatible with the version, Lead to the data can not be reversed.First:
attention to the second path:to restore the database in a newly restored when not to revert to the old place, try
Sql 2000 database backup file to restore Sql 2000 database and restore the Sql Server 2005 database, which is the key to the Sql 2000, when it is necessary to restore the new database and, in Sql 2005, when the need is not new to its database in order to restore.Another difference is that Sql 2000 When is the new name of the database with the same name of the original library, and Sql 2005 when they enter the name of the database can be an arbitrary name, and do not have to name the same as the original database.
Leave a Reply
You must be logged in to post a comment.