3d50328d-c733-45e5-b722-e8fa37e6acf2 Posted June 21, 2011 Report Share Posted June 21, 2011 I would like to know what happens if I restore one of my databases to the same server but using the options.. Restore SQL database as (filename) Use custom path for SQL restore log files Make SQL database operational My Destination is the same server as the original backup- but in red lettering is says "replacing corresponding database" I want to use the same server, as it has the correct SQL version installed and has space to restore a database to However, I don't want to overwrite the existing database, just put another copy on the server so I can restore a couple of records. I really need to know what will happen as I don't want to make a mess of things. Thanks everyone Quote Link to comment Share on other sites More sharing options...
Mayoff Posted June 21, 2011 Report Share Posted June 21, 2011 If you restore database to a new name, it will not overwrite anything. You may want to also uncheck "make database operational" so it doesn't get mounted. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.