<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Monitoring NEtwork shares drive space using...
Monitoring NEtwork shares drive space using SQL
Rate Topic
Display Mode
Topic Options
Author
Message
Dean Jones-454305
Dean Jones-454305
Posted Tuesday, December 02, 2008 4:02 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, February 15, 2013 2:29 AM
Points: 282,
Visits: 1,047
Hi All,
I was wondering whether there is a script/way out there in which one can monitor disk space on a network shared drive, I know once can use xp_fixeddrives, but this is mainly for local drives on the actual server.
Does anyone have a solution for this problem, the network drive can be mapped onto the operating system.
Post #611936
Kishore.P
Kishore.P
Posted Tuesday, December 02, 2008 4:50 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, November 26, 2012 3:25 AM
Points: 1,389,
Visits: 596
Dean Jones (12/2/2008)
Hi All,
I was wondering whether there is a script/way out there in which one can monitor disk space on a network shared drive, I know once can use xp_fixeddrives, but this is mainly for local drives on the actual server.
Does anyone have a solution for this problem, the network drive can be mapped onto the operating system.
see the link:
http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx
http://www.databasejournal.com/features/mssql/article.php/3080501/Using-xpfixeddrives-to-Monitor-Free-Space.htm
Post #611959
Jerry Hung
Jerry Hung
Posted Tuesday, December 02, 2008 8:15 AM
Right there with Babe
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:16 AM
Points: 768,
Visits: 1,161
Kishore.P (12/2/2008)
Dean Jones (12/2/2008)
Hi All,
I was wondering whether there is a script/way out there in which one can monitor disk space on a network shared drive, I know once can use xp_fixeddrives, but this is mainly for local drives on the actual server.
Does anyone have a solution for this problem, the network drive can be mapped onto the operating system.
see the link:
http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx
http://www.databasejournal.com/features/mssql/article.php/3080501/Using-xpfixeddrives-to-Monitor-Free-Space.htm
These 2 links don't seem to support Network Drives space? as far as I can read...
OP did mention xp_fixeddrives as well, but that only works for local drives of the SQL server
OP is probably asking if we can check space on a UNC path, or a Network-mapped drive... which I am curious too as well
SQLServerNewbie
MCITP: Database Administrator SQL Server 2005
Post #612097
CrazyMan
CrazyMan
Posted Tuesday, December 02, 2008 9:10 AM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, September 18, 2012 3:00 PM
Points: 770,
Visits: 1,593
Conceal this extended SP into a SP, the call that SP from a linked server, this can be used with the machine where we have SQL installed :)
Post #612136
Dean Jones-454305
Dean Jones-454305
Posted Tuesday, December 02, 2008 9:44 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, February 15, 2013 2:29 AM
Points: 282,
Visits: 1,047
Hi Guys,
Yes, I mean a UNC path either directly or mapped onto a computer, not sure which one will be easier but just one way or the other really.
thanks.
Post #612172
philcart
philcart
Posted Wednesday, December 03, 2008 4:35 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, May 23, 2013 3:27 PM
Points: 2,692,
Visits: 1,075
You won't be able to directly monitor the free space of a share within SQL Server.
What you could do is create a Performance Counter Log to record the appropriate free space counter from the remote server. Then you can use Logman.exe to load that data into a SQL Server database. Once there you can track it and raise notifications about low space.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
Australian SQL Server User Groups
-
My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #612686
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
