Restore the .MDF and .LDF Files

Restore the saved .MDF and .LDF files to your new server.

Procedure

  1. Browse to the location of your Bluechip HCNSQL07 instance in either of the following locations, according to your SQL version:
    OS Version SQL Version Folder Location
    32 Bit SQL 2005 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
    SQL 2008 C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07\MSSQL\DATA\
    SQL 2008 R2 C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\
    64 Bit SQL 2005 C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ MSSQL\Data\
    SQL 2008 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\
    SQL 2008 R2 C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07\ MSSQL\DATA\
  2. Browse to the location of the backup databases.
  3. Copy (do not cut) the Bluechip database to the HCNSQL instance location.
    • Practice database files:
      • BCpractice.MDF
      • BCpractice_log.LDF
    • Manage Ezy database files:
      • HCN_MNGEZY.MDF
      • HCN_MNGEZY_LOG.LDF
  4. Start SQL Server Management Studio. From the Windows Start menu, select All Programs. Locate Microsoft SQL Server, then select SQL Server Management Studio.
  5. In the Connect to Server window, check the following is correct then click Connect.
    • Server Type: Database Engine
    • Server name: Server Name/HCNSQL07
    • Authentication
  6. In the Object Explorer window, click on the + to expand the databases.
  7. Right-click Databases > Attach.
  8. Click Add on the Attach Databases window.
  9. In the Locate Database File window, select the Bluechip database.
  10. Click OK.
  11. In the Attach Database window, click OK.

Results

The .MDF and .LDF files are restored on the new server.