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

Scripts by Gene Hunter

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,731 reads

Script to find Disk Space including Mount points

works two different ways using sql for 2000 and 2005 and powershell for 2008.   Read more...
By Gene Hunter 2012/05/23 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,790 reads

PowerShell SCript to export almost everything from a list of servers

Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up.  Read more...
By Gene Hunter 2012/02/17 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,516 reads

Stored procedure to find and replace text in a text file

find and replace text in a text file using tsql   Read more...
By Gene Hunter 2012/01/23 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,813 reads

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.  Read more...
By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,914 reads

Save all DTS packages

short script but another way  Read more...
By Gene Hunter 2012/01/25 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 1,144 reads

Find storage including mount points Sql and windows utility

Find drive, freespace, usedspace and percent free for all drives and mounted volumes.  Read more...
By Gene Hunter 2012/02/16 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 749 reads

Find storage including mount points sql/powershell

Find all storage including mount points and show' free and used available. Needs powershell.  Read more...
By Gene Hunter 2014/08/25 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,174 reads

Move DTS packages to another server

easy way to migrate DTS packages to another server  Read more...
By Gene Hunter 2012/02/07 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 967 reads

poor mans archival of backup files and tran logs to alternate location

This script will backup your files that have changed only. old files will not be copied just newer ones.   Read more...
By Gene Hunter 2012/01/17 | Source: SQLServerCentral.com | Category: backup archival
Rating: |  Discuss |   Briefcase | 679 reads
   Items 1 to 10 of 10