Regira.DAL.SqlServer 6.5.0

Regira DAL — SQL Server

Regira DAL.SqlServer provides SQL Server backup/restore through the server's own BACKUP DATABASE / RESTORE DATABASE (settings, options, and backup/restore services — no CRUD or communicator surface). No client tools are needed: both statements run over an ordinary connection.

Projects

Installation

<PackageReference Include="Regira.DAL.SqlServer" Version="6.*" />

SqlServerSettings

var settings = new SqlServerSettings("localhost", "shop", "sa", "pass");
string cs    = settings.BuildConnectionString();

For any other authentication mode (Microsoft Entra ID, a managed identity), set SqlServerOptions.ConnectionString instead of DbSettings. Microsoft.Data.SqlClient 7 ships those Authentication=Active Directory … modes in a separate package, so the application also references Microsoft.Data.SqlClient.Extensions.Azure.

SqlServerBackupService / SqlServerRestoreService

Both work on the database named in the connection (Database / Initial Catalog).

var options = new SqlServerOptions
{
    DbSettings      = new SqlServerSettings("localhost", "shop", "sa", "pass"),
    BackupDirectory = @"D:\SqlBackups",
    Overwrite       = true
};

// second parameter is an optional ILogger
IMemoryFile backup = await new SqlServerBackupService(options).Backup();
await new SqlServerRestoreService(options).Restore(backup);

The backup directory

SQL Server writes and reads the .bak file itself: on its own file system, under its own service account. BackupDirectory is therefore required, and it must be reachable from both sides — SQL Server's service account and this process each need read and write access.

BackupDirectory is the path as SQL Server sees it. LocalBackupDirectory is the same directory as this process sees it, and defaults to BackupDirectory, which is right when both run on one machine.

The instance's own backup folder (MSSQL\Backup) usually admits only the service account and administrators, so an application can rarely read it. Every call uses a new file and deletes it afterwards; a file this process cannot delete is left in place with a logged warning. When a backup cannot be read because LocalBackupDirectory does not lead to it, SQL Server is asked to delete the file itself (xp_delete_files, or xp_delete_file before SQL Server 2019), which needs sysadmin; without it, the warning names the file left on the server.

Backup

Backup() takes a copy-only full backup, so the differential base and log chain of a scheduled backup plan are left untouched. The returned file holds the whole .bak in memory.

Restore

Restore(file) connects through master and creates the target database from the backup:

• An existing target database throws, unless Overwrite = true: then it is taken offline, rolling back its open sessions, and dropped. That happens only after SQL Server has read the backup's file list, so a file it cannot open never costs you the existing database. Offline, no application can reconnect before the drop; SQL Server keeps an offline database's files, and the restore overwrites them where they sit at the paths below — a file elsewhere is named in a logged warning.
• The data and log files go to the server's default data and log directories, named after the target database (shop_staging.mdf, shop_staging_log.ldf), so a backup restores under a new name beside its source.
• A planned file that belongs to another database — one renamed, or taken offline — fails the restore before anything is dropped. A target that did not exist is restored without REPLACE, so a stray file at a planned path fails the restore rather than being overwritten.

Exists checks for a database on an open connection:

bool exists = await restoreService.Exists(connection, "shop_staging");

Neither service joins an ambient TransactionScope: SQL Server refuses to back up or restore inside a transaction. Backup needs db_backupoperator (or db_owner) on the database; restore needs dbcreator.

Backup/Restore contracts

Both services implement the shared contracts from Common:

public interface IDbBackupService  { Task<IMemoryFile> Backup(); }
public interface IDbRestoreService { Task Restore(IMemoryFile file); }

Overview

1. Index — Settings, the backup directory, backup and restore
2. Examples — Copy a database under a new name, archive a backup and restore it later

License

Apache License 2.0 — this package contains no license validation and no runtime limits. See LICENSE. A few companion packages are commercially licensed with a free tier; see the licensing overview.