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 |
|
fabianus76
Posting Yak Master
191 Posts |
 Posted - 2006-01-15 : 07:40:42
|
| Hello guys!I would like to clear the logfile. Could anybody tell me how to do this?What I would like most would be to run SQL-Server without any log-file (while development). But I suppose that this is not possible. Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-15 : 09:30:05
|
| My opinion:--U can keep the size of logfile very small. But as u can c, the recovery may be not that effective in case of failure. -- U may not be able to work without a logfile (I'm not certain about this)-- U can clear the logfiles (but remember the consequences - in need of a recovery - not be that bad since u r talking about a development db, still after u do a lot of stuff like writing 50 different stored procedures and before anything else the DB fails u won't be able to recover it if the log file is truncated frequently)-- Clearing of logfiles can be done manually by detaching the DB and deleting the log file. Once u attach the DB and start working with it, it creates another logfile - small in size in the begining.-- U can setup to manage the growing of logfile in Entprse Mngr |
 |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-01-15 : 10:30:34
|
| Hallo Srinika, thank you very much for this detaching/deleting/attaching idea!Best regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-01-15 : 15:07:59
|
| Set the recovery model to simple for the database.Just make sure that you have an acceptable strategy for doing complete and differential backups,without the log you will loose all work done after the last backup if anybody messes up the development database.dbcc shrinkfile can be used to shrink the log file if it has grown too large.rockmoose |
|
|
|
|
|
|
how to clear the logfile