Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2008-07-08 : 16:55:41
|
| HiWhere can I check the path of my log and mdf files. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 18:15:38
|
| In Database properties. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-09 : 06:06:26
|
| use windows search with .*mdf or *.ldfArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2008-07-09 : 06:10:11
|
| sp_helpdb 'database name'*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-09 : 22:08:04
|
quote:
Originally posted by sunsanvin
use windows search with .*mdf or *.ldfArnavEven you learn 1%, Learn it with 100% confidence.
This is not efficient from your machine. What if you have 100 databases. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 00:41:47
|
| Still faster than look at properties of 100 dbs. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-12 : 05:12:06
|
quote:
Originally posted by rmiao
Still faster than look at properties of 100 dbs.
Querying on sysfiles would be fasterRefer the link that MVJ postedAlso I would say this must be faster though it is undocumentedexec sp_msforeachdb 'Select * from ?..sysfiles'MadhivananFailing to plan is Planning to fail |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-07-18 : 06:13:18
|
| How about a all time sp_helpfile***************************Life is for having Fun, and then a little SQL Server on the side |
|
|
|
|
|
|
We to find de mdf path on SQL Server 2005