February 6, 2009 at 12:20 am
dear all
i am using sql 2k,
due to huge mdf size growth we have planned to add addtional drive in the server...my ldf,mdf is in the same(old) path...now i want to create another primary data file in the new path...and another thing it is a production server, without affecting (stop any services)how can i do it...
suggestion pl.:D
February 6, 2009 at 12:44 am
This is a SQL2005 forum .... you had better posted this Q in the SQL2000 one.
1) Check books online regarding filegroups and their behavior.
2) If you have control over to which filegroup an object belongs, I would suggest to add a second filegroup and move over some tables and indexes.
After this operation, you'll have to shrink the primary file(group).
Your applications will notice all of these operations, because you will lock tables on the move !
Prepare your actions, plan a reasonable maintenance window.
Play it safe: start with a full backup !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 6, 2009 at 1:09 am
Continued here - http://www.sqlservercentral.com/Forums/Topic651434-5-1.aspx
No more replies to this thread please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply