Clone an SQL Server database on the same server in SQL Server 2008 Express

Install Microsoft SQL Management Studio, you can download it for free from Microsoft website: Version 2008 Microsoft SQL Management Studio 2008 is part of SQL Server 2008 Express with Advanced Services Version 2012 Click download button and check ENU\x64\SQLManagementStudio_x64_ENU.exe Version 2014 Click download button and check MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe Open Microsoft SQL Management Studio Backup original database to file (db -> Task -> Backup). Create empty database with new name (clone). Click to clone database and open restore dialog (see image) Select Device and add the bakcup file from step 1. 4.Change destination to test database Change location of database files, it must be different from the original. You can type directly into text box, just add postfix. 6.Check WITH REPLACE and WITH KEEP_REPLICATION   Source : http://stackoverflow.com/questions/3829271/how-can-i-clone-an-sql-server-database-on-the-same-server-in-sql-server-2008-exp