How to clone database with SSMSⓔ

Overview:

Clone new database can allow user use existing data to do testing without effect on live database.

Solution:

There are few ways to clone database. In this guideline will show backup and restore as new database.

Can refer to this guideline to backup database via SSMS.

How to Backup a Database using SQL Management Studio

Note: make sure while restore is select RESTORE WITH RECOVERY, otherwise existing database will change to RESTORING state

If database is change to RESTORING state, can run below script.

RESTORE DATABASE [YourDatabaseName] WITH RECOVERY;

1. Open SSMS and connect to your SQL Server instance.

2. Right-click on the Databases folder in SSMS and select Restore Database.

3. Under Source, select Device and browse to the .bak file created earlier.

4. Under Destination, specify the name of the new database.

5. In the Files section, ensure that the logical file names are updated to avoid conflicts.