How table look like 3 day ago...

Question

How table look like 3 day ago...

SQlLogic

SSCrazy Eights

Points: 9686
More actions
March 22, 2012 at 10:00 am

#266169

hi folks
I need to know how the particular table in database looks like 3 days ago so is there any way to know or any script?
Thanks for help

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Restore a backup from 3 days ago as a new database and look at the table in there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ant-Green SSC Guru Points: 113507 More actions · Answer 2

only way would be to restore the databases from 3 days ago unless you have some custom monitoring solution or script the database schema every day

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

What do you mean how the table looked like three days ago? Are talking structure or data?

The only way I know is to restore the database under a different name or to a different server. There isn't any way to just query the database to determine this.

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 4

That helps a lot ..

thank you for a kind suggestion...

Is there any way we can find out from T- SQL scripts?

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 5

If you don't backup database :w00t: your only other option will be time-machine... :alien:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 6

Ankit.shah22 (3/22/2012)
That helps a lot ..
thank you for a kind suggestion...
Is there any way we can find out from T- SQL scripts?

Do you have DDL triggers which do this kind of audit?

Probably not.

Try to send email to everyone, asking what kind of T-SQL scripts they did execute in your database...:hehe:

Beer-time in London!

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Ankit.shah22 (3/22/2012)
That helps a lot ..
thank you for a kind suggestion...
Is there any way we can find out from T- SQL scripts?

Simple answer, no. You will need to restore a backup of the database from 3 days ago, either as a new database on the same server or to a separate server.