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 |
|
siva.meti
Starting Member
32 Posts |
 Posted - 2007-10-25 : 02:44:53
|
| Hi Friends,My database put into SIMPLE RECOVERY MODE then my T-log file is incresing doule. what i can do to recove the normal stage any plz give suggetions give good result we will appriciate to you Best RegardsMeti BEST OF THE BEST |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-25 : 09:04:47
|
Not sure I understand your question but it sounds like your database is in simple recovery mode but the Transaction log size has doubled and you want to shrink it. Is that correct? The log will still grow in simple recovery mode, what it should have done is truncate the log which makes the space available for use but does not shrink the physical file, the freed up space will be re-used as needed. You can shrink the physical file using DBCC SHRINKFILE but it is not recommended because regrowing the file is an expensive operation. In other words, you should be OK leaving it alone.
Future guru in the making. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-25 : 22:21:47
|
| Ensure there is no long running open transaction, it'll prevent truncate committed transactions in the log. |
|
|
|
|
|
|
BACKUP