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 |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2008-03-03 : 05:24:02
|
| i have a database which has a log file size of 10 Mb. it goes into single user mode automatically . i tried to increase the size of file size of log file from 10 mb to 50 mb... but i want to make it only 20 mb ... i am unable to change since it gives a message .cannot decrease the size of the file .. is there another way to decrease the size of log file .....also the database goes into suspect stage automatically sometimes |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2008-03-03 : 15:38:14
|
| You can shrink the database using dbcc.use <dbname>godbcc shrinkfile(<db file name data or log>, 20)go |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 22:29:31
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98281 |
|
|
|
|
|
|
suspect database