sqlserver

Documentation

Index

• Constants
• Variables
• func GetDBRestoreLSN(db *sql.DB, databaseName string) (string, error)
• func GetDefaultDataLogDirs(db *sql.DB) (string, string, error)
• func HandleBackupExport(externalConfig string, exportPrefixes map[string]string)
• func HandleBackupImport(externalConfig string, importDatabases map[string]string)
• func HandleBackupPush(dbnames []string, updateLatest bool)
• func HandleBackupRestore(backupName string, dbnames []string, fromnames []string, noRecovery bool)
• func HandleDatabaseList(backupName string)
• func HandleLogPush(dbnames []string, norecovery bool)
• func HandleLogRestore(backupName string, untilTS string, dbnames []string, fromnames []string, ...)
• func IsLogAlreadyApplied(db *sql.DB, databaseName string, logBackupFileProperties *BackupProperties) (bool, error)
• func RunProxy(folder storage.Folder)
• type BackupProperties
  • func GetBackupProperties(db *sql.DB, folder storage.Folder, logBackup bool, backupName string, ...) ([]*BackupProperties, error)
• type DatabaseFile
• type LockWrapper
  • func RunOrReuseProxy(ctx context.Context, cancel context.CancelFunc, folder storage.Folder) (*LockWrapper, error)
  • func (lw LockWrapper) Close()
• type SentinelDto
  • func (s *SentinelDto) String() string

Constants

const AllDatabases = "ALL"

const BlobNamePrefix = "blob_"

const ExternalBackupFilenameSeparator = ","

const LogNamePrefix = "wal_"

const MaxBlobSize = MaxTransferSize * MaxBlocksPerBlob

const MaxBlocksPerBlob = 25000 // 50000 actually, but we need some safety margin

const MaxTransferSize = 4 * 1024 * 1024

const TimeSQLServerFormat = "Jan 02, 2006 03:04:05 PM"

Variables

var SystemDbnames = []string{
	"master",
	"msdb",
	"model",
}

Functions

func GetDBRestoreLSN

func GetDBRestoreLSN(db *sql.DB, databaseName string) (string, error)

func GetDefaultDataLogDirs

func GetDefaultDataLogDirs(db *sql.DB) (string, string, error)

func HandleBackupExport

func HandleBackupExport(externalConfig string, exportPrefixes map[string]string)

func HandleBackupImport

func HandleBackupImport(externalConfig string, importDatabases map[string]string)

func HandleBackupPush

func HandleBackupPush(dbnames []string, updateLatest bool)

func HandleBackupRestore

func HandleBackupRestore(backupName string, dbnames []string, fromnames []string, noRecovery bool)

func HandleDatabaseList

func HandleDatabaseList(backupName string)

func HandleLogPush

func HandleLogPush(dbnames []string, norecovery bool)

func HandleLogRestore

func HandleLogRestore(backupName string, untilTS string, dbnames []string, fromnames []string, noRecovery bool)

func IsLogAlreadyApplied

func IsLogAlreadyApplied(db *sql.DB, databaseName string, logBackupFileProperties *BackupProperties) (bool, error)

func RunProxy

func RunProxy(folder storage.Folder)

Types

type BackupProperties

type BackupProperties struct {
	BackupType        int
	DatabaseName      string
	FirstLSN          string
	LastLSN           string
	CheckpointLSN     string
	DatabaseBackupLSN string
	BackupStartDate   time.Time
	BackupFinishDate  time.Time
	HasBulkLoggedData bool
	IsSnapshot        bool
	IsReadOnly        bool
	IsSingleUser      bool
	BackupURL         string
	BackupFile        string
}

func GetBackupProperties

func GetBackupProperties(db *sql.DB,
	folder storage.Folder,
	logBackup bool,
	backupName string,
	databaseName string,
) ([]*BackupProperties, error)

type DatabaseFile

type DatabaseFile struct {
	LogicalName  string
	PhysicalName string
	Type         string
	FileID       int
}

type LockWrapper

type LockWrapper struct {
	// contains filtered or unexported fields
}

func RunOrReuseProxy

func RunOrReuseProxy(ctx context.Context, cancel context.CancelFunc, folder storage.Folder) (*LockWrapper, error)

func (LockWrapper) Close

func (lw LockWrapper) Close()

type SentinelDto

type SentinelDto struct {
	Server         string
	Databases      []string
	StartLocalTime time.Time `json:"StartLocalTime,omitempty"`
	StopLocalTime  time.Time `json:"StopLocalTime,omitempty"`
}

func (*SentinelDto) String

func (s *SentinelDto) String() string