SQL mirror process error 1469

Posted on 2009-02-13
Last Modified: 2012-05-06
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)
Question by:atorex
    1 Comment
    LVL 25

    Accepted 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..  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now