I am trying to restore an existing sql database on server A in an instance X to a new database on the same server A in the same instance X but to a new database.
If I select SQL Redirection do I need to enter the server name and instance or because I am restoring to the same server or is that not necessary?
I have created a new database within the instance X that I want to restore to. The mdf files are currently in C:\Program Files\Microsoft SQL Server\MSSQL$SDS, both the existing and new database files are here.
I want to restore the existing database over my newly created database making sure the exisiting database remains intact. I am unsure which of the Destination Options I should use, whether to select 'Use Path' and if so do I enter the path exactly as above or do I have to type the name of the .mdf file?
Would I then select from the Settings in Microsoft SQL option to Overwrite exisiting database?
Thanks