transaction logs - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

transaction logs

Author

Topic

pmccann1
Posting Yak Master

107 Posts

Posted - 2008-04-09 : 16:30:04

i was wondering if smeone could give me a breif over view how far back do these go

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 16:48:26

What do you mean? Be clear while posting so we can help. It will go infinity.

pmccann1
Posting Yak Master

107 Posts

Posted - 2008-04-09 : 16:54:31

would i be able to see i row change from two months ago

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-09 : 16:56:40

It goes back to the first transaction log backup taken.

But you can't restore that far back unless you have the transaction log chain and a full backup. People typically don't save all of the tlog backups but rather a certain amount of days/months/years.

What are you really asking though?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 16:59:46

Please read Books Online(BOL) for backups and log. You will get clear information.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-09 : 17:00:08

quote:
Originally posted by pmccann1

would i be able to see i row change from two months ago

Do you have a full backup from before that and also all of the transaction log backups since that full backup and through the row change?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-09 : 17:01:15

quote:
Originally posted by sodeep

Please read Books Online(BOL) for backups and log. You will get clear information.

I disagree that BOL provides clear information for a newbie (question posted in the newbie forum) about this topic.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

pmccann1
Posting Yak Master

107 Posts

Posted - 2008-04-09 : 17:03:19

i basicaly want to know what changes where made to a table on a certain date. bol i dont think is any help

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 17:05:48

Does table have Datetime column ?

pmccann1
Posting Yak Master

107 Posts

Posted - 2008-04-09 : 17:07:55

no. its has no date time field