2 min read
2
Database restore history in SQL Server
Introduction This script will help you to get the restore history for all the databases. If you need to know…
Category: MSSQL
4 min read
2
How to create database user on secondary node if DB is in readonly mode in SQL Server?
Scenario How to provide ‘db_dataread’ database role to a SQL login when the database is in AlwaysOn & secondary node…
3 min read
0
Exploring Database File Information with T-SQL
Introduction In the world of database management, having a clear understanding of the file information is crucial for optimizing performance…
3 min read
0
Find Physical file location for all the databases in SQL Server
Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database.…
2 min read
0
Set Auto growth for all the databases wit T-SQL
Introduction Managing the growth of database files is an essential aspect of maintaining a healthy SQL Server environment. As databases…
3 min read
2
Find database growth size and store in a table in SQL Server
Introduction Managing database sizes is a crucial task for database administrators. Monitoring database growth and tracking size changes over time…
4 min read
8
Find disk space using Stored procedure or TSQL
Introduction xp_fixeddrives only provide how much disk space is free on each drive but not the maximum space of the…
3 min read
0
Find text in Stored Procedures & then find JOB associate with Stored Procedure
Introduction Few days before I was asked to disable some ‘JOB’ in a production SQL Server. But the task was…
3 min read
0
Increase the number of ErrorLog in SQL
If something goes wrong on the SQL database server, the error log is the first place we look for information.…
2 min read
0
Move SQL Server database files to another location
Issue If any drive is full due to the large database data file (LDF or MDF) size! How to moving…