February 6, 2009 at 12:49 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.
February 6, 2009 at 7:07 am
ALTER DATABASE Test1
ADD FILE
(
NAME = Test1dat2,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat2.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
GO
http://msdn.microsoft.com/en-us/library/aa275464(SQL.80).aspx
MJ
February 6, 2009 at 1:20 pm
Personally, I don't like MAXSIZE unless you're really limited on disk space, in which case you should be proactively monitoring growth and determining when you may run out of space - before it actually happens.
-- You can't be late until you show up.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply