sql-server-2005 Archives

Copy-Only backups

December 29, 2021March 25, 2014 by Omelchenko Alexander

You might have heard of this term, but you don’t know what it actually presumes.

Read this next article to understand what a copy-only backup is and how it fits in the big picture of SQL Server.

How to set expiration date on a backup

December 24, 2021March 24, 2014 by Omelchenko Alexander

The way you set the expiration date on a backup for SQL Server databases is quite easy.

You have two options for doing this. In order to find out, read the following article where we will show you both options.

Backup a table in SQL Server – How to

December 22, 2021November 3, 2013 by Omelchenko Alexander

Unfortunately, there is no standard or specific feature to backup a table in SQL Server, but there are workarounds.

This can be a very common request from clients, as they might want to backup specific tables from their databases, and as there is no feature in SQL Server that offers this functionality out of the box, then we need to create our own way.