Thank you Gail. Appreciated you.

This site is Awesome !!!!!!!.

Thank you very much Ignacio A. Salom Rangel.

Thank you very much Gail and Dev.

Thanks Dev.

One quick question. What approach will you take when it happens to your DB. Do you stop the DBCC checkdb and follow a different approach.

My db files...

Hi Ignacio A. Salom Rangel,

Very curious to knew about this, is it possible to take database backup from sqlserver 2000 and restore on sql 2008.

-- Babu

In mirroring Transaction log backup will not be applied on the secondary server. However the uncommitted/commited transaction will be automatically applied to the secondary database server log. To manage the...

I think I have encountered this issue in sqlserver 2008 (Not R2).

My scenario is when I created a job in using t-sql scripts ( taken from a different server)...

Looking at the attachment your database adventureworks on the secondary server is not under no recovery mode. Let us know how did you get the adventurework database on the secondary...

My Bad. Yes the transaction log backup is happening. Thanks Bru.

Sorry about that.

The errors are pretty clear. The restored database is not in recoverymode/standby mode.

Can you confirm the following

1) Your primary db (Source db) is in the full recovery mode....

If the online = off with index rebuild option on a huge table will certainly block the full backup. The table will be available if you use the online...

Good Question Steve.

Schedule a sqljob to run between a particular time to shrink the file. And an other sql job to stop the running shrink job once the time crossed. This way...

If you are having identity columns, why are inserting the values through application.

Please use column names in the insert statement and exclue the identity column.

Please check the size of the restored database using the following command.

RESTORE HEADERONLY FROM DISK = 'DB backup file path'

GO