SQL Server Log shipping

What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of transaction log files from the primary server database to second server database to get both database in continuous…

Read Full
491 views 18:44 0 Comments

SQL Server Upgradation

What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version to sql server 2012. Before upgradation we need to run upgrade advisor tool. Microsoft sql server 2012 upgrade…

Read Full
448 views 18:39 0 Comments

SQL Server Migration

Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1: As a part of launch, deployment in the production server…

Read Full
584 views 18:37 0 Comments

SQL Server Automation

Automation refers to scheduling the regular maintenance tasks. Whenever schedule time comes automatically that task will be executed. DBA regular activities can be automated we can get the status f…

Read Full
504 views 18:32 0 Comments

SQL Server Security

Security is the most important tasks for a DBA. we need control the access to sql server as well as provide security to the datal. Levels of SQL Server Security…

Read Full
459 views 18:27 0 Comments

SQL Server Restoration Tutorial

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 Unplanned (or) Accidental restoration…

Read Full
473 views 18:24 2 Comments

SQL Server Backups

Backup means, saving the exact copy of the current version of database in some other location. Situations where backup can use Hardware (or) software failure Natural disasters Internal misuse Hardware…

Read Full
553 views 18:20 0 Comments

SQL Server Databases

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…

Read Full
442 views 18:18 0 Comments

SQL Server installation

Installation Whenever we want to start the installation of the SQL server we need to gather details of installation. SQL Server Versions Version (Name)RTMSP1SP2SP3SP4Sql server 2014 (Heteko)Trail version releasedSql server…

Read Full
527 views 04:06 0 Comments

SQL Server Transaction Log Architecture

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.…

Read Full
590 views 11:00 0 Comments