March 25, 2008 at 12:35 pm
Hello guys, I have been ask to make decisions if I am suppose to have partition or filegroup in our newly created brand spanking new server. I have loaded the OS and also SQL Server 2005 in it. Now before moving everything from 2000 to 2005, I was asked which practice would be better.
1. What would be the best and why?
2. I am thinking of using Detach and then Attach the database from 2000 to 2005. Is this okay?
Help out Gurus!
FYI: It is a VLDB Datawarehouse environment
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 25, 2008 at 1:06 pm
Partitioning and configuring File Groups are very different. If you have a very large data database environment, you are likely to want to configure both. I would recommend you first read the books online sections on both subjects and you should probably get a book to help you get up to speed on the subjects.
As far as the detach / attach, that will work fine. You will need to update statistics when done and I would recommend reindexing entirely if you can.
March 25, 2008 at 1:17 pm
Thought of the same thing too. Thanks a bunch! But one thing though, will there be any other problem when doing the detach/attach process (I am definately backing up the db first)? Should I worry about anything at all?
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 25, 2008 at 1:29 pm
Also, any specific advise on configuring both filegroupd and partition? I read many articles but often get confused about what are the steps to watch out for??
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 26, 2008 at 12:51 pm
this whitepaper I found is quite useful:
March 26, 2008 at 2:02 pm
Thanks a bunch! That did help a lot in fact. Good Whitepaper.....
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply