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

Content with tags Maintenance, report Rss

   Items 1 to 2 of 2   
 

Powershell script to report old backup files

Get a report of backups older than 60 days.  Read more...
By Rolando Hernandez 2014/05/30 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 786 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,320 reads
   Items 1 to 2 of 2   
 
Tags
administration (1)    
aggregates (1)    
automated dba (1)    
backups (1)    
growth trend (1)    
html (1)    
maintenance and management (1)    
old files (1)    
powershell (1)    
running aggregate (1)    
running totals (1)    
space usage (1)    
sql server 2005 (1)    
storage (1)    
t-sql (1)    
utility (1)