Search code examples
sql-serversql-server-2014-express

Copy Database using SQL Server 2014 Management Studio Express

I want to quickly overwrite one database with another (preferably using the GUI in Management Studio).

Basically I have DB1 and DB2. DB1 is an older version of DB2 which I need to overwrite, so DB1 = DB2.

I have tried the following;

  • Right Clicking Databases
  • Clicking Restore Databases
  • Selecting the From Database to select DB2 (But for some reason it is not appearing here?)

Any Ideas? I have not been given permissions to create new databases on the system, so I am looking to simple over write the existing database, rather than create, drop, rename, etc.

Solution
    • Back up DB2
    • Restore DB1 from the backup of DB2