In
this article, we explain the concept of tail-log backups and check out the
scenarios where they may be needed while using MS SQL Server
Tail-Log Backups are used for capturing the log records for data, for which the user hasn’t created any back-ups to prevent the data from getting lost or deleted from the system and also to ensure that the log chain stays intact. It is recommended that the user backs-up his/her transaction log in its tail before starting a recovering program in his/her...
Read more »
In
this article, we look at stretch enabled tables that one should be aware of
including key constraints
Stretch Database is a SQL Server feature which allows users to migrate cold data securely and transparently to Azure cloud. Users can even pause these migrations during connection errors, which help in easier transfer of data.
Stretch Database
directly targets transactional databases containing a large amount of cold
data, which is usually stored in multiple tables in a database....
Read more »
In this article, we explain the relevance of Stretch
database and discuss 4 questions that a DBA must ask himself before considering
a stretch database.
Stretch Database is used for migrating cold data securely and transparently to Microsoft Azure cloud. It basically targets transactional databases by storing large amount of cold data in a bunch of tables. Here are a few questions that you should ask before using a stretch Database.
Do you want to access
Availability of...
Read more »