Write-Host "Backup in Progress" $QueryStatement = "SELECT * FROM settings where setting_name='backup_path'" $Query = ...

For the past several weeks I’ve been doing nothing but complaining about vendors so I thought I’d take a break and write something about SQL Server for a change. So to that end today I’m gonna talk ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups with ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know. At the PASS Community ...

ExaGrid, the industry’s only Tiered Backup Storage solution with Retention Time-Lock that includes a non-network-facing tier (creating a tiered air gap), delayed deletes, and immutability for ...