Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

SQL server Logs

Hi All

I Need to know all the SQL logs including auditing the sql events, I want to check the SQL Logs so I can track any problmes in SQL, Also i want to know what is the maximum Databasesize in Ms SQL 2000.


Thanks
0
ibmas4002
Asked:
ibmas4002
  • 2
2 Solutions
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
Here's a comparison with MySQL 4.1 with info on SQL Server:
http://databasejournal.com/features/mssql/article.php/3087841

Maximum Database size for Enterprise, Standard, Workgroup, and developer editions:
1,048,516 terabytes

Reference:
http://www.microsoft.com/sql/evaluation/overview/default.asp
(Scalability under "Product SKU Matrix")
0
 
nmcdermaidCommented:
There's the standard SQL logs, most easily found in Enterprise manager.

Then you can also run a trace in SQL Profiler that will give you more event information than you could analyze in three lifetimes.

Fire up SQL Profiler and have a look
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
The several logs you need to consider when using SQL Server:

1) SQL Server Logs: you can find them under Enterprise Manager-->Management-->Error Logs  
2) System and Application logs: you can find them under Control Panel-->Administrative tools-->Event Viewer
3) Cluster Logs if your server is in a cluster

Maximum database size depends on what version of SQL Server you got.  Data Center edition has a 32TB capacity.

Hope this helped...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Hi LearnedOne,

With all respect to leew, believe I contributed to answer precisely to the asked question;  I do believe i deserve some points for that...
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now