SQL Server mirroring to SQL Express

Posted on 2009-02-09
Last Modified: 2012-05-06
I am running SQL Server 2005 std x64. Is it possible to mirror to a SQL Express 2005 instance?

Alternatively, what would be th best way to backup my data if I cannot mirror to SQL Express.

Am I able to do a complete database backup to a networked drive? or does it have to be local?
Question by:Woz_Mann
    1 Comment
    LVL 42

    Accepted Solution

    I do not believe SQL Express can be configured as a mirror.   SQL Server has a robust, built in backup command and supports management plans for scheduling backup scenarios.  If using the Full logging model, don't forget to backup the logs, as well.   Backing up to a network drive is fine.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now