Thank you, for your overwhelming response.

Cheers!

Are you keeping 2nd server idle? i.e. no read/wirte on the 2nd server and need High Availability than you can think of Database Mirroring. Also DB mirroring give you flexibility...

Yes it is OK if you do not have pager. You can configure only e-mail. Refer following link for detail troubleshooting.

http://technet.microsoft.com/en-us/library/ms188663(v=sql.105).aspx

HTH

No easy way! But yes, you can do it programatically by pulling data from system tables. Create stored procedure to send mail and add stored procedure to the additional step...

Nice one.

Thank you, Steve for small correction.

Appreciate everyone for comments and sharing experience which helps to enhance knowledge and understanding of new technology.

Regards,

FM

Good One!

Hello Koen,

Thank you for sharing additional information.

Best regards,

FM

check and verify that sql server agent services are up and running. Also check if any error is recorded in log.

HTH

Good One!

Hi Mohamed,

If what you said is correct than we are able to detach the database by changing the compatibility and attached to the lower version. But this is not possible.

Refer...

Do you mean bi-directional?

Refer following link:

http://social.technet.microsoft.com/Forums/sqlserver/en-US/dd610c7e-8d13-4679-b061-56503a4a2fd1/sql-server-2012-an-d-bidirectional-transactional-replication

HTH

Usually DBCC CHECKDB should be executed during off-peak hours. What is type of server? i.e. prod, dev, test? what is the size of database? Command blocking spid is same as...

Depends on the various business requirement replication can be set up between Publisher and subscriber. It can also support heterogeneous environment.

Refer following BOL topic for further detail and understanding. It...

Can you please share diagram of physical architecture so that it will be clear what you exactly looking for?