Friday, February 10, 2012

Backing up to mirror

I am looking at this syntax from Books-Online:
BACKUP DATABASE AdventureWorks
TO TAPE = '\\.\tape0'
MIRROR TO TAPE = '\\.\tape1'
MIRROR TO TAPE = '\\.\tape2'
MIRROR TO TAPE = '\\.\tape3'
WITH
FORMAT,
MEDIANAME = 'AdventureWorksSet0'
1. Am I right in thinking that this has nothing to do with database
mirroring? I've never done that either, but I've read that the mirror is
updated through transactions transferred from the database to the mirror, and
also that there can be only one mirror.
2. Can the MIRROR option be set up from the backup dialog screen, or only
through code like the above?> 1. Am I right in thinking that this has nothing to do with database
> mirroring?
Correct. The word mirror is overloaded and user in several independent contexts (just like
"snapshot", "schema" and "meta-data").
> 2. Can the MIRROR option be set up from the backup dialog screen, or only
> through code like the above?
I haven't found a way to do this through the GUI, so TSQL is the way to go.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:EFCC37AA-8F13-49D8-BB54-5C47E2DFA21F@.microsoft.com...
>I am looking at this syntax from Books-Online:
> BACKUP DATABASE AdventureWorks
> TO TAPE = '\\.\tape0'
> MIRROR TO TAPE = '\\.\tape1'
> MIRROR TO TAPE = '\\.\tape2'
> MIRROR TO TAPE = '\\.\tape3'
> WITH
> FORMAT,
> MEDIANAME = 'AdventureWorksSet0'
> 1. Am I right in thinking that this has nothing to do with database
> mirroring? I've never done that either, but I've read that the mirror is
> updated through transactions transferred from the database to the mirror, and
> also that there can be only one mirror.
> 2. Can the MIRROR option be set up from the backup dialog screen, or only
> through code like the above?

No comments:

Post a Comment