Tag Archives: sql-server

How to verify SQL Server backup files after a backup

verify SQL Server backup
It’s important to verify SQL Server backup files after the backup process is complete.
Although the process can finish succesfully this does not guarantee that the integrity of the data in the backup file is valid.
This will definitely cause some annoyance when later trying to restore the backup file.
In order to avoid this unwanted scenario, you should use verification options …
Continue reading How to verify SQL Server backup files after a backup

Best place to backup your data?

best place to backup

There are multiple online solutions where you could store your SQL Server backups, but because there are so many you might not know which one to choose.
In this article we will try to go over some of the most popular solutions in order to help you decide what is the best place to backup and store your most important data.
Continue reading Best place to backup your data?

SQL Server backup to URL (Windows Azure) w/ T-SQL

backup to url
In this article we will present you the main idea behind SQL Server backup to URL feature which has been available since the 2012 SP1 CU2 version.
This backup operation can be performed either from Powershell, T-SQL or SMOs (SQL Server Management Objects), but in this article we will present you just the version with T-SQL.
Continue reading SQL Server backup to URL (Windows Azure) w/ T-SQL

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