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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-01-26 : 15:51:26
|
| I was reading about files and filegroups from BOL but couldn't understand few things-In SQL Server 2005, the locations of all the files in a database are recorded in the primary file of the database and in the master database. The Database Engine uses the file location information from the master database most of the time. Where exactly can I find the file locations in the master DB?Are the locations used only for recovery?Answers would be appreciated. |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-01-26 : 16:49:21
|
| In SQL Management studio you can right click any database an look at its properties to see where its files are stored.However you can also run a query. Try this if you want to find the location of the files.select * from sys.master_filesHere is a link that explains what the columns mean if you run the above query.[url]http://msdn.microsoft.com/en-us/library/ms186782.aspx[/url]Is that what you are looking for?r&r |
 |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-01-26 : 20:57:58
|
| Absolutely . Thanks a lot. |
|
|
|
|
|
|
Files question