Sonia-SQLDeveloper
Monday, December 12, 2011
How to Archive SQL error Logs
To create a new error log, execute following:
1. Restart the sql server service. It will create a new error log
2. Execute following:
Exec ('DBCC ErrorLog')
3. Execute following:
Exec Sp_Cycle_Errorlog
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)