Re: <<filegroup>> files from different hard disks:: tables(s) sto
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/24/04
- Next message: Pike: "Re: Seasons Greetings"
- Previous message: Andrew J. Kelly: "Re: <<filegroup>> files from different hard disks:: tables(s) sto"
- In reply to: Tania: "Re: <<filegroup>> files from different hard disks:: tables(s) sto"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Dec 2004 09:53:28 -0500
If you don't have RAID then this is the "poor man's" RAID0. As long as you
don't fill up one of the files, then each table or index you place into the
filegroup will have pages distributed across both files. IOW, the
probability is quite high that the tables/indexes will be striped across
both files. Just make sure you have free space in both files.
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com "Tania" <Tania@discussions.microsoft.com> wrote in message news:8A58AFDA-8768-4073-A0F8-8F53AF236D87@microsoft.com... Thanks alot Tom So, to clarify .... this is not like a RAID 0 simulation at all ? Unless the one file in the filegroup gets full, the chances for having the data for one index shared between the 2 hard disks is zero ? Basically, I do not have RAID, and I do not worry about fault tolerance. I just want data to be striped across more than one hard drive for faster IO speed. Thanks Tania "Tom Moreau" wrote: > Relax! When you create tables and indexes in a multi-file filegroup, they > will go to both files. If one of the files is full and cannot grow, then > the remaining file will get the table and index data. > > When you restore, the files will go to their original locations unless you > specify a different location. Thus, you could have a database that was > originally on two drives and then restore it onto another box with only one > drive - as long as you have the space. > > > -- > Tom > > --------------------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA > SQL Server MVP > Columnist, SQL Server Professional > Toronto, ON Canada > www.pinnaclepublishing.com > > > "Tania" <anonymous@discussions.microsoft.com> wrote in message > news:104101c4e9c1$cee34fa0$a601280a@phx.gbl... > Hi > > I am feeling very ignorant on these matters, so please > help out a technologically disabled woman !! > > I want an easy way to store table data on different hard > drives without worrying how that happens in the > background: > > I created an additional filegroup 'fg_test' for my > database and added 2 files to it. Each of the files is > located on a different hard drive. > Then I made fg_test my primary filegroup. > > My questions: > (1) > If I create new tables and indexes, on which hard drive > will these tables and indexes end up ? > (2) > What happens in the case of a backup and complete restore > for a database of which the primary filegroup points to 2 > hard drives ? Where will the tables go ? > > Merry Christmas ... and thanks a million ! > Tania > > > > >
- Next message: Pike: "Re: Seasons Greetings"
- Previous message: Andrew J. Kelly: "Re: <<filegroup>> files from different hard disks:: tables(s) sto"
- In reply to: Tania: "Re: <<filegroup>> files from different hard disks:: tables(s) sto"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
