sql server r2 user database directory

Question

The network administrator setup a test instance of sql server 2008 r2 standard edition for me to work.I have little experience with sql server administration and deploying a small C#.net 2010 web application. Due to this fact, I have the following questions:

1. Can you tell me how I can find where the "user database directory" and "Temp DB Log directory" are located?

2. Can you tell me how to change the location of where the "user database directory" and "Temp DB Log directory" are located at?

MuthuMari M · Answer

Hi use this query you can find where the data and log files are located in ur database. select name physical_name from sys.master_files if u want to change the default location in left side object explorer ----> right click properties -----> select database settings there you have to select where you want to store data and log files. thanks If this post is useful then mark it as  Accepted Answer

Lajapathy Arun · Answer

Thanks for this useful info.