Post reply

Multiple files defined for a database

  • November 3, 2006 at 3:05 am

    #61975

    Hi,

    I currently work for a number of clients, and one of my clients decided to add some new data files to the primary file group, even though there is only one disk. This in itself is not really a problem, but when I need size the database correctly, I need to take into account the two files.

    Is there a way for me to merge these two files together? I could then size the database properly.

    Thanks

    Peter Gadsby

    Peter Gadsby
    Business Intelligence Consultant
    www.hgconsult.co.uk

  • November 3, 2006 at 3:22 am

    #669723

    why don't you modify your script to take account of multiple files?

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

  • November 3, 2006 at 3:31 am

    #669724

    Because I don't know which tables have been allocated to which file because the new files have been added to the primary filegroup. Therefore I don't know how to correctly size each file.

     

     

    Peter Gadsby
    Business Intelligence Consultant
    www.hgconsult.co.uk

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

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