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?
Loading
MuthuMari MPosted May 3, 2012, 12:13 PM
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 ArunPosted May 3, 2012, 1:02 PM