MSSMS notes

Procedure to duplicate a database in MSSMS

1. Make a backup of the source database

Click on the database to copy and choose “Backup” under tasks.

2. Use copy only or use a full backup

Choose “copy-only” backup.

3. Use “Restore” to create a new database

Don’t create a database manually. Use the “restore” option.

4. Choose the copy-only backup and choose a new name

In this dialog you can name the “copy” database and choose the copy-only backup from the source database. Click "Options" on the left hand side.

Uncheck "Take tail-log backup before restoring"

Tick the check box - "Close existing connections to destination database".

Now click ok and you are done.

Simple connectivity test

Create a new file anywhere - a text file on your desktop.

Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension).

Select "Yes" when asked if you want to change the file extension.

This will give you a Data Link Editor that allows you to test the connection.