ratheesh4sql (3/2/2013)
Hi,Thank you very much for your reply....
Using the Ola.Hallengren.com scipts..am not able to take the full backup of my Always on Seconday database.
Can u suggest me to schedule full backup from the Always on seconday db..?
Thank you.
From here, http://ola.hallengren.com/, Ola mentions specifically support for SQL 2012, including noting that mirrors can be readable and used for backups. Please get the latest version of his scripts and see if that will allow you to backup a replica.
I cannot recommend a schedule for you because I have no idea what your company's needs are from an RPT and RTO perspective. I STRONGLY encourage you to engage a professional to review your company's needs and discuss options and help you implement an HA/DR plan that meets those needs and which you can afford.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service