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 |
|
Deepan
Starting Member
2 Posts |
 Posted - 2010-08-10 : 03:40:48
|
| Hi guys,Can anyone pls tell me how do i get the transaction log from SQL Server. [insertions/updations/deletions made into the tables]Regards,Deepan |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-08-10 : 04:09:28
|
| Can you explain exactly what you want.If you want to restore AND have a full backup with differentials, then the trans log is easy to get, just use BACKUP LOG.If you are asking because you messed up and don't currently have a backup strategy or you backups are in simple or bulk logged mode, then chalk it down to experience. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-08-10 : 04:25:10
|
| I think he needs some kind of Audit tables.Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
Deepan
Starting Member
2 Posts |
Posted - 2010-08-10 : 06:54:27
|
| Everyday I am taking full backup of my database. Now i want to get the transaction level changes made into the database. i.e., i). records inserted/deleted, ii). tables/procedures/functions/triggers created/modified/deleted since last weekPls guide me as I have no experience in Database administration. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-10 : 07:06:53
|
| What for? Auditing? (consider triggers)To apply to another server (consider log shipping or replication)Something else?--Gail ShawSQL Server MVP |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-10 : 07:25:48
|
| The sql server logs are not possible to analyze just like that. There are some 3rd party tools available to read the logs but as far as I know you can't query them for statistics and such. If you need this kind of info you'll have to create some sort of auditing to capture all these events in separate tables. You can look up "DDL triggers" on this site to capture changes in tables/procedures/etc and this blog post of mine is about creating audit tables for the data in your database: http://thefirstsql.com/2010/05/21/create-an-audit-table-on-the-fly/- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
Transaction log for insert/update/delete