Re: Multiple Data Files on the Same Drive


Randy wrote:
I recently starting working on some DBs that were created by someone else who
is long gone.

Several of the DBs have multiple Data files all located on the same hard
drive. Most of the files are 4gig, but some database have Data files that
range from 4 meg to 45 gig in the same DB - but the files are all on the same
hard drive.
Some of the Log files are also split into multiple files, but again always
on the same hard drive.

My understanding was that multiple Data files only helped if the files were
located on different hard drives.

Q) Is having multiple Data files on the same hard drive a Good thing? A Bad
thing? Or neither?

Most of these databases also have the Data file(s) and Log file(s) on the
same hard drive, which I know is bad idea for recovery purposes.

Thanks in advance, Randy

.

Relevant Pages

  • Re: performance optimization?
    ... need more RAM. ... Only if your machine is IO limited by your hard drives does it make much ... I do run database software and even with that I have ... # semaphore maximum value: 32767 MAX ...
    (comp.os.linux.misc)
  • Re: A Silly Database Question
    ... is what hard drives used to look like before the rectangular ... sure before I said anything to my database students or add ... The picture of the drum in the article really looks like a can. ... stacking disk on top of each other in cylinder fashion ...
    (comp.databases)
  • Re: Mirroing Exchange Information Store
    ... The number of spindles in a given array ... Two of the hard drives are 33 GB each and four are 63 GB each. ... another portion for the transaction logs. ... I'm trying to reconfigure the server so that each database have it ...
    (microsoft.public.exchange.admin)
  • Re: RESTORE DATABASE: put data on DIFF FILES in a FILEGROUP
    ... my table and index data over different hard drives. ... I need to 'copy' databases from server A to server B and in the process I ... as part of the restore I need to restore the data to ... If the database name that you want to restore to exists, then the file layout need to ...
    (microsoft.public.sqlserver.programming)
  • Re: Hardware setup
    ... Many of my customers use RAID5 for the database volume, ... > I am getting ready to purchase a new Exchange server and install Exchange ... I'm looking for the optimal setup of hard drives for Exchange. ... The new server will be a dual Xeon 3.0ghz running Exch 2003 enterprise. ...
    (microsoft.public.exchange2000.setup.installation)
Loading