Troubleshooting | dbblogger 2/2

Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1

Jan 18, 20221 min read

Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1

When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er

172 views0 comments

Troubleshoot SQL Server Backup Error Msg 3132, Level 16

rajendra gupta

Jan 18, 20221 min read

Troubleshoot SQL Server Backup Error Msg 3132, Level 16

This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.

849 views0 comments

Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server

rajendra gupta

Jan 13, 20221 min read

Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server

442 views0 comments

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

rajendra gupta

Jan 13, 20221 min read

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

60 views0 comments

SQL Server Management Studio Query Commands completed successfully without any Results

rajendra gupta

Jan 7, 20221 min read

SQL Server Management Studio Query Commands completed successfully without any Results

I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?

128 views0 comments

SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’

rajendra gupta

Jan 7, 20221 min read

SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’

In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...

8,422 views0 comments

move SQL Server TempDB database files to a different directory using Dynamic SQL

rajendra gupta

Jan 5, 20223 min read

move SQL Server TempDB database files to a different directory using Dynamic SQL

This article will explain the steps to change the SQL Server Tempdb database data and log file physical location.

241 views0 comments

"Invalid Object Name" Error in SSMS for recently created objects

rajendra gupta

Jan 4, 20221 min read

"Invalid Object Name" Error in SSMS for recently created objects

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"

221 views0 comments

How to stop logging successful backup messages in SQL Server error logs

rajendra gupta

Jan 4, 20222 min read

How to stop logging successful backup messages in SQL Server error logs

This article guides you to stop logging successful backup messages in SQL Server Error Logs.

162 views0 comments

Who, When, and Why restarted my SQL Server?

rajendra gupta

Dec 31, 20211 min read

Who, When, and Why restarted my SQL Server?

509 views0 comments

When my SQL Server database was restored ?

rajendra gupta

Dec 10, 20211 min read

When my SQL Server database was restored ?

41 views0 comments

Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371

rajendra gupta

Dec 10, 20211 min read

Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371

This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...

2,359 views0 comments

SQL Script to fix Orphan users in SQL Server database

rajendra gupta

Dec 9, 20212 min read

SQL Script to fix Orphan users in SQL Server database

This blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...

2,631 views0 comments

Fix error "Agent XPs disabled" in SQL Server

rajendra gupta

Dec 6, 20211 min read

Fix error "Agent XPs disabled" in SQL Server

This article explains the steps to fix the SQL Server agent error "Agent XPs disabled" using T-SQL scripts. Error details You might see...

1,042 views0 comments