Ideal for anyone looking to implement log shipping or needing a reliable process for database recovery from backups. Especially beneficial for environments with a large number of databases or ...

[!INCLUDE ssEnterpriseEd10] and later versions support backup compression. When creating a log shipping configuration, you can control the backup compression behavior of log backups. For more ...

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale. One of the most exciting new ...

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 ...

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...

Abstract: Database forensics is becoming more important for investigators with the increased use of the information system. Although various database forensic methods such as log analysis and ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

Microsoft broke new ground in scalability when it launched Azure SQL Database Hyperscale. Here's what it took to make Microsoft's hyperscale vision work with the existing Azure infrastructure. When ...