InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 20:32:20 GMT20http://www.sqlservercentral.com/Forums/Topic937356-391-1.aspx10XFri, 18 Jun 2010 16:13:13 GMTpeleghttp://www.sqlservercentral.com/Forums/Topic937356-391-1.aspxALTER DATABASE db_nameMODIFY FILE [i]Secondary.ndf[/i] NAME = [i]logical_file_name [/i], OFFLINE[url]http://msdn.microsoft.com/en-us/library/bb522469.aspx[/url][url]http://msdn.microsoft.com/en-us/library/ms191155.aspx[/url]Fri, 18 Jun 2010 04:27:48 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic937356-391-1.aspxSSC-Addicted thanks1 more questionhow do i take the FG offline as you mentioned?Fri, 18 Jun 2010 04:15:35 GMTpeleghttp://www.sqlservercentral.com/Forums/Topic937356-391-1.aspx[quote][b]peleg (6/18/2010)[/b][hr]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'show can i still work with the Primary one?[/quote]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.Fri, 18 Jun 2010 03:45:44 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic937356-391-1.aspxThings to consider:> [url]http://msdn.microsoft.com/en-us/library/ms187087(v=SQL.100).aspx[/url]> [url]http://msdn.microsoft.com/en-us/library/ms175561.aspx[/url]Fri, 18 Jun 2010 02:08:13 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic937356-391-1.aspxi am talking about the FG which is on another hard-disk.an i wantto know what can i do if that Hard-disk crash'show can i still work with the Primary one?Fri, 18 Jun 2010 00:25:53 GMTpeleghttp://www.sqlservercentral.com/Forums/Topic937356-391-1.aspxI 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.Thu, 17 Jun 2010 23:42:23 GMTlakshmi2nphttp://www.sqlservercentral.com/Forums/Topic937356-391-1.aspxi 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)?Tue, 15 Jun 2010 04:15:01 GMTpeleg