question

GOT avatar image
GOT asked

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?
backupstandby
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.