How to move database backup archives

You might need to move a database backup archive due to insufficient space, server migration, etc. To do so and at the same time maintain the possibility to connect the archives to Safetica Management Console, a specific procedure must be followed.

To move archives, first create the destination folder and follow these steps:

  1. Right click the folder > Properties > Security.
  2. Set Full control permissions for Authenticated Users and SQL Service Account*(NT SERVICE\ServiceName) for the destination folder.
  3. Move selected archives into the destination folder.

  4. Navigate to the Maintenance > Database management > Archives section in Safetica Management Console.

  5. Remove the archives which were moved to the new location.

  6. Import archives from the new location.

*To find the Service Name, open services.msc and right click SQLServer > Properties.

In some specific cases, the archive will not attach to the database automatically and instead of connecting the archive, nothing will happen. 

This can be fixed by attaching the archive manually to the MS SQL Management service:

  1. Install SQL Management Studio and connect to the database via admin account.

  2. Right click Databases > Attach…

  3. Click Add…, select the archive, and click OK.

  4. Navigate to the Maintenance > Database management > Archives section in Safetica Management Console.

  5. Click View content for the respective archive.

  6. Now you can view the records and Close the archive once done.