How to backup your database

You can save the database in 2 ways:

  • Copy database files, or
  • Make an SQL Server backup.

Copy database files

The easier way to preserve your database is to copy the database files to another storage device.

  1. Using the SSMS tool, detach the database: ClosedShow picture

    2. Right-click on the name of the database to be backed up and then Tasks → Detach...

  2. Copy the .mdf and .ldf files to the other storage.

    3. By default, these files are saved in the PcVue installation subfolder named Databases.

  3. Again with the SSMS tool, re-attach the original database. ClosedShow picture

  4. Right-click on Databases → Attach.... ClosedShow picture

    5. Click the Add button and select the original .mdf file of the database.

    Click the OK button.

Your original database files are saved on another storage device and the database is ready for the migration.

SQL Server: Full Backup

A full backup can potentially interfere with regular backup that may be in place on your system.

Contact your database administrator before proceeding.