You can change the default point-in-time recovery (PITR) backup retention period by using the Azure portal, PowerShell, or the REST API. The following examples illustrate how to change the PITR ...
Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as ...
What are the most common SQL VSS writer issues users encounter when backing up SQL databases with VSS-based backup software? The VSS writer error that seems to cause ...
The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...
According to Microsoft, you can use the contained database model to make the database more portable. This prevents orphaned users after a restore by authenticating accounts directly at the database ...
This article provides an overview of the failover group feature with best practices and recommendations to use with Azure SQL Managed Instance. The failover groups feature allows you to manage the ...
SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...
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 ...
I've seen a few posts here and there with people talking about imaging their SQL Servers. I was wondering what you used to do that and the reasoning behind it. I assume the general idea is that if the ...