June 26, 2011 at 12:32 pm
is it possible to take the backup of the standby database(logshipping secondary database)?
June 26, 2011 at 2:23 pm
no its not in a mode where you can do that, without breaking log shipping. As it is a copy of a database anyway there's no need to back it up.
---------------------------------------------------------------------
June 26, 2011 at 9:47 pm
thanks for reply george...
i have a requirement to create a backup job for the secondary database.
how should i implement this.
June 26, 2011 at 11:47 pm
The backup of the primary database is a backup of the secondary backup. You can get a backup of the Primary database with COPY_ONLY flag so that you don't disrupt any chains of backups.
But you cannot backup a Standby database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply