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

SQL Server mirroring to SQL Express

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?
1 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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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