Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amy
Starting Member
30 Posts |
 Posted - 2002-06-17 : 15:03:21
|
| How do I increased more site for the data file?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 15:44:22
|
| ALTER DATABASE myDatabase MODIFY FILE (NAME=filename, SIZE=newsize)The filename portion must be the physical data file name, including the full path. The size portion, for example, would be listed as "100MB" for a 100 megabyte data file size.The ALTER DATABASE command is fully documented in Books Online. |
 |
|
|
amy
Starting Member
30 Posts |
Posted - 2002-06-17 : 17:29:38
|
| ThanksThat command just work only when you new # is lager then orginal # but what I want is new # is smaller because I want to reduce the size not increase the size of the databasethan orginal # and it won't let me do itThanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 17:42:49
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16877 |
|
|
|
|
|
|
data file