August 22, 2010 at 3:12 pm
Hi,
We have SQL Server 2005x64 with SP3 and using log shipping for Disaster recovery.
The databases on secondary are in recovey state. We are looking options to backup the secondary databases.
Is this possible in SQL Server 2005? If NOT is this feature is going to implement any next SQL Server version? Are they any 3rd party tools do this job?
We have this option in Oracle.
Thanks
August 22, 2010 at 9:14 pm
Not sure why you would backup a log shipped database. Insetad you can backup the Primary database in log shipping. If the secondary database is in standby mode, then you may use Database Snapshots or BACKUP with COPY_ONLY backups
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 23, 2010 at 1:04 am
I would agree. Log shipping is already essentially a means of backing up the database--if you're doing that *and* taking full backups of the primary you should be in good shape for disaster recovery. What benefit would also backing up the secondary database give you?
August 23, 2010 at 1:08 am
Anyhow, if you have a bakcup of Secondary Database with copy_only option, the Backup will not be much of use, as the data on secondary db is a copy of the primary only and it is changing on continuous basis.
August 23, 2010 at 3:11 am
No that's not possible. If you need a backup then take it in Primary server.
Regards..Vidhya Sagar
SQL-Articles
August 23, 2010 at 6:31 am
You cant backup the secondary database. It is in RESTORE mode and cant be backed up or accessed!
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply