Post reply

maintaining share point databases

  • May 10, 2009 at 12:44 am

    #132140

    Hello,

    Could you please anybody maintaining share point databases in sql server 2005, help me in creating multiple files for Content database, which is already in production with 70gb size. Right it has only one mdf file (on D drive)and one ldf file(on E drive)

    thanks

  • May 14, 2009 at 10:59 am

    #994720

    Could you give me some idea..

    Thanks

  • May 14, 2009 at 11:27 am

    #994750

    Open Book On Line, search 'add more data files'.

  • May 14, 2009 at 11:51 am

    #994764

    klnsuddu (5/10/2009)

    Hello,

    Could you please anybody maintaining share point databases in sql server 2005, help me in creating multiple files for Content database, which is already in production with 70gb size. Right it has only one mdf file (on D drive)and one ldf file(on E drive)

    thanks

    What do you want to accomplish by adding more files? What other drives do you have available to you?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • May 14, 2009 at 1:43 pm

    #994853

    What do you want to accomplish by adding more files? What other drives do you have available to you?

    Because the content database size is 70 GB now and it will grow to 150GB in few months.So, creating multiple datafiles will improve performance right? thats I want accomplish.. I have an empty F drive and I want create and place secondary files on F drive.

    But how to transfer/distribute existing data on D drive to F drive?

  • May 14, 2009 at 1:58 pm

    #994869

    Because the content database size is 70 GB now and it will grow to 150GB in few months.So, creating multiple datafiles will improve performance right? thats I want accomplish.. I have an empty F drive and I want create and place secondary files on F drive.

    Create another database file either through SQL Management Studio or through Alter database command and then cap the existing file so that it will not grow further.

    But how to transfer/distribute existing data on D drive to F drive?

    Why do you want to transfer contents for existing file to newly created file?

  • May 14, 2009 at 2:29 pm

    #994898

    klnsuddu (5/14/2009)

    What do you want to accomplish by adding more files? What other drives do you have available to you?

    Because the content database size is 70 GB now and it will grow to 150GB in few months.So, creating multiple datafiles will improve performance right? thats I want accomplish.. I have an empty F drive and I want create and place secondary files on F drive.

    Adding another file will help, but only if it is on another physical device. Just checking 🙂

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 7 posts - 1 through 6 (of 6 total)

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