Office Move

My company located in Delware,is moving to a new office and I need to
keep our production database online by moving it onto servers in our
Las Vegas office. I'm looking for suggested ways to move the
databases
as seamlessly as possible to our Vegas office.
We conduct business Monday through Saturday. The way I understand the
move, after close of business on Saturday we want the data center to
be moved to Vegas and available on Monday morning, which doesn't
provide much time to get the db up and running.
We currently have our production database on an active/passive
cluster
running SQL 2005 with transactional replication in place to support
reporting for our enterprise application.
What options are available besides copying a backup across my WAN and
restoring the database?
What limitations are imposed by Log Shipping given the physical
distance betwen locations, etc.
If anyone can help point me in the proper direction I would greatly
appreciate the help.
NC3
Consider database mirroring. Once you have done the initial synch, then
just failover to the new site and dismantle the old one.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
My company located in Delware,is moving to a new office and I need to
keep our production database online by moving it onto servers in our
Las Vegas office. I'm looking for suggested ways to move the
databases
as seamlessly as possible to our Vegas office.
We conduct business Monday through Saturday. The way I understand the
move, after close of business on Saturday we want the data center to
be moved to Vegas and available on Monday morning, which doesn't
provide much time to get the db up and running.
We currently have our production database on an active/passive
cluster
running SQL 2005 with transactional replication in place to support
reporting for our enterprise application.
What options are available besides copying a backup across my WAN and
restoring the database?
What limitations are imposed by Log Shipping given the physical
distance betwen locations, etc.
If anyone can help point me in the proper direction I would greatly
appreciate the help.
NC3
|||Hi
You don't say if the hardware is moving or not or if when it moves any
configuration changes will be made? If the kit is moving do you have
alternate kit as a backup in case of problems?
If you are moving to new/alternate kit then you can test the procedures
before hand so you will know if they are feasable or take too long. You
should also look at how you can minimise the actual work needed when you do
make the move, such as having everything in place and tested on a copy of the
database so there is only a more up-to-date version of the database to slot
in.
John
"NC3" wrote:

> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
>
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
>
> What options are available besides copying a backup across my WAN and
> restoring the database?
>
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
>
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
>
> NC3
>
|||On Feb 20, 3:47Xpm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. XOnce you have done the initial synch, then
> just failover to the new site and dismantle the old one.
> --
> X XTom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON X Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
> What options are available besides copying a backup across my WAN and
> restoring the database?
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
> NC3
How would Mirroring effect transactional replication and can I mirror
a SQL Cluster
|||Not sure about replication but you can mirror between clusters:
http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx?loc=en
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. Once you have done the initial synch, then
> just failover to the new site and dismantle the old one.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:cc76a479-5b61-41ba-8f5c-95e98883d924@.z17g2000hsg.googlegroups.com...
> My company located in Delware,is moving to a new office and I need to
> keep our production database online by moving it onto servers in our
> Las Vegas office. I'm looking for suggested ways to move the
> databases
> as seamlessly as possible to our Vegas office.
> We conduct business Monday through Saturday. The way I understand the
> move, after close of business on Saturday we want the data center to
> be moved to Vegas and available on Monday morning, which doesn't
> provide much time to get the db up and running.
> We currently have our production database on an active/passive
> cluster
> running SQL 2005 with transactional replication in place to support
> reporting for our enterprise application.
> What options are available besides copying a backup across my WAN and
> restoring the database?
> What limitations are imposed by Log Shipping given the physical
> distance betwen locations, etc.
> If anyone can help point me in the proper direction I would greatly
> appreciate the help.
> NC3
How would Mirroring effect transactional replication and can I mirror
a SQL Cluster
|||On Feb 21, 3:46Xpm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Not sure about replication but you can mirror between clusters:
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlcluster...
> --
> X XTom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON X Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
> On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
>
>
>
>
>
>
>
>
> How would Mirroring effect transactional replication and can I mirror
> a SQL Cluster- Hide quoted text -
> - Show quoted text -
What do you thing of having 2 subscribers for the same publisher. Do
think that's something that might work?
|||Not sure what you mean. You can have as many subscribers to a publication
that you want.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:991ea951-2d8c-44bd-93e2-10871e6d4bce@.i7g2000prf.googlegroups.com...
On Feb 21, 3:46 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Not sure about replication but you can mirror between clusters:
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlcluster...
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
> "NC3" <ncolem...@.yahoo.com> wrote in message
> news:833e7401-6825-4586-ae4a-b0a25de9b52f@.p25g2000hsf.googlegroups.com...
> On Feb 20, 3:47 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
>
>
>
>
>
>
>
>
> How would Mirroring effect transactional replication and can I mirror
> a SQL Cluster- Hide quoted text -
> - Show quoted text -
What do you thing of having 2 subscribers for the same publisher. Do
think that's something that might work?