Menu
header photo

SQL-Talk

Talks all about SQL Server and Azure

Search

Archive

Comments

There are currently no blog comments.

SQL Server Installation Step by Step

October 4, 2017
  • Open DVD or dump --> double click on Setup.exe
  • In "Installation Center" Click on Installation option as follows
  • Click on "New SQL Server standalone installation ......................
  • Under "Setup Support Rules" click OK
  • Click Next
  • Click Next in the following step
  • The following step w…

Read more

SQL Server Checkpoints

October 2, 2017

Checkpoint

  • 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?

October 2, 2017

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

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

--step1
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL


  DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
    @binvalue varbinary(256),
    @h…

Read more

SQL Server ErrorLogs

October 2, 2017
* 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