MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 21st, 2004, 12:43 AM
cleverpig cleverpig is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: Jul 2003
Posts: 1,152 cleverpig User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via MSN to cleverpig
Thumbs up How to view Ms sql server transaction log?

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 !

Reply With Quote
  #2  
Old April 21st, 2004, 12:16 PM
sypher sypher is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Location: Montreal
Posts: 92 sypher User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 10 sec
Reputation Power: 5
you cann't!
and it was made this way...want do you want to do? restore an old transaction?

Reply With Quote
  #3  
Old April 21st, 2004, 07:47 PM
cleverpig cleverpig is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: Jul 2003
Posts: 1,152 cleverpig User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via MSN to cleverpig
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??

Reply With Quote
  #4  
Old April 23rd, 2004, 11:52 AM
cleverpig cleverpig is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: Jul 2003
Posts: 1,152 cleverpig User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via MSN to cleverpig
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!

Reply With Quote
  #5  
Old April 23rd, 2004, 11:54 AM
cleverpig cleverpig is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: Jul 2003
Posts: 1,152 cleverpig User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via MSN to cleverpig
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!!

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > How to view Ms sql server transaction log?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT