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.
Author |
Topic |
mrpreethi
Starting Member
10 Posts |
Posted - 2010-02-04 : 06:05:33
|
I want to know what were all the transactions on a particular previous date and time .It may be error or transaction executed .TO check this which file do i need to check ?Iam new to SQL Server .Please help... |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-04 : 06:08:03
|
you need to look into transaction log for this. But you need to make sure your recovery model is full or bulk logged for getting log info. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-04 : 06:12:26
|
also seehttp://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html |
|
|
|
|
|