May 25, 2006 at 6:46 am
I am trying to backup read-only databases and it is giving me errors that the database is in warm-standy mode and to use restore with stand-by option.
Any ideas?
TIA
May 25, 2006 at 8:03 am
If the database is in readonly mode then the state of the database isn't changing so there's no point in backing it up.
Bring it out of readonly mode and back it up then. If the database was recovered last in warm-standby mode then you must first recover the database entirely before you can back it up.
restore mydatabase with recovery
Hope that helps,
May 25, 2006 at 8:15 am
This is a db to which transaction logs from production are shipped.
I need to move it Test and so the backup. I just got the backups from Production.
Is this behaviour true for db's in read-only to which logs are being shipped.
Thanks.
May 25, 2006 at 8:21 am
Ah, I see. Yes, this is expected behaviour for log shipped secondary databases.
There's no need to backup this database though since it is itself a backup of a primary database (in a manner of speaking). backup the primary database instead (or use the most recent backup along with the corresponding log backups.
Oh, and ignore my recommendation to recover the database in my previous post. You don't want to be doing that to a log shipped secondary db unless you plan to make it the primary db or you're done with log shipping.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply