ravisamigo (3/19/2012)
Hi,We've SQLServer 2005 logshipping configured on one of production database and the size of this db is around 1 TB. It will take more time to take the backup of the primary database every time.
Not possible to take the backup of secondary database because it is in Restoring phase.
So, please advice how we can take full backup from secondary database or is there any alternative
solution for this.
Thanks and Regards,
Ravi.
logically i dont think you need to have backup of secondary side as primary's database backup will work better and more trust worthy with respect to the data availability.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)