This is a tool which is accessible only for internal testing from Microsoft and its Not available for public.

I will try Hammer DB. Thank you All.

Thank you 🙂

You may also try to improve the restore time by testing MAXTRANSFERSIZE and BUFFERCOUNT values.

Thank you Grant and MysteryJimbo for your thoughts. I am convinced and will go with backup and restore 🙂

Hi ,

I don't think anyone would be able to answer right away, as there is very less information you have provided with an open wided question.

Are you the inhouse DBA?

If...

You can test by mentioning SET STATISTICS ON/OFF while executing the SP.

Good read to clarify your doubt

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

Look at the SQL errorlog and are there any login failures?

Great ..

Hi You can try to execute

ALTER DATABASE <database_name> SET HADR RESUME

Should be able to resume the synchronization.

But please go through http://msdn.microsoft.com/en-us/library/ff877956.aspx for more information.

Can you post the result by executing sp_helppublication on publication database.

Run sp_helppublication on publisher database and check values of immediate_sync and allow_anonymous. These should be set to false so that snapshot will be generated for selected articles.

EXEC sp_changepublication

@publication =...

Haven't come across auto notification

Can make use of this DMV to sys.dm_hadr_availability_group_states , we can look at values for primary_recovery_health and primary_recovery_health_desc which will have the node name. ...