Logs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Logs

13 posts, Page 1 of 2

1 2 »»

Logs

Rate Topic

Display Mode

Topic Options

Author

Message

OnlyOneRJ

Posted Thursday, November 01, 2012 2:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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

anthony.green

Posted Thursday, November 01, 2012 3:23 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

OnlyOneRJ

Posted Thursday, November 01, 2012 3:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

But what if the databse doesnot start due to some reason.. how to find the reason & where to fin the information w00t

************************************
Every Dog has a Tail !!!!!

Post #1379689

anthony.green

Posted Thursday, November 01, 2012 3:38 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

look in the sql and windows logs

Post #1379692

GilaMonster

Posted Thursday, November 01, 2012 3:39 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

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

OnlyOneRJ

Posted Thursday, November 01, 2012 3:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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?

Smile

************************************
Every Dog has a Tail !!!!!

Post #1379698

Perry Whittle

Posted Thursday, November 01, 2012 3:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 5,201, Visits: 11,154

runal_jagtap (11/1/2012)

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" Wink

Post #1379700

anthony.green

Posted Thursday, November 01, 2012 3:50 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Post #1379702

OnlyOneRJ

Posted Thursday, November 01, 2012 3:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

i opened Event Viewer.. but exactly where do i find the Logs stating SQL server

************************************
Every Dog has a Tail !!!!!

Post #1379705

GilaMonster

Posted Thursday, November 01, 2012 4:00 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

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 »

13 posts, Page 1 of 2

1 2 »»

Permissions