Post reply

DBCC SHRINKFILE

  • October 27, 2006 at 4:25 am

    #61936

    Hi

    Is "DBCC SHRINKFILE (N'<logical name>',EMPTYFILE)" the only way of emptying a datafile and moving the data to other files in the filegroup?

    I'm currently running this on a 400Gb datafile to move the data into several smaller, more manageable data files but its taking forever (40+ hours so far and not even halfway through yet).

    Any suggestions to speeding this up would be greatly appreciated.

    Thanks

    Andy

  • October 27, 2006 at 5:56 am

    #668453

    I just moved the objects from within EM, although I think I scripted it too. Can't remember exactly now. - and I only had a couple of objects to move out of a data file.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 27, 2006 at 6:40 am

    #668469

    To move objects on other filegroups you simply need to change the clustered index filegroup.

Viewing 3 posts - 1 through 2 (of 2 total)

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