Post reply

Moving files

  • August 25, 2011 at 6:35 am

    #1373091

    Data_God,

    the structure of table is allocated on primary filegroup or mdf file!!!! when you do references 'on filegroup .....' on table, you are saying: "the DATA/Records will allocated in filegroup"

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • August 25, 2011 at 7:26 am

    #1373136

    Great question. Read it way to fast. Was thinking about the objects and not the physical file and clicked yes like 60% so far. WOW!

    Bet we will see this one again. 😎

  • August 25, 2011 at 8:11 am

    #1373171

    Good question.

    I thought about this one for quite a bit. Obviously I can move indices between filegroups, unless they support unmovable constraints (which can be fixed using DROP EXISTING) but I can't think of any way to move a file except to remove it and then add it back elsewhere - and I'm not at all sure that that will preserve the content (maybe it deletes the file and creates a new one? - one can't specify a filegroup when modifying a file , only when adding it); so the answer was probably "no" - so I got my point, not because I knew the answer but because to me it seemed to be the most probably correct answer.

    Tom

  • August 25, 2011 at 8:32 am

    #1373191

    Thanks for the question!

  • August 25, 2011 at 9:52 am

    #1373278

    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

  • August 25, 2011 at 9:55 am

    #1373281

    Nice question. thanks

  • August 25, 2011 at 10:13 am

    #1373312

    I got this one wrong but I learned something...

  • August 25, 2011 at 10:34 am

    #1373333

    good question - thanks

  • August 25, 2011 at 1:01 pm

    #1373448

    I got it wrong because I was reading 'Data files can be moved...' when I was actually thinking 'Data can be moved..'

    Welll, reading questions correctly is also part of the challenge 😛

  • August 25, 2011 at 3:59 pm

    #1373531

    Nice Question Moinu.... But I got it wrong 🙁

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • August 26, 2011 at 11:12 am

    #1373971

    Same here 😉

    Tom.Thomson (8/25/2011)

    Good question.

    I thought about this one for quite a bit. Obviously I can move indices between filegroups, unless they support unmovable constraints (which can be fixed using DROP EXISTING) but I can't think of any way to move a file except to remove it and then add it back elsewhere - and I'm not at all sure that that will preserve the content (maybe it deletes the file and creates a new one? - one can't specify a filegroup when modifying a file , only when adding it); so the answer was probably "no" - so I got my point, not because I knew the answer but because to me it seemed to be the most probably correct answer.

  • August 28, 2011 at 12:30 am

    #1374281

    Simple and easy question.

Viewing 12 posts - 16 through 27 (of 27 total)

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