SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 delete log file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

majidsoft
Starting Member

7 Posts

Posted - 03/25/2013 :  05:22:00  Show Profile  Reply with Quote
HI how can i clear sql server logs in sql 2005
i want to clear all log files

majidsoft
Starting Member

7 Posts

Posted - 03/25/2013 :  07:33:32  Show Profile  Reply with Quote
in sql server 2005 in management part we have sql server logs and activity monitor i want to clear this two part
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 03/25/2013 :  12:36:10  Show Profile  Visit jackv's Homepage  Reply with Quote
Do you mean SQL Server Transaction Log files or SQL Server Error Log files?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

majidsoft
Starting Member

7 Posts

Posted - 03/25/2013 :  17:35:30  Show Profile  Reply with Quote
i means transaction and error log file
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 03/25/2013 :  18:18:39  Show Profile  Visit chadmat's Homepage  Reply with Quote
To clear the transaction log, you need to back it up (If you are in Full or Bulk Logged recovery). But I'm not sure if that is what you are asking.

-Chad
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 03/26/2013 :  02:52:57  Show Profile  Visit jackv's Homepage  Reply with Quote
If you want to recycle the SQL Server Erroir logs , use : http://www.sqlserver-dba.com/2012/11/sql-server-dbcc-errorlog-or-exec-mastersp_cycle_errorlog.html

Are you have having disk space issues?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

majidsoft
Starting Member

7 Posts

Posted - 03/26/2013 :  22:28:27  Show Profile  Reply with Quote
im entering in sql server 2005 and sql server 2000 and doing some jobs
like deleting tables , clearing data , creating user and delete user.
now i want to clear all the logs that show my activity in two version of sql server
i want nobody know what im doing

Edited by - majidsoft on 03/26/2013 22:30:31
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 03/27/2013 :  11:48:07  Show Profile  Visit chadmat's Homepage  Reply with Quote
That sounds awfully suspicious.

-Chad
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 03/27/2013 :  16:28:47  Show Profile  Visit jackv's Homepage  Reply with Quote
To evade detection you'd probably also have to do some manipulation of the default trace .. if it's turned on , which captures certain events. you'd probably also have to clear memory.

There are other areas which need to be analysed if you wanted to evade forensic analysis.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000