Sql Database Files

#11

Check out junction.exe from sysinternals:

http://technet.microsoft.com/en-us/s.../bb896768.aspx

Linchi

"Scott" wrote:

Quote:

How can I check for these? I do not think this is the case because the
amount of space used on the drive doesn't add up if it were but I'd like to
check just to make sure.

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote in message
news:Xns9C651320BB39Yazorman (AT) 127 (DOT) 0.0.1...
Scott (Scott (AT) Verifpoint (DOT) com) writes:
I thought that might be the case aswell but I do not see any mountpoints
in the system. There is just one hard disk with two partitions, C and
D.

I think Andy used the incorrect teminology. They are not mountpoints, they
are just muliple links to the same directory. And as Andy says, save the
extra node for the link, there is no duplicate space wasted.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#12

Ah hah....there is a junction set up for this directory (see below).
-----------------------------------------------------------
Junction v1.04 - Windows junction creator and reparse point viewer
Copyright (C) 2000-2005 Mark Russinovich
Systems Internals - http://www.sysinternals.com

D:\\Databases: JUNCTION
Substitute Name: D:\Program Files\Microsoft SQL Server\MSSQL\Data
-----------------------------------------------------------

Thank you all for helping me figure this out and Linchi for the solution.

"Linchi Shea" <LinchiShea (AT) discussions (DOT) microsoft.com> wrote

Quote:

Check out junction.exe from sysinternals:

http://technet.microsoft.com/en-us/s.../bb896768.aspx

Linchi

"Scott" wrote:

How can I check for these? I do not think this is the case because the
amount of space used on the drive doesn't add up if it were but I'd like
to
check just to make sure.

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote in message
news:Xns9C651320BB39Yazorman (AT) 127 (DOT) 0.0.1...
Scott (Scott (AT) Verifpoint (DOT) com) writes:
I thought that might be the case aswell but I do not see any
mountpoints
in the system. There is just one hard disk with two partitions, C and
D.

I think Andy used the incorrect teminology. They are not mountpoints,
they
are just muliple links to the same directory. And as Andy says, save
the
extra node for the link, there is no duplicate space wasted.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sql Database Files

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: Sql Database Files - 08-12-2009 , 12:14 PM

Re: Sql Database Files - 08-12-2009 , 12:55 PM