Can the Secondary files in a database be taken offline?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Nakul Vachhrajani » Can the Secondary files in a database be...

Add to briefcase

16 posts, Page 2 of 2

««1 2

Can the Secondary files in a database be taken offline?

Expand / Collapse

Author

Message

Posted Monday, November 29, 2010 9:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

Great Question.

Post #1027421

Posted Monday, November 29, 2010 10:12 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks for the question

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1027427

Posted Monday, November 29, 2010 2:53 PM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, February 21, 2013 5:19 PM
Points: 658, Visits: 455

Good question Smile

Smile

Post #1027635

Posted Tuesday, November 30, 2010 7:54 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 1:33 AM
Points: 738, Visits: 1,126

Very nice question.

Slightly different than the one, we get generally !!

Thanks.

Post #1027998

Posted Friday, December 03, 2010 1:38 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question, and the note so we know what to watch out for.

Post #1030143

Posted Tuesday, August 09, 2011 2:10 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:31 AM
Points: 2,226, Visits: 438

Good 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).

/Håkan Winther
MCITP:Database Developer 2008

Post #1156573

« Prev Topic | Next Topic »

Add to briefcase

16 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse