May 10, 2009 at 12:44 am
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
Could you give me some idea..
Thanks
May 14, 2009 at 11:27 am
Open Book On Line, search 'add more data files'.
May 14, 2009 at 11:51 am
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
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
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
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