April 4, 2011 at 4:59 pm
Hi,
In SQL Server 2005, At instance level i have changed my default database settings as below
Data: D:\sqldata
Log: E:\sqldata
Also, i have changed the location of tempdb to F:\ drive for better manageability purpose.
Now i have two questions regarding these locations
1. If i start the sql server normally, then tempdb is getting created in F:\ drive as expected.
If belive, the locations of the tempdb is taken from master database.
2. If i start the sql server in minimally configuration mode i.e -f, now tempdb is getting created in default database settings location.
Why? I think, here in this case the locations are read from registry and not the master database. please correct me if am wrong.
Also,in default database settings i said to create the .mdf file in "D:\sqldata" and .ldf to "E:\sqldata". If that is true,
it has to create the tempdb .mdf in D:\sqldata and temp.ldf in E:\sqldata but as per my observation both mdf and ldf are getting created in
D:\sqldata. Why it is doing like that, is that a bug in sql server??/
Thanks in Advance.
April 5, 2011 at 3:00 am
only the master database and the error log location are held in the registry along with default data and log and backup paths. Tempdb location is taken from the master database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply