MSSQL Database Administrator
SQL Installation 2019 Step by Step: Download: SQL 2019 -installation step-by-step SOP word Document 1. Run the setup with administrator 2. Wizard will open and select the Planning tab on left side 3. Enter the product key (if no, select Free edition) and click on Next 4. Accept the licence terms and click on […]
Continue ReadingSystem databases: When we install Microsoft SQL Server, five system databases are automatically created for each SQL Server instance. These system databases allow the database engine and administrative applications to properly manage the system. master model msdb tempdb Resource (SQL Server 2005 and higher only) 1. Master The master database manages the SQL Server instance. […]
Continue ReadingStates of SQL Server Database: Online: When a database is in an online state, the database is available for access. OFFLINE: When a database is in OFFLINE state, then the database is not accessible for user connections. One can set the database to this state if you don’t want users to connect to the database. […]
Continue ReadingSQL Security: Login: Those who are want to privileges for login into SQL server called login. Windows Authentication mode: It allows only active directory users or windows users to connect and work with SQL Server with mapping logins. It provides high security. SQL login: It allows non active directory users to connect and work with […]
Continue ReadingMigration and Upgrade Migration: Migration is a manual process in which the DBA installs a new instance of SQL Server and copies the metadata and data from an old instance to the new instance. Migration provides access to two instances of the system, letting you verify and compare the two systems. During migration, both the […]
Continue ReadingA high-availability solution covers the impacts of a hardware or software failure and preserves application availability, reducing perceived downtime for customers.SQL Server high-availability solutions increase server or database availability. RTO: Recovery Time Objective (RTO) is the amount of time it is intended for data or hardware to be restored following data corruption or hardware failure. […]
Continue ReadingThe Server Log Shipping feature automates the backup of transaction log files from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases separately. A third server instance, known as the monitor server, optionally […]
Continue Reading1) SQL server clustering is a high-availability solution that assists businesses in meeting their availability and uptime targets 2) This availability assures that mission-critical services, applications, and data are always accessible in the event of a failure or disaster. 3) As an automatic technique, it enables one physical server to take over the functions and […]
Continue Reading