May 3, 2012 at 9:03 am
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?
May 3, 2012 at 9:39 am
Hello,
Right click on the instance in Management Studio and go to Properties, select Database Settings to view the default database files' locations.
Run the below query to view the database file locations of existing databases.
select name, physical_name from sys.master_files
Hope this is what you are looking for....
[font="Verdana"]Renuka__[/font]
May 4, 2012 at 2:59 am
to move temp db use:
Use Master
go
alter database tempdb
modify file (name = tempdev, filename = 'Drive:\folder\folder\tempdb.mdf');
go
alter database tempdb
modify file (name = templog, filename = 'Drive:\folder\folder\templog.ldf');
go
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply