If you perform a restore operation to move the database back to its original location, the database files will not be moved back as the database already exists on the server. The restore job will only check the database name and will restore the database on top of the same database regardless of its location. To move the database files back to the original location, use one of the following workarounds:
-
Detach and re-attach the database.
-
Perform a full backup of the database before moving the database back to its original location.
-
Drop the database from the SQL Server instance and perform a restore with the default values.