backup

Documentation

Overview

Command backup demonstrates gosmo's backup and restore surface: a full backup with live progress reporting, reading a backup device's headers and file list, verifying it, a differential and a log backup appended to the same media, the backup history in msdb, and a restore that relocates the database's files.

It works on a throwaway database it creates itself, and drops it at the end. The backup device it writes stays on the server — SQL Server has no "delete file" verb, so remove it yourself if you care.

MSSQL_SERVER=localhost:1433 MSSQL_USER=sa MSSQL_PASSWORD=YourPw go run ./examples/backup