Restoration is a process of using backups to recover the exist database (or) to create a new database in another server. Situations for Restoration Planned restoration, when we have planned…

Backup means, saving the exact copy of the current version of database in some other location. Situations where backup can use Hardware failure includes operating systems CPU memory, network card…

Database:  Database is a container which stores data and data objects. It manages data and allows fast storage and retrieval of that data. Types of Databases in SQL Server: There…

Installation Whenever we want to start the installation of the SQL server we need to gather details of installation. SQL Server Versions Version (Name) RTM SP1 SP2 SP3 SP4 Sql…

Transaction Log Architecture SQL Server uses LSN (Log Sequential Number) in identifying the transaction. Each and every transaction that comes to the log file will associate with an LSN number….

SQL Server data mainly in 2 types of files, Data file stores actual data with .mdf extension. It stores permanent data. Log files stores modified recorded information with .ldf extension….

In an SQL server all the data will be stored in the form of records, these records also called row data. All these records further grouped into a page. The…

Introduction If you’re curious about how SQL Server works behind the scenes or you’re new to the world of databases, you’ve come to the right place. In this article, we’ll…

1. Database Administration A database administrator is a person responsible for the database design, implementation, maintenance, and repair of the database. The main goal of DBA is to keep the…

MS SQL Server DBA Training Welcome to Complete SQL Server DBA Tutorials ! This course is designed to help beginners and professionals learn the fundamentals of SQL Server DBA (Database…