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