Can the Secondary files in a database be taken offline?

Question

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

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

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: 104768 More actions · Answer 2

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

Tom

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 3

Hardy21

SSCrazy Eights

Points: 9708

November 28, 2010 at 9:32 pm

#1256092

Thats great question. Thanks.

Thanks

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 4

Hardy21

SSCrazy Eights

Points: 9708

November 28, 2010 at 9:35 pm

#1256093

One more point: Links are also perfect 🙂

Thanks

Mayank Parmar Ten Centuries Points: 1019 More actions · Answer 5

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 · Answer 6

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

naresh.talla SSCommitted Points: 1929 More actions · Answer 7

Challenging question.....

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

Henrik Staun Poulsen SSCertifiable Points: 6594 More actions · Answer 8

I particular like the "DO NOTE" comment.

I got burnt by that a few years ago.

SanDroid SSChampion Points: 10068 More actions · Answer 9

SanDroid

SSChampion

Points: 10068

November 29, 2010 at 9:59 am

#1256323

Great Question.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 10

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 · Answer 11

Surii

Default port

Points: 1497

November 29, 2010 at 2:53 pm

#1256510

Good question 🙂

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 12

Very nice question.

Slightly different than the one, we get generally !!

Thanks.

UMG Developer SSChampion Points: 13482 More actions · Answer 13

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

SQLWinther SSCertifiable Points: 6294 More actions · Answer 14

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
MCSE: Data Platform