Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

SQL Server 2008 provides a feature, which, in my opinion, has been far overdue: backup compression. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool ...

ログインして、InfoQのすべての体験をアンロックしましょう！お気に入りの著者やトピックの最新情報を入手し、コンテンツと交流し、限定リソースをダウンロードできます。 “AI活用”をキーワードに「AIを使い倒し／使いこなす」企業の最前線をお届けし ...

DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date) AS duration_seconds, CAST(bs.backup_size / 1048576.0 AS DECIMAL(18,2)) AS backup_size_mb, CAST(bs.compressed_backup_size / 1048576.0 AS ...

A production-grade CLI tool written in C++17 that reads SQL Server full backup (.bak) files and extracts data from a specified table into CSV, Parquet, or JSON Lines format. Limitations: Does not ...