SQL2012 Restore the database operation on the local server and with other computers far thread attached to the server to operate the file path differences

On the database server, when you want to restore a database to a backup file, the server's database file itself is stored in the

D:\DEVDB Directory

Connect to a database server operation restore by developing MS Manager on your computer

Although a file card entry is found, the original file name differs from the path to "revert to"

However, because you want to choose the "Overwrite existing database" method to restore, like the previous operation sql2000, the restored database will automatically replace the original file

As a result, the database file under the D:\DEVDB directory was found to be missing, but was moved to the C:\Program Files\Microsoft SQL Server\mssql11. The Mssqlserver\mssql\data video is the same as the path on the "file" card item seen in the previous figure. This is not what you want to expect ...

-----------

But the same restore operation, if you operate on the server natively, the restored "file" option interface will be

The original file is consistent with the restore.

In this way, it is best to restore operations in the local server to make it easier, or every time you want to modify the restored path ...

Although you can modify the default path for all database files saved in the database settings

SQL2012 Restore the database operation on the local server and with other computers far thread attached to the server to operate the file path differences