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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2006-12-28 : 13:43:05
|
| Hi All,I have moved SQL Server errorlog file location to SAN drive (Let's say E drive). There are no database files on E drive.If SAN goes down, E$ is not available, will SQL Server go down?Thanks in advance.---------------------------Sandesh - The Messenger |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-29 : 00:32:47
|
| error log wld be along with all the binaries in the default location.. did u change the the entire binaries location?i guess the server being up depends solely on the datafiles n also the services which are required for server to run ,asumming all the other aspects being normal.its me monty |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-29 : 01:25:36
|
| Due to space crunch,I only changed errorlog location...binaries are on original location. If SQL wont go down, what will be SQL's reaction if error log location is not reachable?---------------------------Sandesh - The Messenger |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-29 : 04:07:57
|
my understanding is that as the server cant locate the error log, errors like cannot locate specified path or unable to open the specified file kind of errors will be thrown to system log under application and system.though i have never came across this kind of situation, this is wat i understanding... its me monty |
|
|
|
|
|
|
SQL Server Error Log location