I did not ready about this but found out after trying to restore a database from remote server and it wont restore if the database did not exist before. What I would do is
- create a .bak file (backup the database)
- Copy the .bak file to the remote server using shared folder
- Run restore in SQL Server Management Studio to restore the database
It will give me error. I think I found it almost accidently (or out frustration, just restored it on top of the database, and it worked).
Now as I am typing the question, I realize move is probably not the same thing as restore. For restore, the database must already exist?
I am in the same position again to restore a database which does not exist on my system.
1. What procedure do I follow?
2. Do I need to set permission on the .bak file before restoring successfully on remote Server?
3. Or is there a better way?
Am I missing anything? I would like to know, what are the rules when restoring (or moving) the database.
Edit : Adding the dialog error. I just repeated the process. I am not sure this was the exact error I was getting before. I renamed the original db that I have. Then I import using SSMS.