Great minds discuss ideas!
Step-by-Step Configuration Guide 1. Adding the Host 2. Installing the GCP Backup and DR Agent 3. Registering the Host in Backup and DR Console 4. Applying the Agent Secret 5. Creating a Backup Template (if needed) 6. Configuring SQL Server…
Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget simple scripts. Hence I thought to write this simple script and also we can use GUI to find the same. Both…
Introduction This script will help you to get the restore history for all the databases. If you need to know the restore history only for a single database then please use the WHERE CLAUSE. Script — ============================ — Owner: SOYELUDDIN…
Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database. Simply we can obtain the output by executing the below query. Run the script to get the SQL Server database…
Introduction Managing the growth of database files is an essential aspect of maintaining a healthy SQL Server environment. As databases grow over time, it becomes crucial to configure appropriate growth settings to ensure optimal performance and prevent storage-related issues. In…