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 |
|
divyagr
Starting Member
29 Posts |
 Posted - 2009-01-21 : 00:50:34
|
| hi all, i like to know the concept of where the db is actually getting saved when it created ..i just know that its not RAM resident ....with regards,Divya |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-21 : 01:23:25
|
In SSMS right click on Database. Choose Properties and then files. You can see where data and logs are saved in filesystem.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ra.shinde
Posting Yak Master
103 Posts |
Posted - 2009-01-21 : 01:24:47
|
| In .MDF and .LDF file located at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataRahul Shinde |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-21 : 07:19:31
|
| Usually There C:\Program Files\Microsoft SQL Server\MSSQL$LOCAL\DataBut u see the database file locations by seeing the properties of that database.Location of .mdf and .ldf files r given there? |
|
|
|
|
|
|
where DB get saved???