FileGroups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » FileGroups

FileGroups

Rate Topic

Display Mode

Topic Options

Author

Message

peleg

Posted Tuesday, June 15, 2010 4:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

i have a db, in which i create a FileGroup on a diffrend Physical disk, and put tables on.
if the disk with the FG dosen't work, how can i bring back the DB to work (i mean the orignal DB withought the FG)?

Post #937356

lakshmi2np

Posted Thursday, June 17, 2010 11:42 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 04, 2012 3:29 AM
Points: 91, Visits: 80

I am assuming that you are speaking about SQL Server 2008. Can you tell me if it is the primary filegroup or the secondary filegroup that you are talking about.

Thanks.

Post #939367

peleg

Posted Friday, June 18, 2010 12:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

i am talking about the FG which is on another hard-disk.
an i wantto know what can i do if that Hard-disk crash's
how can i still work with the Primary one?

Post #939380

Stewart "Arturius" Campbell

Posted Friday, June 18, 2010 2:08 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164, Visits: 4,344

Things to consider:
> http://msdn.microsoft.com/en-us/library/ms187087(v=SQL.100).aspx
> http://msdn.microsoft.com/en-us/library/ms175561.aspx

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #939413

Suresh B.

Posted Friday, June 18, 2010 3:45 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:54 AM
Points: 1,076, Visits: 5,128

peleg (6/18/2010)

i am talking about the FG which is on another hard-disk.
an i wantto know what can i do if that Hard-disk crash's
how can i still work with the Primary one?

You can still "work" with the Primary file group by taking the files on the crashed disk offline.

However, you cannot make the file online without backup.

I would like to add two more points here:
1) You should have RAID. If a disk crashes, replace it with new one.
2) If you take data file offline, the objects on that file will become inaccessible. So your application may not "work".

Hope this answers your question.

Post #939446

peleg

Posted Friday, June 18, 2010 4:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

SSC-Addicted thanks
1 more question
how do i take the FG offline as you mentioned?

Post #939460

Stewart "Arturius" Campbell

Posted Friday, June 18, 2010 4:27 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164, Visits: 4,344

ALTER DATABASE db_name
MODIFY FILE Secondary.ndf
NAME = logical_file_name
, OFFLINE

http://msdn.microsoft.com/en-us/library/bb522469.aspx
http://msdn.microsoft.com/en-us/library/ms191155.aspx

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #939466

peleg

Posted Friday, June 18, 2010 4:13 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

10X

Post #939886

« Prev Topic | Next Topic »

Permissions