|
Home > Archive > MS SQL Server > March 2006 > database snapshot off of a restoring db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
database snapshot off of a restoring db
|
|
| Hassan 2006-03-05, 8:23 pm |
| Say I establish log shipping between source A and dest B.
and Dest B is continuously restoring logs, can i perform a snapshot on Dest
B
I know if i do mirroring between the 2 servers than i can snapshot off of
the mirror but wanted to know how it works with log shipping destination
Thanks
| |
| Ben Nevarez 2006-03-05, 8:23 pm |
|
I have not tested myself but saw this on BOL
Limitations on Database Snapshots
"The source database must be online, unless the database is a mirror
database within a database mirroring session"
Ben Nevarez, MCDBA, OCP
Database Administrator
"Hassan" wrote:
> Say I establish log shipping between source A and dest B.
>
> and Dest B is continuously restoring logs, can i perform a snapshot on Dest
> B
>
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
>
> Thanks
>
>
>
| |
| Michael Hotek 2006-03-15, 1:23 pm |
| No. This is not allowed
--
Mike
http://www. solidqualitylearning
.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hassan" <Hassan@hotmail.com> wrote in message
news:eBwaNwiPGHA.2628@TK2MSFTNGP15.phx.gbl...
> Say I establish log shipping between source A and dest B.
>
> and Dest B is continuously restoring logs, can i perform a snapshot on
> Dest B
>
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
>
> Thanks
>
|
|
|
|
|