Backup the MDF and LDF files

Backup the BAK files.

Before you begin

Procedure

  1. In Windows, select Start > Run and type Services.msc. Press Enter.
  2. Locate and right-click SQL Server (HCNSQL07).
  3. Select Stop.
  4. 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\
  5. 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
  6. Paste the files to the backup location (C:\HCN\Backups)

Results