Re: database data files setup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Think of files and filegroups not just in terms of performance but also in terms of availability and disaster recovery. If you have a critical object, you might want to split that in multiple files spread across multiple disks and stored in multiple filegroups. Imagine a table that is spread across multiple files in multiple disks assigned to multiple filegroups. You will have the advantage of increased I/O performance plus the availability provided by filegroups

"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9369EC53-F442-4D47-B0EA-D16522628D0D@xxxxxxxxxxxxxxxx
I Have a database that has 120G imported from other database. Now I am
planning to setup this databse. I want to use more file groups. Except file
groups, I wonder which is better if I use one file or more files in one file
group to handle it. e.g. 100g, do you think if I use one file for 100g or 5
files and each is 20g?
Thanks.

.

Relevant Pages

  • Filegroup question
    ... I was reading an article about the use of filegroups. ... that multiple files/ filegroups were pretty much pointless unless they were ... theory and say that multiple files on the same disk array could improve ... But if the table were divided into three physical files (all part ...
    (microsoft.public.sqlserver.server)
  • Re: How do I insert multiple task lines at one time?
    ... select multiple lines, hit the insert key. ... Jan De Messemaeker ... Microsoft Project Most Valuable Professional ... For availability check: ...
    (microsoft.public.project)