When backing up your SQL Server database, you have the option of taking transaction log backups. These are quick, small backups containing a sequence of all your database’s changes. Transaction log backups are mightily useful for point-in-time recovery. Continue reading Why Transaction Log backups are important
As a DBA, you have almost certainly taken a backup from one server for the purposes of restoration on another server. It’s a somewhat tedious and manual process, but most of us are sort of resigned to it and accept it simply as a necessary evil of the DBA role. I mean, it’s not like you can automate the entire process, right? Well, hold that thought … Continue reading Automated Database Backup-and-Restore for SQL Server
If you’re looking for an easy way to quick restore a database backup then you have found the right place.
Take a look at the article below to find out how you can achieve this.
The point in time restore is a feature of SQL Server databases which allows you to recover an exact state of your database that is specific to an exact point in time.This option is available ever since the logging for this action has been activated (transaction log). This article is a continuation to a previous article where we demonstrated how to do such a restore using SSMS. Continue reading How to make a point in time restore – T-SQL