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 |
|
ramaiah
Starting Member
27 Posts |
 Posted - 2010-05-23 : 23:03:16
|
| using sysfiles and sp_helpdb.. i can able to see the phsycial path of the .mdf file but when i have seen that location, the file is not there in that location. how we can know the exact location of the file. the database is working file. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-23 : 23:08:02
|
did you check in your local drive or on the server ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2010-05-23 : 23:11:29
|
| Yes .. i have checked. |
|
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2010-05-23 : 23:15:49
|
| I have checked entire local disks with that file name but no luck. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-23 : 23:20:41
|
quote:
Originally posted by ramaiah
I have checked entire local disks with that file name but no luck.
you mean your local client PC ? The files should be located at the Server's hard disk
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2010-05-23 : 23:30:39
|
| i have checked in Servers' Hard disk only. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-24 : 09:53:05
|
quote:
Originally posted by ramaiah
i have checked in Servers' Hard disk only.
No. You were looking into some other systemCheck it agianMadhivananFailing to plan is Planning to fail |
|
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2010-05-24 : 13:26:08
|
| Check it in your system where the database is created ... |
|
|
|
|
|
|
Location of the .mdf file