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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-02-02 : 09:19:52
|
SQL-Server by default installs its data and log files under Program Files folder like: E:\Program Files\Microsoft SQL Server\MSSQL\Data I usually keep my data files under E:\MSSQL\Data and log files on another drive like F:\MSSQL\Log. My client's standard is to use MS-SQL default folder for data files and another harddisk for log files. I am asking about this part: "putting data file under Program Files". Is it good idea? What is your strategy (or suggestion) and why? How about SQL system databases? Do you keep them in same place as your application DBs?Thanks,Canada DBA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-02 : 13:17:38
|
| Don't think I've seen a server configured with the data files there - if nothing else it's a pain to administer.Often put tempdb somewhere else.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-02-03 : 13:31:28
|
tempdb in a seperate place? Is it because of performance issue? And you keep all data files under Program Files? Any strategy? quote:
Originally posted by nr
...Often put tempdb somewhere else.
Canada DBA |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-03 : 17:56:26
|
| >> And you keep all data files under Program Files?Nope - I try to give it a short path for when I have to type it in or look at it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-03 : 17:58:21
|
| Here is what we do:F:\MSSQL\DATA\*.MDFG:\MSSQL\DATA\*.LDFH:\MSSQL\BACKUP\DBName\*.BAK, *.TRNTara |
|
|
|
|
|
|
Where keep data files?