Thanks Mark, appreciate it.

What exactly means by Auto Close when its set to true/false?

Thanks SoHelpMeCodd.

The auto close is set to true....I think this is the main reason.

Also, there is a backup happening every hour, so this probably forcing it to restart the db.

Hi Jeff,

I did not test the script yet, but i kind of got an idea...i need to enter the server name, db name and the path details.

In regards to the...

Thanks John for providing the script.

Yes, its the same database.

Okay Thanks Jeff, appreciates it.

Hi Jeff,

If you don't mind, can you please elaborate on it, or provide steps...

I am not that good with .bat files or scripts.

If both logins/users exist on both PRD/DR, then you just need to do the orphan user fix.

I am sorry, I misread the question.

I thought log backup 1 and 2 were taken after full backup 1.....plz disregard my question.

"So, the restore for this would be: Take log backup 6 (with NO_TRUNCATE), restore full 1, restore log backups 3,4,5, 6."

I have a question about Eddie's answer...

What about log backups...

You can try the SQL error log and see.

What exactly the query is doing? I am assuming, this is some type of select query since the database is in read-only mode.

Anyway, plz provide more details.

What Hanshi is saying is, the db properties include logfile space as well, so that's why it shows more than your query results.

Is the mirroring currently configured or suspended? Can you check the mirroring monitor and see how much log need to be transferred?

I can't think of any other reason...