Tag Archives: restore

Why Transaction Log backups are important

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

Automated Database Backup-and-Restore for SQL Server

As a DBA, you have almost certainly taken a backup from one computer/ server for the purposes of restoration on another computer. 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

SQL Server DB restore from Differential or Transaction log backup to another computer

Restore from Differential or transaction log backup
Restoring a SQL Server database from a Differential or Transaction log backup can’t be simpler when using SqlBak.
All that you have to do is press a few buttons and the restore operation will be complete. Read the article to find out how..
Continue reading SQL Server DB restore from Differential or Transaction log backup to another computer

How to make a point in time restore – T-SQL

point in time restore

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

Media errors during backup or restore

media errors during backup or restoreMedia errors during backup or restore operations are quite stressful, because usually these tasks should run smoothly.
But just in case you happen to have one such error, then it would be ready if you would be prepared or have a bit of knowledge about these errors before you see them.
Continue reading Media errors during backup or restore