Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FileGroups Expand / Collapse
Author
Message
Posted Tuesday, June 15, 2010 4:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:46 AM
Points: 123, Visits: 513
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
Posted Thursday, June 17, 2010 11:42 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 4, 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
Posted Friday, June 18, 2010 12:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:46 AM
Points: 123, Visits: 513
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
Posted Friday, June 18, 2010 2:08 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 AM
Points: 3,915, Visits: 5,098
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
Posted Friday, June 18, 2010 3:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
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
Posted Friday, June 18, 2010 4:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:46 AM
Points: 123, Visits: 513
SSC-Addicted thanks
1 more question
how do i take the FG offline as you mentioned?
Post #939460
Posted Friday, June 18, 2010 4:27 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 AM
Points: 3,915, Visits: 5,098
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
Posted Friday, June 18, 2010 4:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:46 AM
Points: 123, Visits: 513
10X
Post #939886
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse