Restore the .MDF and .LDF Files
Restore the saved .MDF and .LDF files to your new server.
Procedure
-
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\ - Browse to the location of the backup databases.
-
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
- Practice database files:
- Start SQL Server Management Studio. From the Windows Start menu, select All Programs. Locate Microsoft SQL Server, then select SQL Server Management Studio.
-
In the Connect to Server window, check the following is
correct then click Connect.
- Server Type: Database Engine
- Server name: Server Name/HCNSQL07
- Authentication
- In the Object Explorer window, click on the + to expand the databases.
- Right-click Databases > Attach.
- Click Add on the Attach Databases window.
- In the Locate Database File window, select the Bluechip database.
- Click OK.
- In the Attach Database window, click OK.