Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Logs Expand / Collapse
Author
Message
Posted Thursday, November 01, 2012 2:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Hello all,

In SQL SERVER 2008, if any DML activity or any import export or any Backup restore etc is been done... then where does this information gets stored?????

How will i able to know where to find & what would be the best approach??

IF i have to set this in oredr to track work.. how should i set this task???
Please help me








************************************
Every Dog has a Tail !!!!!
Post #1379658
Posted Thursday, November 01, 2012 3:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
Backup restore is stored in MSDB, in the restore history and backupset tables and many more.

Some DML (Insert, Update, Delete) is stored in the transaction log, assuming you have bulk or full recover set on your database and then you need to ensure that you do regular transaction log backups.

Import Export is not logged unless you create some custom logging and build it into the import export routines.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1379683
Posted Thursday, November 01, 2012 3:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
But what if the databse doesnot start due to some reason.. how to find the reason & where to fin the information







************************************
Every Dog has a Tail !!!!!
Post #1379689
Posted Thursday, November 01, 2012 3:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
look in the sql and windows logs



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1379692
Posted Thursday, November 01, 2012 3:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 41,521, Visits: 34,438
That will be in the SQL Server error log.

Just to clarify something Anthony said. Data modifications (insert, update, delete and DDL) are stored in the tran log regardless of what recovery model you have, but the transaction log is not an audit log, it's not there to tell you who did what. It's there to allow rollbacks, database recovery and to guarantee durability of changes.
If you want an audit trail, you have to set one up.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1379694
Posted Thursday, November 01, 2012 3:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Thanks Gila, but reagrding SQL SERVER Error Log, will this will a file stored on any location???
coz if DB wont start how to check Error logs then??

More over coming to Audit, can u provide links where in i would read, understand & start implementing it?










************************************
Every Dog has a Tail !!!!!
Post #1379698
Posted Thursday, November 01, 2012 3:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:15 PM
Points: 5,951, Visits: 12,822
runal_jagtap (11/1/2012)
Thanks Gila, but reagrding SQL SERVER Error Log, will this will a file stored on any location???
coz if DB wont start how to check Error logs then??

More over coming to Audit, can u provide links where in i would read, understand & start implementing it?



Typically, the error logs are stored in C:\Program Files\Microsoft SQL Server\MSSQL10_50.instname\MSSQL\Log but obviously this may have been changed


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1379700
Posted Thursday, November 01, 2012 3:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
If SQL doesn't start it will tell you why in the Windows event viewer, if a DB doesn't start it will be in the SQL error log.

As Perry has already detailed the logs are typically stored where the binaries are but can be changed.

As for auditing it all depends on what you want to audit, maybe here will be a good place to start reading up http://msdn.microsoft.com/en-us/library/cc280386%28v=sql.105%29.aspx or do a search on a search engine of your choice on the topic




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1379702
Posted Thursday, November 01, 2012 3:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
i opened Event Viewer.. but exactly where do i find the Logs stating SQL server







************************************
Every Dog has a Tail !!!!!
Post #1379705
Posted Thursday, November 01, 2012 4:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 41,521, Visits: 34,438
Not event viewer. The SQL Server error log. (Those log entries are in the application event log too, often harder to find among all events from all the other apps)

It's a text file on disk (location depends where you installed SQL), latest one is simply called ERRORLOG



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1379707
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse