How to backup in standby mode for database
Backup database AdventureWorks2012 to disk = 'C:\Backups\AdventureWorks2012_full_062720151415.bak' How to run this backup in standby mode?
Best Answer
You can't backup a database that's in standby. The primary database is where you'll be doing all the backups. The standby server is receiving either log shipping or mirroring. It's being actively restored to so it can't be backed up.
