InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 22:06:17 GMT20http://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxGood question! I also want to recommend everyone to create one or more filegroup for user objects (like tables and indexes) and never place any user object in primary filegroup. If you separate the user objects from the system objects the database will be online even if you get a drive failure for the secondary filegroup (Enterprise feature).Tue, 09 Aug 2011 02:10:47 GMThakan.wintherhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxThanks for the question, and the note so we know what to watch out for.Fri, 03 Dec 2010 13:38:33 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxVery nice question. Slightly different than the one, we get generally !!Tue, 30 Nov 2010 07:54:51 GMTSQL-DBA-01http://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxGood question :-)Mon, 29 Nov 2010 14:53:28 GMTSuriihttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxThanks for the questionMon, 29 Nov 2010 10:12:16 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxGreat Question.Mon, 29 Nov 2010 09:59:49 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxI particular like the "DO NOTE" comment.I got burnt by that a few years ago.Mon, 29 Nov 2010 02:58:33 GMThenrik staun poulsenhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxChallenging question.....everyone little bit in confuse....................Mon, 29 Nov 2010 02:05:36 GMTnaresh.tallahttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxGood question, thanks.this is really handy, as my archiving database uses numerous secondary files (one per related data area, e.g. clients, arrangements, accounts)Mon, 29 Nov 2010 00:34:19 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxNew topic to me, learned something new. my guess was correct :w00t:Sun, 28 Nov 2010 23:14:04 GMTsharath.chalamgarihttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxGood Question. Learned something new. Never worked with secondary files, but then also was able to guess correct. :-)Regards,Sun, 28 Nov 2010 23:04:57 GMTMayank Parmarhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxOne more point: Links are also perfect :-)Sun, 28 Nov 2010 21:35:29 GMTHardy21http://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxThats great question. Thanks.Sun, 28 Nov 2010 21:32:22 GMTHardy21http://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxNice question with no tricks and clear explanation. More like this, please.Sun, 28 Nov 2010 05:50:45 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxGreat question, thanks.Sun, 28 Nov 2010 03:39:17 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1026986-2785-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Restore/71604/">Can the Secondary files in a database be taken offline?</A>[/B]Sat, 27 Nov 2010 11:05:36 GMTNakul Vachhrajani