Clota Blog

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…