|
Home > Archive > MS SQL Server > March 2006 > SQL Sever 2000 Database Drive Layout
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Sever 2000 Database Drive Layout
|
|
| Joe K. 2006-03-27, 8:23 pm |
|
I have SQL Server 2000 Enterprise Edition with several databases. The
server has
3 disk drives C:, D:, and E:.
I have the operating system loaded on the C:, SQL Server database data
loaded on the D:, and database backup and transaction log files loaded on E:
drive.
What could be better way to lay out the databases and backup files on the 3
disk drives?
| |
| Geoff N. Hiten 2006-03-27, 8:23 pm |
| I prefer writing backups to a network share on another machine. Otherwise,
your setup is very good. I am assuming these are actually different
physical disks and not different partitions or slices of the same RAID
container. If that is the case, then separating components has no net
effect.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Joe K." <Joe K.@discussions.microsoft.com> wrote in message
news:E3825426-CD0C-4846-91D3- 33DA8C90985A@microso
ft.com...
>
> I have SQL Server 2000 Enterprise Edition with several databases. The
> server has
> 3 disk drives C:, D:, and E:.
>
> I have the operating system loaded on the C:, SQL Server database data
> loaded on the D:, and database backup and transaction log files loaded on
> E:
> drive.
>
> What could be better way to lay out the databases and backup files on the
> 3
> disk drives?
>
>
|
|
|
|
|