Can the Secondary files in a database be taken offline?

• Nakul Vachhrajani

  SSChampion

  Points: 10294

  More actions

  November 27, 2010 at 11:05 am

  #229183

  Comments posted to this topic are about the item Can the Secondary files in a database be taken offline?

  Thanks & Regards,
  Nakul Vachhrajani.
  http://nakulvachhrajani.com

  Follow me on
  Twitter: @sqltwins

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 28, 2010 at 3:39 am

  #1256012

  Great question, thanks.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  November 28, 2010 at 5:50 am

  #1256021

  Nice question with no tricks and clear explanation. More like this, please.

  Tom
  

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  November 28, 2010 at 9:32 pm

  #1256092

  Thats great question. Thanks.

  Thanks

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  November 28, 2010 at 9:35 pm

  #1256093

  One more point: Links are also perfect 🙂

  Thanks

• Mayank Parmar

  Ten Centuries

  Points: 1019

  More actions

  November 28, 2010 at 11:04 pm

  #1256114

  Good Question.

  Learned something new.

  Never worked with secondary files, but then also was able to guess correct. 🙂

  Regards,

  --------------------------------------------------------------------------------
  Mayank Parmar
  Software Engineer

  Clarion Technologies
  SEI CMMI Level 3 Company

  8th Floor, 803, GNFC info Tower,
  SG Highway, Ahmedabad - 380 054,
  Gujarat, India.
  www.clariontechnologies.co.in

  Email: mayank.parmar@clariontechnologies.co.in
  MSN : mayank.parmar@clariontechnologies.co.in
  Mobile: +91 9727748789
  --------------------------------------------------------------------------------

• sharath.chalamgari

  SSCertifiable

  Points: 5680

  More actions

  November 28, 2010 at 11:14 pm

  #1256115

  New topic to me, learned something new. my guess was correct :w00t:

• November 29, 2010 at 12:34 am

  This was removed by the editor as SPAM

• naresh.talla

  SSCommitted

  Points: 1929

  More actions

  November 29, 2010 at 2:05 am

  #1256142

  Challenging question.....

  everyone little bit in confuse....................

• Henrik Staun Poulsen

  SSCertifiable

  Points: 6576

  More actions

  November 29, 2010 at 2:58 am

  #1256152

  I particular like the "DO NOTE" comment.

  I got burnt by that a few years ago.

• SanDroid

  SSChampion

  Points: 10068

  More actions

  November 29, 2010 at 9:59 am

  #1256323

  Great Question.

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  November 29, 2010 at 10:12 am

  #1256329

  Thanks for the question

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• Surii

  Default port

  Points: 1497

  More actions

  November 29, 2010 at 2:53 pm

  #1256510

  Good question 🙂

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 30, 2010 at 7:54 am

  #1256806

  Very nice question.

  Slightly different than the one, we get generally !!

  Thanks.

• UMG Developer

  SSChampion

  Points: 13482

  More actions

  December 3, 2010 at 1:38 pm

  #1258640

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