Yes John,

I went through the link.. that will help me in future processings..

But i need to know for 15 days back info... 🙁

One question -

The Link you gave me.....

Hanshi, i did not understand you wrote 🙁

When i executed above SP, i got many records from which their were only 10 records for that date (9th August2013)

The records were only Backup one.. stating info about Log...

In error logs, i saw a file name ending with

current - 6/23/2013 10:00:00 AM

& i am asked to provide deadlock victim info of 9th Aug 2013...

More over i got...

Someone told me to check in error log..

but how i would read & query in error log to find deadlock victim which had happened 15 days back...

sp_configure is used to configure the user options to change the setting for the ANSI_WARNINGS server option.

You have selected option 2 ..

2 - IMPLICIT_TRANSACTIONS

For dblib network library connections, controls whether...

Thanks Taylor for prompt reply..

Will go through all Docs soon & in case i come across anything.. will revert back..

Thanks a TON Man 🙂

Sapen Could you help me with some Scripts or Tasks procedure which you do step by step for below points??? I am new to this Tasks & will help me...

Thanks Hanshi, it worked... :-):-)

Thanks Gail & others members to suggest me...:-)

Hanshi I executed your query on Sample Database.. below is the output

database_name ...

I did try to restore .trn file..

error is

The Log in this backup terminates at LSN 200002222.. etc

whcih is too early to apply to the database :w00t::w00t:

i took two log backup..

one...

BELOW STEPS FOLLOWED FOR TESTING PURPOSE.. BUT GETTING ERROR..

1) Created New Db & add 1 table with 6 records

2) took full backup

3) inserted 2 more records

4) took Log backup

5)...

Thanks Hanshi, Ness & GAIL...

below will be tyhe step which will be done incase of deletion..

1) Restore Last Full Backup (Normal Backup)

2) Restore all Log Backup Copies after Full backup...

Gail, now they have come up with new need..

They dont want to know who has deleted the records.. they just want to recover the data which gets deleted if incase..

Like...

Hanshi what you suggest for the below scenario??

If Database size is around 20 GB

and Backup taken once a day and Log backup every 3 hours then what can be set??