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

Scripts with tag Administration Rss

Search for any content tagged administration

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 171    Older >>
 

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/05/15 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 55 reads

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location  Read more...
By Vimal Lohani 2015/05/10 | Source: SQLServerCentral.com | Category: detach database
Rating: |  Discuss |   Briefcase | 46 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 55 reads

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
Rating: |  Discuss |   Briefcase | 1,368 reads

Migrate existing DB Mail Exchange Configuration with New

Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.  Read more...
By Nitin Gupta 2015/01/13 | Source: SQLServerCentral.com | Category: dbmail
Rating: (not yet rated) |  Discuss |   Briefcase | 556 reads

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command   Read more...
By David Zhou 2015/01/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,627 reads

Copy Latest Backups from Backup Path

This script is useful to copying latest backup files from job Backup path during Instance/Database Migration  Read more...
By Ajay Dwivedi 2015/01/21 | Source: SQLServerCentral.com | Category: latest backup
Rating: (not yet rated) |  Discuss |   Briefcase | 684 reads

Script to remove Backup Files except Recent One for Same Day

This script is useful to remove SQL backup files except latest one for same day from Backup Path.  Read more...
By Ajay Dwivedi 2015/01/26 | Source: SQLServerCentral.com | Category: filter backup
Rating: (not yet rated) |  Discuss |   Briefcase | 921 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 571 reads

Track database growth 2012/2014

Enhancement to Track database growth By Irwan Tjanterik, 2014/09/23  Read more...
By Paulo Nascimento 2014/10/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,764 reads

Physical Server or a Virtual Machine?

Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM. Note: This Script works only on 2008R2 SP1 and above.   Read more...
By SreeSql 2014/07/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,185 reads

Generated script to update statistics

Generated script to update statistics  Read more...
By Andrés Michaca 2014/05/02 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,556 reads

Reorganize indexes

Generate script to reorganize indexes in a database  Read more...
By Andrés Michaca 2014/05/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,305 reads

TEMPDB Configuration per vCPU

A simple script for automation of additional secondary data files of tempdb.  Read more...
By Paulo Nascimento 2014/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,056 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2015/02/24 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,402 reads

Long Running Jobs Monitor

Script to be executed every 60 minutes as a job to determine long running jobs.  Read more...
By Gregory Ferdinandsen 2015/04/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,429 reads

Show Database and Log sizes, free space and location

This script helps to identify which database/log takes most of the disk space and how much is free.  Read more...
By Leonid Sheinkman 2015/04/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,708 reads

Script to change auto growth settings for all databases in SQL Server

Script to change auto growth settings for all databases in SQL Server.  Read more...
By Shashank Srivastava 2015/05/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,357 reads

List of Stored Procedures modified in past 7 days

Provide list of Stored Procedures that have been changed in past 7 days.  Read more...
By Nitesh R Dedhia 2013/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,145 reads

Script to find the total used size of all database inside SQL Server

Script to find the total used size of all database inside SQL Server  Read more...
By Shashank Srivastava 2013/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,678 reads
   Items 1 to 20 of 171    Older >>