Category: SQL Server
-
Database Transaction Log Full or Unable to write or Recovery Units belonging to database failed to generate a checkpoint
Some time working as a DBA or support engineer you might have faced this issue that DB log file full or recovery unit failed to generate checkpoint. We might get error in SQL error log like below… Error: 9002, Severity: 17, State: 2. The transaction log for database ‘DB_Name’ is full due to ‘LOG_BACKUP’. Could…
//
-
Database restore on destination and fix orphan user
In the article, we are going to demo a backup and restore process from source DB server to destination DB Server. In the demo we are performing below high-level tasks… 1. Create a login and grant access to a DB on our source server. 2. Take a DB backup on the source server. 3. Restore…
//
-
Read a big file using PowerShell
Get-Content C:\MySQL_Dump_8April2022\agii-tdsqlpw01_08April_11PM.sql | Select-Object -skip 0 -first 100
//
-
Step by Step implementing Log Shipping
Log Shipping enables you to automatically send transaction log backups 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 individually. ADVANTAGES OF LOG SHIPPING- DISADVANTAGES OF LOG SHIPPING- TYPES OF LOG SHIPPING –…
//
-
STEP BY STEP SQL Server Installation
Hey guys, in this blog I am going to explain you about “Step by step New SQL server stand-alone installation” Minimum requirement for SQL server 2019 installation Hardware requirements: Hard disk – It requires a Minimum 6GB of available hard-disk space. Monitor – Super-VGA (800×600) or higher resolution monitor. Memory – Minimum: …
//
-
Methods to change windows authentication to mixed mode (windows and SQL server authentication)
Hey guys, In this blog I am going to explain you about different methods to Enable Mixed Mode authentication Ø Enable Mixed mode authentication using Management studio Ø Enable Mixed mode authentication using Registry editor 1. Enable Mixed mode Authentication using MANAGEMENT STUDIO- STEP-1: Open a server in Management studio. Go to server -> right click -> instance ->properties…
//
-
Stored Procedure in a SQL Server-
Hey guys, In this blog, I am going to explain you about stored procedure and how to implement stored procedure in a SQL Server. Stored procedure – Stored procedure in SQL is a group of SQL statements that are stored together in a database. Based on the statements in the procedure and the parameters you pass,…
//
-
Trigger in SQL Server
Hello guys, In this blog, I am going to explain you about a Trigger and how to perform a trigger inside the database. Trigger- A SQL trigger is a database object which fires when an event occurs in a database. We can execute a SQL query that will “do something” in a database when a…
//
-
Step by step implementation of SQL Server Always on group
Hey guys, In this blog I am going to explain you Step by Step implementation on SQL Server Always on Availability Group Always on Availability group – The Always On availability groups feature is a high availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012 (11.x), Always on availability groups maximizes…
//
-
Step by Step Configure Windows failover cluster on windows 2019
Step by Step Configure Windows failover cluster on windows 2019- Step 1- First you need to login at the server and go to manage->add roles and features-> add failover clustering and install the features on the server and restart the server. Fig.1 Fig.2 Fig.3 Step-2 Go to failover cluster manager-> create cluster->enter server name -> run…
//
-
Point-in-time recovery in SQL Server
Hey guys, In this blog we will discussed about point-in-time recovery in SQL Server and how to perform it and also we discussed on full, differential and transaction log backup. 1. Full backup – A Full backup is a complete backup of a database. The full backup contains all the data in a database and…
//
-
View in SQL Server
Hello guys, In this blog, I am going to explain you about a view and how to create a view inside the database. View– A VIEW in SQL Server is like a virtual table that contains data from one or multiple tables. It does not hold any data and does not exist physically in the…
//