Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Sourav Mukherjee

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Query to check whether my Full Database Backup is running fine.

The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.  Read more...
By Sourav Mukherjee 2012/09/13 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,084 reads

Backup Database Size calculation Report - Monthwise

The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.  Read more...
By Sourav Mukherjee 2012/09/24 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 1,094 reads

Killing User Connection(session) connected to the Database.

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...
By Sourav Mukherjee 2011/04/08 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,366 reads

Script: Map Orphan Login and Users

Map the Orphan Login and Users.  Read more...
By Sourav Mukherjee 2011/01/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,595 reads
   Items 1 to 4 of 4