Re: Multiple Data Files on the Same Drive


GreekDude wrote:
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

I have seen instances where multiple data files were created because of
limited disk space and the admin was planning to put them on seperate
drives at a later time.

Keeping the data files on the hard drive is never a best practice. In
fact not should they be kept on another hard drive. The drives should
also be on seperate controllers.

.. Gus

.

Relevant Pages

  • Re: SMART predicts crash
    ... your data files to floppy or to a CDRW drive [you can get these for like $40 ... > monitoring feature on hard drives. ... > warranty, then give the tech support people a ring. ...
    (microsoft.public.security)
  • Re: Unable to find backup files?
    ... chose the option that does a system recovery with a backup. ... Do you know for a fact your data files were backed up, ... I know money's tight in school but external USB hard drives are pretty cheap ...
    (microsoft.public.windowsxp.general)
  • Re: 2nd drive not seen after reinstall
    ... I have two physical 320 MB hard drives. ... One was used with one of the partitions for my root and another ... A number of data files ...
    (alt.os.linux.suse)
  • Re: HDD Compatibility
    ... and new larger drives appear in the ... BIOS Upgrades ... available expansion slot and then connecting your hard drives to it. ... than having to connect them to the controller card itself. ...
    (alt.comp.hardware.pc-homebuilt)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... You'll not be using most of the system databases intensively so you don't need to seperate them, I mean locating them on different physical disks. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... For this question you must understand the reason why we should seperate data and log files. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
    (microsoft.public.sqlserver.setup)