header photo




There are currently no blog comments.

SQL Server Checkpoints


  • Checkpoint is SQL Server background process to write all dirty pages to disk.
  • It takes modification details from transaction log file and writes respective pages from buffer to data file.
  • The dirty page may consist of committed or uncommitted or both transactions.
  • SQL Se…

Read more

What may be the possible scenarios of backup failures in SQL Server?

Possible Backup failure scenarios

  • Disk was full
  • Server was busy.
  • Problem with the n/w
  • Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\node-1\Backups\master.bak'. Operating system error 1326(The user name or password is incorrect.).Msg 3013, Level 16, State 1, Line…

Read more

Transferring Logins between SQL Server Instances

First 2 steps should be executed in primary server and copy 2nd step output and run in standby or second server

USE master
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL

  DROP PROCEDURE sp_hexadecimal
CREATE PROCEDURE sp_hexadecimal
    @binvalue varbinary(256),

Read more

SQL Server ErrorLogs

* Error Logs maintains events raised by SQL Server database engine or Agent. * Error Logs are main source for troubleshooting SQL Server problems. * SQL Server supports 2 types of error logs               &nb…

Read more