delete log file - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

delete log file

Author

Topic

majidsoft
Starting Member

7 Posts

Posted - 2013-03-25 : 05:22:00

HI how can i clear sql server logs in sql 2005
i want to clear all log files

majidsoft
Starting Member

7 Posts

Posted - 2013-03-25 : 07:33:32

in sql server 2005 in management part we have sql server logs and activity monitor i want to clear this two part

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-03-25 : 12:36:10

Do you mean SQL Server Transaction Log files or SQL Server Error Log files?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

majidsoft
Starting Member

7 Posts

Posted - 2013-03-25 : 17:35:30

i means transaction and error log file

chadmat
The Chadinator

1974 Posts

Posted - 2013-03-25 : 18:18:39

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

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-03-26 : 02:52:57

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

majidsoft
Starting Member

7 Posts

Posted - 2013-03-26 : 22:28:27

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

chadmat
The Chadinator

1974 Posts

Posted - 2013-03-27 : 11:48:07

That sounds awfully suspicious.

-Chad

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-03-27 : 16:28:47

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources