Thanks For your Quick Response.

Also observed the snapshot creation\recovery goes up significantly if indexes and tables created on source database.

Is it good idea to leave snapshot on secondary site open...

I found this interesting which can help you build it in days time

https://www.simple-talk.com/sql/database-administration/gathering-perfmon-data-with-powershell/

Cheers

Sat

Is the webserver able to connect to two instances using telnet test ?

Also check using ODBC test if you can communicate from webserver to primary & secondary server's.

If the above...

Hi ,

Please check the link below ... hope this helps

http://connect.microsoft.com/SQLServer/feedback/details/241265/attempted-to-unlock-a-resource-it-does-not-own

Most envrionments have DR solution coupled with HA solution in place for BCP events... GOD forbidding never occurs!

In your configuration if it is not GEO cluster then would suggest...

Best thing is build standy by server on same domain, migrate the databases and check for consistency after migration, usually you should have DR solution for critical production databases for...

Must be some old subscriptions as which are generating this , follow discussion in link below it would guide you.

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/fc6db830-b88d-4248-b887-21fd18d7aea1

Better to have instance allocated which is dedicated as LOG shipping monitor, instead of using existing one.

Easier for long run maintainence and over haul down the years.

Wish you had chosed mirroring for HA instead of merge replication , is there particular constraint for going the merge replication way 🙂

Quick one would be use BCP to export...

Looking at the code and one article about using XML in FILESTREAM , may be you are not explicitly coverting XML data to read or write to them using CAST...

Thanks for this article , all this while in my DBA career was wondering why REPAIR_REBUILD did not work most times on cluster index chain broken.

But observed in one of...

Does the system table below show entry of some old mirroring set up which was removed later

select * from sys.database_mirroring

If this is has some entries of mirrored database please...

Hi ,

You can possibly looks at areas in SQL database

1. If lot reads or updates based on SELECT CONDITION check if the indexe statistics are up to date, if ...

On 823 we lost around 12% using data loss option, we could not go for backup since the they were configured directly to tapes which would have taken more time...

Good One 🙂