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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-24 : 08:29:14
|
| J.Scheeren writes "How kan i empty the log of mijn database to zerolog size is now about 100 mb." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-24 : 12:30:16
|
| What is your database recovery model set to? If it's full, then are you performing transaction log backups? If not, then why not change your recovery model to Simple. If your log is full, check out BACKUP LOG DBNameGoeHere WITH NO_LOG.Also, check out DBCC SHRINKFILE if your transaction log has plenty of free space in it.BTW, 100MB isn't very big for a transaction log. Is there free space in it?Tara |
 |
|
|
|
|
|
Database log