As per MSDN “PARTIAL Backups are designed for use under SIMPLE recovery model; thereby to improve flexibility to backup very large database which contain one or more read-only Filegroups. They are useful whenever...
Chetna BhallaSQL Server FULL Recovery Model Step by Step Tutorial with Examples
In Full Recovery Model Point in Time recovery of the database is possible as long as you have all the valid database backups along with the transaction log tail backup file. In Full Recovery model all the transactions...
SQL Server: How to Find which user deleted the database in SQL Server
Introduction In this article we will take a look at the steps which you can follow to quickly identify the user who deleted the user database in SQL Server. There are two different methods by which one can easily find...
How to Configuring Database Instant File Initialization Feature of SQL Server
SQL Server Database Administrators can leverage Database Instance File Initialization Feature which is available in Microsoft Windows XP Professional, Windows Server 2003 or later versions to reduce the time taken to...
Ashish MehtaDownload SQL Server 2016 Developer Edition for Free
Introduction Microsoft announced the release of the Release to Manufacturing (RTM) version of SQL Server 2016 on June 1, 2016. The good news is that you can download SQL Server 2016 Developer Edition for Free. Different...
How to Recycle SQL Server Error Log file without restarting SQL Server Service
SQL Server Error Log is the best place for a Database Administrators to look for informational messages, warnings, critical events, database recover information, auditing information, user generated messages etc. SQL...
ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server...
How to Identify the Location of Resource Database in SQL Server
In this article we will take a look at how to identify the location of Resource database in SQL Server using a TSQL script. Importance of Resource Database in SQL Server Microsoft initially introduced Resource database...
TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
It is a well known fact that TRUNCATE TABLE is faster than DELETE statement. TRUNCATE TABLE uses lesser system resources and transaction log file when compared to a DELETE statement. This is Part 2 of 10 Part T-SQL...
How to Restore Analysis Services Database in SQL Server Using SQL Server Management Studio
In this article we will take a look at the steps which a database administrator needs to follow to restore an analysis services database. The steps mentioned below are applicable on SQL Server 2005 and higher versions...
SQL Server: How to Start SQL Server with Minimal Configuration
Introduction There can be certain scenarios when SQL Server is not starting because of configuration problems. During such scenarios one need to start an instance of SQL Server by using minimal configuration...
SQL Server WHERE Clause T-SQL Tutorial with Examples
The WHERE Clause is used to fetch records from a table which meets the condition mentioned in the WHERE Clause. This is Part 5 of 40 Part SQL Server T-SQL Tutorial. Click here to read it from the beginning…. WHERE...
TAIL-LOG Backup in SQL Server Step by Step Tutorial with Examples
A tail-log backup captures any log records which has not yet been backed up i.e., the tail of the transaction log to prevent any work loss and to keep the transaction log chain intact. Before you can recover a SQL...
Identify Deadlocks in SQL Server Using Trace Flag 1222 and 1204
Introduction This article outlines the steps which one can follow to enable Trace Flag 1222 on SQL Server to capture deadlock information. You can also use Trace Flag 1204 in conjunction with Trace Flag 1222. Difference...
SQL Server SELECT TOP Clause T-SQL Tutorial with Examples
The SELECT TOP Clause is used to specify the percentage of rows or to specify the number of rows which needs to be retrieved from a given table. This is Part 2 of 40 Part SQL Server T-SQL Tutorial. Click here to read it...
FILE Backup in SQL Server Step by Step Tutorial with Examples
Using FILE backup one can backup SQL Server Data File individually. While backing up the database you can specify whole of FILEGROUP instead of specifying each database file individually within the FILEGROUP. In case if...
Database Backup Encryption in SQL Server 2014 a Step by Step Implementation Guide
Microsoft has introduced inbuilt Database Backup Encryption Feature in SQL Server 2014. Starting SQL Server 2014, SQL Server will have the ability to encrypt the data while the backup is in progress. One can encrypt the...
