How to remove old SQL Server backups

remove old sql server backupHow to remove old SQL Server backups – quick tutorial: 
Managing storage space occupied by your backups is a task that should not require a DBA’s time. 
With SqlBak you can easily remove old SQL Server backups, periodically. 
In this article we will show you how to do this, step by step, so you will never have to worry about old backup files filling up your storage space.

Read more

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.

Read more

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

backup to url
In this article, we will present you the main idea behind the 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.

Read more

Backup best practices – a shortcut

We already know that backups are important for securing your databases from data loss. 
We also have an article about best practices regarding backups, but the article is quite detailed and if you want to take a shortcut and take care of the essentials, then you’ve found it.

Read more

Backup best practices – a shortlist

backup best practices
If you’re here, then there’s a high chance you already know the importance of a good backup and what they mean to a serious business.
Taking care of database backups is an important and very sensitive job.
This is why we tried to make a shortlist of some backup best practices that you should be aware of when you’re either doing backups or you’re trying to restore them, in order to be covered for any of the common and slightly uncommon situations involving backups.

Read more

Restore SQL Server database remotely

Imagine how cool would it be: you are on vacation on a beach when you receive a panicked email from your client telling you he has lost all his data. You take your smartphone, log in to sqlbak.com, press “Restore” next to the last backup, and in a few minutes tell the client that his database was restored. This is as close to James Bond as a database administrator could ever get!

Read more