SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Azad Sale / RESOLVING SPACE ISSUE / Latest Posts

RE: RESOLVING SPACE ISSUE

manu0417 — Mon, 13 Aug 2012 20:35:53 GMT

Good script Azad. I would also suggest to make it more flixible by adding default values like 1. looping all drives if drive not specified.2. Providing all files if not filtered by size or extension.3. If this can be run remotely that would be even beneficial.And keep posting. All the best.Regards,Manu

RE: RESOLVING SPACE ISSUE

azad maratha — Tue, 14 Dec 2010 21:15:12 GMT

its a good script and i should format it better so that everyone can understand.will do it shortly.

RE: RESOLVING SPACE ISSUE

azad maratha — Tue, 14 Dec 2010 21:07:39 GMT

Hi,How old the file is in days......you should put a number...if its week old...then put 7.Thanks & RegardsAzad R Sale

RE: RESOLVING SPACE ISSUE

Phil Streiff — Tue, 14 Dec 2010 14:41:16 GMT

I ran the script in a SQL 2005 instance and got the following error:Msg 245, Level 16, State 1, Line 19Conversion failed when converting the varchar value 'how old the file is in days' to data type int.Thanks,Phil

RE: RESOLVING SPACE ISSUE

azad maratha — Fri, 05 Nov 2010 02:45:04 GMT

thanks for your feedback steve.this script is a modified version of another script which i wrote.that script was embedded in vbscript and it was supposed to be run on all servers.but by doing this we dont have enough control on it.and my TL suggested to replace cursor.i was thinking of set-based solution.but as it is DIWALI festival i will complete it after its over.and as for xp_cmdshell and ole i assumed that everyone knows about it.and stored procedure is useful if its permanent and then we can just pass values but as this is a one time script which doesnt create any permanent objects i never thought of creating a procedure for that.last but not leastthanks for appreciating my work and taking efforts to see it works and needs improvements andit can be useful to DBA's.

RE: RESOLVING SPACE ISSUE

S. Kusen — Thu, 04 Nov 2010 17:39:46 GMT

This is a good script script. I think it would be useful for checking for old backups as you suggest. Typically, we try to place backups we retain for multiple days in a specified folder we put on each system and then check the age there. Naturally, we may take backups and place them on drives and never go back to them, so this would be good for a one-off look for those "forgotten" backups that are no longer needed.Some recommendations:1. Change it to a stored procedure with the configurable values as input. When I first went to run it, I hadn't realized the configurable values section and had to look at the data types first to get it working.2. A minor recommendation, but have the default output changed to say "size_mb" instead of just size, output the number of days the file has been there (get the datediff comparing the file date versus today's date)3. Modify it to loop through all drives (maybe by combining its' use with xp_fixeddrives). This would be useful as an overall review of the system to check all drives to proactively look at the largest files of a certain type.Some people may also point out that xp_cmdshell and Ole Automation Procedures need to be enabled in order for the script to run, and there are some associated security risks with enabling those options.A generalized comment:With monitoring/cleanup scripts, I always try to take the mindset of "How can I run this on all of my SQL Servers/databases/disks/etc from a centralized location?" to help make my job easier. Hope that feedback helps you out for future submissions.Steve

RE: RESOLVING SPACE ISSUE

azad maratha — Wed, 27 Oct 2010 21:56:52 GMT

Hi guys.any comments would be appreciated.

RE: RESOLVING SPACE ISSUE

azad maratha — Sun, 24 Oct 2010 20:10:09 GMT

There are actually four parameters that you can change.The fourth one is filesize.This parameter value is in MB.First you have to set the filesize { set @filesize=100} then the search result will show results having files whose minimum size is 100 MB.

RESOLVING SPACE ISSUE

azad maratha — Sat, 23 Oct 2010 13:03:36 GMT

Comments posted to this topic are about the item [B]RESOLVING SPACE ISSUE[/B]