Similar thing happened with our servers, I can clearly see that the backups are copied and then restored fine at the DR end with no alerts / issues.

All was well...

Check if the t-logs are performed successfully.

--The query below will pull all trace data using the log auto growth event

SELECT

loginname, ...

I believe its C:/IISlogs/HTTPERR/HTTPERR/*.log

Check the log files in the above folder (probably, or the ones under IISlogs) in the web server and see if you can find any information on...

Run the Checkdb command as

DBCC CHECKDB

WITH NO_INFOMSGS, ALL_ERRORMSGS.

So that it displays only the error messages.

Try restoring the DB to other location and see if the same issue persists with the...

Hi Steve,

I should say WOW after reading the document!!!

This is what I was thinking of, but was not sure whether it works or not.

I will surely try this option...

Thanks for the suggestions.

I was even thinking of log shipping / replication.

Regards,

Pavan.

I wrote publisher for making it a bit clear.

My situation currently is our app has 2 web servers and 2 db servers, the db servers are mirrored. (db1,db2)

Now, we will...

This looks tricky.

Just to be on safe side check the data file sizes of msdb and tempdb databases and make adjustments if necessary!

Pavan.

In this case you can go for

Log shipping

Transactional replication

database mirroring

explore these before you take a step!

Pavan.

Can you connect to the server in canada from your server.

if yes, then you have many different methods to sync up your databases in 2 locations.

for eg:

Snapshot Replication (schedule once...

If they are web based applications, then you have to plan for your DNS changes as they take 24-72 hrs for IP propogation (depends on TTL of course).

Few more...

The trace and the data are available till the early days of this month and the table was deleted on 13th as the restored copy of 12th has the table...

It looks like someone accidentally deleted thru executing a procedure or sort of (something like forgetting to comment that line) and no one remembers it now.

Pavan.

Thanks

Hmm, I can find the object which was re-created but not when it was deleted!!

Pavan.

Thats Fine.

My scenario is we have a found a temp table being dropped on one of the databases.(the table is recreated and all fine)

I am trying to track who did...