Creating new database from a backup of another Database on the same server?

by

What I should to do:

  • Click on ‘Restore Database …’ float menu that appears right clicking the “Databases” node on SQL Server Management Studio.
  • Fill wizard with the database to restore and the new name.
  • Important If database still exists change the “Restore As” file names in the “Files” tab to avoid “files already in use, cannot overwrite” error message.

What I do

IDk why I prefer to do this:

  • I create a blank target database with my favorite params.
  • Then, in “SQL Server Management Studio” restore wizard, I look for the option to overwrite target database. It is in the ‘Options’ tab and is called ‘Overwrite the existing database (WITH REPLACE)’. Check it.
  • Remember to select target files in ‘Files’ page.

You can change ‘tabs’ at left side of the wizard (General, Files, Options)

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)