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 Sever 2017 – Smart Transaction Log Backup

Hello Friends,

SQL Server 2017 CTP 2.1 has been announced with some new features, one of them is Smart transaction log Backup i.e. exposing the log in mb since last log backup. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post […]

SQL Server 2017 – Smart Differential Backup

Hello Friends,

SQL Server 2017 CTP announced with lots of new features to help database professionals. One of that feature is Smart Differential Backup i.e. exposing the modified extent page counts. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post we […]

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 […]

By |May 9th, 2016|Categories: Auditing, Backup, Restore and Recovery, Database Engine|Tags: , |Comments Off on SQL Server 2016 – Temporal Tables Part 1

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 […]

By |December 2nd, 2015|Categories: Backup, Restore and Recovery, Database Administration, Database Maintenance, Indexes & Statistics|Tags: , , , |Comments Off on Maintenance Plans – A Tale of Seven Wonders – Wonder 1

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 […]

By |October 22nd, 2015|Categories: Backup, Restore and Recovery|Tags: , , , , |Comments Off on Backup and Restore Sequence in SQL Server

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 […]

By |December 2nd, 2014|Categories: Backup, Restore and Recovery|Tags: , |Comments Off on Why Backups are important?

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 […]

By |October 4th, 2014|Categories: Backup, Restore and Recovery, Database Administration, One Trace Flag a Day|Tags: , |Comments Off on sql server trace flag 3004

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 […]

By |October 3rd, 2014|Categories: Backup, Restore and Recovery, One Trace Flag a Day, Setup & Configuration|Tags: , , |Comments Off on sql server trace flag 3226

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 […]

By |October 2nd, 2014|Categories: Backup, Restore and Recovery, Corruption, One Trace Flag a Day|Tags: , |Comments Off on sql server trace flag 3023

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 […]

By |October 1st, 2014|Categories: Backup, Restore and Recovery, One Trace Flag a Day, Performance Tuning|Tags: , |Comments Off on sql server trace flag 3014
Newsletter_Footer