Create the Clone Database

Before you begin

Back up ProductionDB.

Procedure

  1. Access SQL Server Management Studio (SSMS).
  2. Create CloneDB from the backup of ProductionDB by using the Restore Database feature of SSMS.
    Note:
    For more information, refer to the SSMS documentation.
    Important:
    • For best performance, create CloneDB in the SQL server instance that hosts ProductionDB.
    • While restoring the database files, relocate the files of Rows Data and Log file types, and then rename the relocated files <ClonedDatabaseName>.mdf and <ClonedDatabaseName>_log.ldf respectively.
    • While specifying the restore options, in the Recovery state box, select RESTORE WITH RECOVERY.

What to do next

Filter CloneDB.