Archiving a Log Database partition

To archive older data, start by using the Microsoft SQL Server backup process, then take the partition offline and move it to a longer-term storage location.

Steps

  1. Open SQL Server Management Studio and log on to the SQL Server instance that hosts your Log Database.
  2. In the Object Explorer, under Databases, locate the partition you want to archive. By default, the name takes the format wslogdb70_n, where “n” is the partition number).
  3. Right-click the partition and expand the Tasks menu, then select Back Up.
  4. In the Back Up Database window, you can either accept the default backup Destination, or click Add to specify a new path for the backup file.
  5. When you are finished, click OK to run the backup.
  6. When a prompt indicates that the backup process is complete, click OK.
  7. Right-click the partition in the Object Explorer again, then select Take Offline.
  8. Close Microsoft SQL Server Management Studio.
  9. Move the partition to your long-term storage location.