|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
How to view Ms sql server transaction log?
It maybe is a difficult problem to us..Any one can give me some thread?I can find it in http://www.sswug.org..But i have no visa card so that i can't access it as member.. ![]()
__________________
Being a Code Headman !
|
|
#2
|
|||
|
|||
|
you cann't!
and it was made this way...want do you want to do? restore an old transaction? |
|
#3
|
|||
|
|||
|
hi,sypher!THx for your reply.
yes,Just as you said..I wanna restore a old transaction according transaction log..Do u have a good idea for me?? |
|
#4
|
|||
|
|||
|
How to develope a database-replication program basing database-log?I will switch one database(ms sql)'s table to another database(ms sql)..En,it like import action..Or somebody can give me a light for figure me out this dark world? Just like a tutorial?!THX very much!
|
|
#5
|
|||
|
|||
|
I have a idea for repliaction db.Can u give me some suggestion?
Maybe it is complicated..Haha!But i hope u can read it entirely! 1.DB Prepare work: DB system must support trigger and 2 repilacted tables must have primarykey.We first create the same "corresponding-relation" table which contain repliacted table's primarykey and corresponding synckey which is exclusive in 2 repliaction table2 on 2 DB systems.And create the same "operation-log" table which log the user operation action and operated table's primarykey from trigger monitored this table. 2.Transfer Prepare work:Make a information transfer program to transfer repliaction information from source table to destination table.It will run regularlly to read "operation-log":when it find a new row inserted into this log table,it will add the operated table's primarykey and corresponding synckey into "corresponding-relation" table.And send these information and inserted data to destination table via tcp/ip network.The recieve program will get it,insert new data into destination table,and read add the operated table's primarykey and corresponding synckey into "corresponding-relation" table.. 3.implement one-way repliaction:As above,We can use 2 tables("operation-log","corresponding-relation"),2 triggers,2 transfer program ran on 2 machine hold 2 db to do repliaction work easily.. Can u anderstand it?Give me advice after read it PLZ!THX!! |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > How to view Ms sql server transaction log? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|