Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2260
  • Last Modified:

SQL mirror process error 1469

after executing the mirror I'm getting the following error can anyone help?

Database mirroring cannot be enabled because the "SUP_Demo1" database is an auto-close database on one of the partners. (Microsoft SQL Server, Error: 1469)
1 Solution
Auto-Close is a database option that allow SQL Engine to close a database when there are no active connections and opens/loads when a user requests access..

It is checkbox in the Database properties (right-click database in SMO) Options tab and can be turned off..  

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now