If I download a backup of a database and store it on my hard drive, when I go and restore the database, will the restore process create a copy of that file and move it to the sql server folder i.e. /data/mydatabase or will it just reference the original file location?
1 answers
When you are doing a database restoration (assuming you are using sql management studio), after you choose the location of the source, you check the checkbox and it will restore your database.
If you look at the left pane, you will see options. It shows the location to where the restore process will save the files:
So it creates a copy of the file, and renames it to the name of the database you chose (restore as ...).
answered 2 years ago by:
761
246
@rick_a your right, which makes sense. I was just concerned that if I restore a local backup copy, and make changes locally it won't effect my backup file (since its archived).