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 ««12

Can the Secondary files in a database be taken offline? Expand / Collapse
Author
Message
Posted Monday, November 29, 2010 9:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 20,455, Visits: 14,073
Thanks for the question



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


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

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, November 04, 2013 4:02 PM
Points: 659, Visits: 474
Good question
Post #1027635
Posted Tuesday, November 30, 2010 7:54 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 785, Visits: 1,259
Very nice question.

Slightly different than the one, we get generally !!


Thanks.
Post #1027998
Posted Friday, December 03, 2010 1:38 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 3:33 PM
Points: 2,526, Visits: 530
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
MCTS: SQL Server 2008, Implementation and Maintenance
Post #1156573
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse