Dear All,
We have recently had an audit of our Server and have been told to move the
installation as it cannot be on the same partition or drive as the OS.
Can anyone tell me why ?
We are running 2000 on a 2003 box.
Thanks
PHi
Ideally, the installation should be on another drive so that the OS has the
C drive to itself. This helps to keep applications from the OS, enhancing
security.
Data, Logs and Backups should never be on the OS drive, each should be on
seperate drives for recoverability and performance.
Regards
Mike
"Patricia" wrote:
> Dear All,
> We have recently had an audit of our Server and have been told to move the
> installation as it cannot be on the same partition or drive as the OS.
> Can anyone tell me why ?
> We are running 2000 on a 2003 box.
> Thanks
> P|||Thanks Mike,
Our log and data files are on different drives.
What I can't understand is if they are on a different drive, then why do we
need to move our SQL Server program files ?
thanks
P
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Ideally, the installation should be on another drive so that the OS has th
e
> C drive to itself. This helps to keep applications from the OS, enhancing
> security.
> Data, Logs and Backups should never be on the OS drive, each should be on
> seperate drives for recoverability and performance.
> Regards
> Mike
> "Patricia" wrote:
>|||Actually I'd think that most people would the happy with the OS and SQL
installation on the same drive. The important thing is to keep your Data,
Log and Backup on seperate drives. The only thing I can think of with
regards to the installation files, is if you have your swapfile and tempdb
files on the same drive as your OS and SQL installation. In that case I'd
think about moving these to another drive, but personally I wouldn't be
concerned about having my OS and SQL files on the same drive.
Regards
Steen
Patricia wrote:[vbcol=seagreen]
> Thanks Mike,
> Our log and data files are on different drives.
> What I can't understand is if they are on a different drive, then why
> do we need to move our SQL Server program files ?
> thanks
> P
> "Mike Epprecht (SQL MVP)" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment