How to clear SQL Server Logs 
Author Message
 How to clear SQL Server Logs
Hello
I want to clear SQL Server Logs (SQL2K) or set the size limit, but I can't
find any command to do so.
Is it normal that  SQL Server log file is over 1000000 bytes large. (About
30 users is working on server).

Micha3



Sat, 28 Feb 2004 19:53:34 GMT
 How to clear SQL Server Logs

If you don't backup or truncate the logs on a regular basis they will grow.
Or you can set the Recovery Model to Simple. See Backup Log in Booksonline.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive

I proudly support the PASS SQL Server user community and its upcoming user
event,
 PASS 2001 North America. For details, visit <http://www.sqlpass.org>
www.sqlpass.org.)


Quote:
> Hello
> I want to clear SQL Server Logs (SQL2K) or set the size limit, but I can't
> find any command to do so.
> Is it normal that  SQL Server log file is over 1000000 bytes large. (About
> 30 users is working on server).

> Micha3



Sat, 28 Feb 2004 20:18:22 GMT
 How to clear SQL Server Logs
The error log is recreated every time you start SQL Server.  1000000bytes
shouldn't be a problem; that's less than 1 MB.


Quote:
> Hello
> I want to clear SQL Server Logs (SQL2K) or set the size limit, but I can't
> find any command to do so.
> Is it normal that  SQL Server log file is over 1000000 bytes large. (About
> 30 users is working on server).

> Micha3



Sat, 28 Feb 2004 21:02:32 GMT
 How to clear SQL Server Logs
... and if you want to recycle without restarting, check out:
sp_recycle_errorlog

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com


Quote:
> The error log is recreated every time you start SQL Server.  1000000bytes
> shouldn't be a problem; that's less than 1 MB.



> > Hello
> > I want to clear SQL Server Logs (SQL2K) or set the size limit, but I can't
> > find any command to do so.
> > Is it normal that  SQL Server log file is over 1000000 bytes large. (About
> > 30 users is working on server).

> > Micha3



Sat, 28 Feb 2004 21:28:50 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. How to clear the transaction log in SQL Server 2K Standard

2. Three event logged in the event view About SQLAgent whenever clear the event logs or failover

3. Transaction log dump doesn't clear log

4. Transaction log dump doesn't clear log

5. Clearing a log on Online workgroup server

6. How can i clear the MSHFLEXGRID without CLEAR - Como limpar a GRID sem usar CLEAR

7. Clearing Transaction Log Via SQL Statement

8. LOG file of a SQL database doesn't get cleared

9. Trigger Getting Cleared in SQL Server 2000 w/ Great Plains Dynamics

10. How can I clear sql-server perfectly ?

11. SQL-DMO Connect failure clears server name?

12. Clearing SQL Server memeory after running a query


 
Powered by phpBB® Forum Software