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 |
|
jeanh
Starting Member
20 Posts |
 Posted - 2004-05-16 : 13:56:30
|
| I am using MSDE in conjuction with a software package called Microsoft Retail Management System. The log file has gotten too big and I cannot do anything with my SQL database. I finally figured out the correct syntax to dbcc shrinkdatabase (xxx) but wondered if that was the best way to handle this problem. The inability to connect to a data base because the log file is too big seems like it should be easier to recover from. Do you recommend using SET RECOVERY SIMPLE? Do you recommend using SET AUTO_SHRINK ? Thanks for your feedback.JeanJean Holland |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-16 : 15:37:44
|
| You shouldn't need SET AUTO_SHRINK. You do need to set your recovery mode to SIMPLE though. The only reason you shouldn't have it set to simple is if you are doing transaction log backups, which it sounds like you are not doing.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Log File Full