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 |
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2007-02-01 : 02:58:08
|
Hi I restored a database 'markdev' , data file size is 7000 mb log file size is 2000 mb now I want to change data file size is 1000 mb and logical file size is 250 mbI tried with this query ALTER DATABASE markdev MODIFY FILE (NAME = 'markdev_Data, SIZE = 1000 mb)ALTER DATABASE markdev MODIFY FILE (NAME = 'markdev_log, SIZE = 250 mb)error isServer: Msg 5039, Level 16, State 1, Line 1MODIFY FILE failed. Specified size is less than current size.please suggest me |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2007-02-01 : 03:09:47
|
yes it is less than 300 mb |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-01 : 03:14:40
|
Also take a look here http://msdn2.microsoft.com/en-us/library/aa176794(SQL.80).aspx KH |
|
|
|
|
|