SQL Server 2000 "Device activation Error" Workaround _mssql

The operation of data in a database is a major skill, in which the recovery and restoration of data is often done. I don't know if you encountered an error message in database recovery, such as "Device activation error, use the WITH MOVE option to flag a valid location for the file"? I don't know if you're still in this situation: when you restore a database, you find that in Enterprise Manager, operations: All Tasks--> Restore the database--> Select Restore from device, locate the backup document path, and force restore. Error: Device activation errors, please use the WITH MOVE option to flag the valid location of the file. This article will explain to you how this error should be resolved.

Workaround: Right-click "Database" (note not a particular database)--"All Tasks--" restore the database--"restore from Device", select the name of the database you want to revert to, and then in the tab, select the Force restore database on the most existing database, and then modify the physical path after the database restore below , this path if there is a path, otherwise there will be the above error, logical file name can not be changed. Turns out it's the wrong path.

Turn another wrong solution that may be used later.

How do I change the owner of SQL Server 2000 's user table to dbo instead of the user name?

Method One: Right click on the table-the design table, in a row of small icons above, point the last "conditional constraint", point "Table" page, change the owner inside.

Method Two: Use script to execute directly, use SYSTEM account or super user to log into this database, then execute the following statement:



(Note: The second method can only be used once, the second use will be wrong)

Workaround Three:

I believe many friends face this problem head is big, then on the network search for similar problems when the solution is basically the same, the result is the same, that is, can not solve the problem, I was also the head of a few days, in the installation, unloading n times is not solve the problem, in the version of the difference, Database structure is inconsistent in the hesitates to explore, and then in a casual restore database found a solution, specific as follows (only my problem solution, other types can be borrowed):

Pre-Preparation: The SQL Server 2000 file has been backed up, the file name is added suffix (. bak, SQL Server 2000 backup is usually the suffix)

Already installed SQL Server 2000;

To restore a database procedure:

One, open "Enterprise Manager", find the database that option, create a new database (testdata);

Second, right click on the new Database (testdata), select "All Tasks"-> "restore the Database" in the pop-up dialog box select "From the Device", click "Select Device" to find the data previously backed up,

A dialog box such as an icon appears after a continuous "OK":

Third, and then click: "Options",

In the dialog box that appears, select "Force Restore on existing database", the most important content is below: The two files below the logical file name do not care about it, just look at the "Move to physical file name" in the following two options, be sure to select the SQL Server 2000 installation directory. My side is because the directory set to the D disk and error (d disk is where I install the management directory,) that is, "physical filename" must be the same as the installation directory of SQL server2000; Refer to the following figure: