Rajanand's Blog

Series

Database Administration

Articles in this series

How to fix SQL Server SQL authentication login issue when the user name and password is correct?

Oct 10, 20221 min read489 views

Problem: I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...

How to fix SQL Server Integration Services could not be started issue?

Oct 1, 20221 min read794 views

Error: The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...

How to get the TCP / IP Settings of a SQL Server?

Sep 16, 20221 min read115 views

This query gets tcp/ip settings of the SQL Server from registry. SELECT registry_key, value_name, value_data FROM sys.dm_server_registry WHERE...

How to rename a database without an error in SQL Server?

Sep 5, 20221 min read3.3K views

Problem Unable to rename the database in SQL Server. Msg 5030, Level 16, State 2, Line 17 The database could not be exclusively locked to perform...

How to check database restore history and backup file used for restore in SQL Server?

Aug 26, 20221 min read1.3K views

SELECT rs.destination_database_name, rs.restore_date, bs.backup_start_date, bs.backup_finish_date, bs.database_name as...