Backup the MDF and LDF files
Backup the BAK files.
Before you begin
Procedure
- In Windows, select Start > Run and type Services.msc. Press Enter.
- Locate and right-click SQL Server (HCNSQL07).
- Select Stop.
-
Via Windows Explorer, browse to the location of your Bluechip database. It can be found in
one of the following locations, depending 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\ -
Copy (do not 'cut') the following databases:
- Practice Database Files (usually named with Practice Name or Doctor's name)
- BCpractice.MDF
- BCpractice_log.LDF
- Manage Ezy Database Files
- HCN_MNGEZY.MDF
- HCN_MNGEZY_LOG.LDF
- Practice Database Files (usually named with Practice Name or Doctor's name)
- Paste the files to the backup location (C:\HCN\Backups)