Log in | Register

Backup, Restore and Recovery Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Backup, Restore and Recovery Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Backup, Restore and Recovery

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server 2016 – Temporal Tables Part 1

Hello Friends,

Several new features announced by Microsoft in SQL Server 2016. We have seen a few of them in my previous blog posts. In the same row, we will bring a look today on next interesting feature i.e. SQL Server 2016 – Temporal Tables. Actually, temporal feature was  introduced in ANSI SQL 2011. Microsoft […]

Maintenance Plans – A Tale of Seven Wonders – Wonder 1

Hello geeks,

Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Awww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]

Backup and Restore Sequence in SQL Server

Hello Geeks,

The time is flying by as I rejoice in the aftermath of the SQLServerGeeks Annual Summit 2015. It has been a wonderful event and once in a life time opportunity to be part of the Asia’s first SQL conference. More eventful was my personal life with the arrival of my princess Mahira on […]

Why Backups are important?

Hi Friends,

I am going to start a series on SQL Server Backups from past to present. So in my first blog of this series, I want to put some light on the introduction and Importance of backups.

During our study or even in most blogs, we generally read a statement “Data is one of the […]

sql server trace flag 3004

Hi Friends,

This is my 12th blog on SQL Server Trace Flag 3004 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

In our day to day work, many times we perform restore operations. Whenever we perform restore operation SQL Server logged some type […]

sql server trace flag 3226

Hi Friends,

This is my 11th blog on SQL Server Trace Flag 3226 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

In my working experience I have seen many servers where we have more than 20 databases on a single SQL instance. For […]

sql server trace flag 3023

Hi Friends,

This is my 10th blog on SQL Server Trace Flag 3023 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

Backup database is a very important operation for a DBA. There are so many options available while you are taking backup like […]

sql server trace flag 3014

Hi Friends,

This is my 9th blog on SQL Server Trace Flag 3014 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

Taking a database backup is most important activity for a DBA. Whenever we have taken backup in SSMS through TSQL then it […]

SQL Server Backup Encryption, SQL 2014 CTP2

Dear Friends,

SQL Server 2014 CTP2 introduced SQL Server backup encryption using which you can encrypt database backups. A certificate or asymmetric key is used with encryption algorithm to achieve this.  Previously you would have used any third party tools to encrypt your native backup files but this feature is now part of SQL Server […]

SQL Server Full Recovery Model – Impact of checkpoints

Hi Friends,

We all knew that, SQL Server Full Recovery Model log truncation occurs due to transaction log backup while under Simple recovery model log truncation occurs due to checkpoints. But here I want to show you the impact of checkpoint on your database while database is in SQL Server Full recovery model. Actually the concept […]

Newsletter_Footer