How can I clone an SQL Server database on the same server in SQL Server 2008 Express?

by

  1. Install Microsoft SQL Management Studio, which you can download for free from Microsoft’s 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

  2. Open Microsoft SQL Management Studio.

  3. Backup original database to .BAK file (db -> Task -> Backup).
  4. Create empty database with new name (clone). Note comments below as this is optional.
  5. Click to clone database and open restore dialog (see image)
    restore dialog
  6. Select Device and add the backup file from step 3.
    add backup file
  7. Change destination to test database
    change destination
  8. Change location of database files, it must be different from the original. You can type directly into text box, just add postfix. (NOTE: Order is important. Select checkbox, then change the filenames.)
    change location
  9. Check WITH REPLACE and WITH KEEP_REPLICATION
    with replace

More Related Contents:

  1. How to create jobs in SQL Server Express edition
  2. Limitations of SQL Server Express
  3. How to get the last row from a table in SQL Server?
  4. Alias name is same as column name [closed]
  5. Understanding PIVOT function in T-SQL
  6. The order of a SQL Select statement without Order By clause
  7. Storing a file in a database as opposed to the file system?
  8. SQL Server named instance with Visual Studio 2017 Installer project
  9. Preferred Method of Storing Passwords In Database
  10. How do you count the number of occurrences of a certain substring in a SQL varchar?
  11. Why is it considered bad practice to use cursors in SQL Server?
  12. Import Excel spreadsheet columns into SQL Server database
  13. Find index of last occurrence of a sub-string using T-SQL
  14. Hidden Features of SQL Server
  15. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  16. SQL Server 2008 Empty String vs. Space
  17. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  18. How do I exclude Weekend days in a SQL Server query?
  19. Best data store for billions of rows
  20. newid() inside sql server function
  21. How do I list all tables in all databases in SQL Server in a single result set?
  22. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  23. SQL Server 2008 Vertical data to Horizontal
  24. Joining multiple tables returns NULL value
  25. Which join syntax is better?
  26. LPAD in SQL Server 2008
  27. How to maintain the order of insertion in SQL Server
  28. SQL Server 2008 can’t login with newly created user
  29. Update SQL with consecutive numbering
  30. Nested transactions in Sql Server

Leave a Comment