Thanks all for your inputs!!!!

Gail,i want to retain the yesterdays data and wants to restore the data what changes happened today.

its just like insert into [QA].[DBNAME].[OBJ.NAME] select * from...

Is there any way to retain yesterdays data in QA Server,in addition i don't want to loose yesterdays data.

If i take, new full backup and restored with replace option i can lost yesterdays' data in QA Instance..

am i right..?

exactly, after restoring second backup in QA Instance am not able to see yesterday's Records am able to see only today inserted and updated records.

Hi,

From the database end i ran a SP for that link which is executing in 5-6 seconds.

The problem is coming from front-end especially for one option and the other links...

Thanks for clarification...

i'll go through your links posted in previous comments.

if the database is not freeing log space.

someone running backup of that database (third party tool).

if backup is not running, and log_reuse_waits is full . Transactions will not reflected into...

please elaborate...

Your database might be in full recovery model,

Try to change your database into simple recovery model with the below query:

Alter database [Your database Name] set recovery simple

and now try to...

in mirroring more than one mirror is not possible, if required u can have one witness server.

Whereas, u can create more than one stand by server in log-shipping.

In DB2 you are not decrypting with correct password.

No, Not possible..

DR Server should be same version and same edition.

Heap in the sense there is no index created on that table.u can't do rubuild or reorganize heaps in SQL server.

Creating master key and creating certificate will encrypt ur data.

if i execute the procedure manually it is dequeuing, but it is not dequeuing automatically from that procedure..