adding datafile to database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db - 11 Mar 2008 20:48 GMT

sql server 2000 sp4
Hi
I have a database that was initially created for 70MB. It has a application
associated with it and can not be deleted. I need to increase size of the
database to 440 GB. What is the best way of doing it.

Signature

ontario, canada

Reply to this Message

Tibor Karaszi - 11 Mar 2008 23:22 GMT

Do you want to add another file or increase the size of an existing file? Anyhow, both operations
are very straight forward:

ALTER DATABASE db ADD FILE (...)

ALTER DATABASE db MODIFY FILE (...)

You find exact syntax in Books Online. It will take a while to add or grow a file close to half a
terabyte...

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> sql server 2000 sp4
> Hi
> I have a database that was initially created for 70MB. It has a application
> associated with it and can not be deleted. I need to increase size of the
> database to 440 GB. What is the best way of doing it.

Reply to this Message