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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 decrease data file size

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 mb

I 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 is
Server: Msg 5039, Level 16, State 1, Line 1
MODIFY FILE failed. Specified size is less than current size.

please suggest me


khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-01 : 03:05:05
You are not allow to do this. What is your database size ? Are you sure it is less than 1000 MB ?

Try shrinking. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59972


KH

Go to Top of Page

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-02-01 : 03:09:47
yes it is less than 300 mb
Go to Top of Page

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

Go to Top of Page
   

- Advertisement -