Can anyone suggest a company for offsite tape storage? Please see if
a contact number can be provided. Many Thanks in Advance
I'd love to get some recommendations. We are located in Delta, BC.
So any company
in Vancouver area will do. I heard of Iron Mountain, however, they
are
near the Fraser River,
Thanks in Advance,
StreetOn Feb 2, 1:46 am, "StreetMania" <evilcookiemons...@.gmail.com> wrote:
> Can anyone suggest a company for offsite tape storage? Please see if
> a contact number can be provided. Many Thanks in Advance
> I'd love to get some recommendations. We are located in Delta, BC.
> So any company
> in Vancouver area will do. I heard of Iron Mountain, however, they
> are
> near the Fraser River,
> Thanks in Advance,
> Street
I can recommend Iron Mountain, we have used them for off-site pickup
for 5 years.
regards Simon
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Monday, March 26, 2012
offsite tape storage company?
Can anyone suggest a company for offsite tape storage? Please see if
a contact number can be provided. Many Thanks in Advance
I'd love to get some recommendations. We are located in Delta, BC.
So any company
in Vancouver area will do. I heard of Iron Mountain, however, they
are
near the Fraser River,
Thanks in Advance,
Street
On Feb 2, 1:46 am, "StreetMania" <evilcookiemons...@.gmail.com> wrote:
> Can anyone suggest a company for offsite tape storage? Please see if
> a contact number can be provided. Many Thanks in Advance
> I'd love to get some recommendations. We are located in Delta, BC.
> So any company
> in Vancouver area will do. I heard of Iron Mountain, however, they
> are
> near the Fraser River,
> Thanks in Advance,
> Street
I can recommend Iron Mountain, we have used them for off-site pickup
for 5 years.
regards Simon
a contact number can be provided. Many Thanks in Advance
I'd love to get some recommendations. We are located in Delta, BC.
So any company
in Vancouver area will do. I heard of Iron Mountain, however, they
are
near the Fraser River,
Thanks in Advance,
Street
On Feb 2, 1:46 am, "StreetMania" <evilcookiemons...@.gmail.com> wrote:
> Can anyone suggest a company for offsite tape storage? Please see if
> a contact number can be provided. Many Thanks in Advance
> I'd love to get some recommendations. We are located in Delta, BC.
> So any company
> in Vancouver area will do. I heard of Iron Mountain, however, they
> are
> near the Fraser River,
> Thanks in Advance,
> Street
I can recommend Iron Mountain, we have used them for off-site pickup
for 5 years.
regards Simon
offsite tape storage company?
Can anyone suggest a company for offsite tape storage? Please see if
a contact number can be provided. Many Thanks in Advance
I'd love to get some recommendations. We are located in Delta, BC.
So any company
in Vancouver area will do. I heard of Iron Mountain, however, they
are
near the Fraser River,
Thanks in Advance,
StreetOn Feb 2, 1:46 am, "StreetMania" <evilcookiemons...@.gmail.com> wrote:
> Can anyone suggest a company for offsite tape storage? Please see if
> a contact number can be provided. Many Thanks in Advance
> I'd love to get some recommendations. We are located in Delta, BC.
> So any company
> in Vancouver area will do. I heard of Iron Mountain, however, they
> are
> near the Fraser River,
> Thanks in Advance,
> Street
I can recommend Iron Mountain, we have used them for off-site pickup
for 5 years.
regards Simon
a contact number can be provided. Many Thanks in Advance
I'd love to get some recommendations. We are located in Delta, BC.
So any company
in Vancouver area will do. I heard of Iron Mountain, however, they
are
near the Fraser River,
Thanks in Advance,
StreetOn Feb 2, 1:46 am, "StreetMania" <evilcookiemons...@.gmail.com> wrote:
> Can anyone suggest a company for offsite tape storage? Please see if
> a contact number can be provided. Many Thanks in Advance
> I'd love to get some recommendations. We are located in Delta, BC.
> So any company
> in Vancouver area will do. I heard of Iron Mountain, however, they
> are
> near the Fraser River,
> Thanks in Advance,
> Street
I can recommend Iron Mountain, we have used them for off-site pickup
for 5 years.
regards Simon
Friday, March 23, 2012
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?
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?
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.
NC3Consider 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:47=A0pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. =A0Once you have done the initial synch, then=
> just failover to the new site and dismantle the old one.
> --
> =A0 =A0Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON =A0 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:46=A0pm, "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...
> --
> =A0 =A0Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON =A0 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:
>
>
> > 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- 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:
>
>
> > 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- 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?sql
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.
NC3Consider 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:47=A0pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> Consider database mirroring. =A0Once you have done the initial synch, then=
> just failover to the new site and dismantle the old one.
> --
> =A0 =A0Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON =A0 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:46=A0pm, "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...
> --
> =A0 =A0Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON =A0 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:
>
>
> > 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- 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:
>
>
> > 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- 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?sql
Off Topic question on Data Protection.
Hello,
I'm a SQL Server dba, recently my parent company took over
another company. This company has asked for a copy of our
client data for statical purposes.
Personally I feel it is against the Data Protection act to
do so. Could someone point my to an English web site so I
can provide my manager with the information ?
Apologies for the off topic.
Jan
Information about what? That your boss has asked you to copy the data? Do
you think he/she has no rights to do that?
"Jan" <anonymous@.discussions.microsoft.com> wrote in message
news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
> Hello,
> I'm a SQL Server dba, recently my parent company took over
> another company. This company has asked for a copy of our
> client data for statical purposes.
> Personally I feel it is against the Data Protection act to
> do so. Could someone point my to an English web site so I
> can provide my manager with the information ?
> Apologies for the off topic.
>
|||The UK Data Protection Act (1998) concerns information about identifiable
individual people. If this describes the data you are referring to then see:
http://www.informationcommissioner.gov.uk
Of course your company may also have other obligations relating to other
types of data as well. In relation to client data for example, rules on the
use of that data may be defined in your terms of business with that client.
David Portas
SQL Server MVP
|||Thanks for your Replay,
The request came from the other company, and I have been
asked to check on the feasibility of sending the other
company info on our clients.
In answer to your question, our Managing Director asked my
manager.
I will read what David has sent over and see what can be
done.
Thanks
>--Original Message--
>Jan
>Information about what? That your boss has asked you to
copy the data? Do
>you think he/she has no rights to do that?
>"Jan" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
over[vbcol=seagreen]
our[vbcol=seagreen]
to[vbcol=seagreen]
I
>
>.
>
|||Thanks David
>--Original Message--
>The UK Data Protection Act (1998) concerns information
about identifiable
>individual people. If this describes the data you are
referring to then see:
>http://www.informationcommissioner.gov.uk
>Of course your company may also have other obligations
relating to other
>types of data as well. In relation to client data for
example, rules on the
>use of that data may be defined in your terms of business
with that client.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>
I'm a SQL Server dba, recently my parent company took over
another company. This company has asked for a copy of our
client data for statical purposes.
Personally I feel it is against the Data Protection act to
do so. Could someone point my to an English web site so I
can provide my manager with the information ?
Apologies for the off topic.
Jan
Information about what? That your boss has asked you to copy the data? Do
you think he/she has no rights to do that?
"Jan" <anonymous@.discussions.microsoft.com> wrote in message
news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
> Hello,
> I'm a SQL Server dba, recently my parent company took over
> another company. This company has asked for a copy of our
> client data for statical purposes.
> Personally I feel it is against the Data Protection act to
> do so. Could someone point my to an English web site so I
> can provide my manager with the information ?
> Apologies for the off topic.
>
|||The UK Data Protection Act (1998) concerns information about identifiable
individual people. If this describes the data you are referring to then see:
http://www.informationcommissioner.gov.uk
Of course your company may also have other obligations relating to other
types of data as well. In relation to client data for example, rules on the
use of that data may be defined in your terms of business with that client.
David Portas
SQL Server MVP
|||Thanks for your Replay,
The request came from the other company, and I have been
asked to check on the feasibility of sending the other
company info on our clients.
In answer to your question, our Managing Director asked my
manager.
I will read what David has sent over and see what can be
done.
Thanks
>--Original Message--
>Jan
>Information about what? That your boss has asked you to
copy the data? Do
>you think he/she has no rights to do that?
>"Jan" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
over[vbcol=seagreen]
our[vbcol=seagreen]
to[vbcol=seagreen]
I
>
>.
>
|||Thanks David
>--Original Message--
>The UK Data Protection Act (1998) concerns information
about identifiable
>individual people. If this describes the data you are
referring to then see:
>http://www.informationcommissioner.gov.uk
>Of course your company may also have other obligations
relating to other
>types of data as well. In relation to client data for
example, rules on the
>use of that data may be defined in your terms of business
with that client.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>
Off Topic question on Data Protection.
Hello,
I'm a SQL Server dba, recently my parent company took over
another company. This company has asked for a copy of our
client data for statical purposes.
Personally I feel it is against the Data Protection act to
do so. Could someone point my to an English web site so I
can provide my manager with the information ?
Apologies for the off topic.Jan
Information about what? That your boss has asked you to copy the data? Do
you think he/she has no rights to do that?
"Jan" <anonymous@.discussions.microsoft.com> wrote in message
news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
> Hello,
> I'm a SQL Server dba, recently my parent company took over
> another company. This company has asked for a copy of our
> client data for statical purposes.
> Personally I feel it is against the Data Protection act to
> do so. Could someone point my to an English web site so I
> can provide my manager with the information ?
> Apologies for the off topic.
>|||The UK Data Protection Act (1998) concerns information about identifiable
individual people. If this describes the data you are referring to then see:
http://www.informationcommissioner.gov.uk
Of course your company may also have other obligations relating to other
types of data as well. In relation to client data for example, rules on the
use of that data may be defined in your terms of business with that client.
David Portas
SQL Server MVP
--|||Thanks for your Replay,
The request came from the other company, and I have been
asked to check on the feasibility of sending the other
company info on our clients.
In answer to your question, our Managing Director asked my
manager.
I will read what David has sent over and see what can be
done.
Thanks
>--Original Message--
>Jan
>Information about what? That your boss has asked you to
copy the data? Do
>you think he/she has no rights to do that?
>"Jan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
over[vbcol=seagreen]
our[vbcol=seagreen]
to[vbcol=seagreen]
I[vbcol=seagreen]
>
>.
>|||Thanks David
>--Original Message--
>The UK Data Protection Act (1998) concerns information
about identifiable
>individual people. If this describes the data you are
referring to then see:
>http://www.informationcommissioner.gov.uk
>Of course your company may also have other obligations
relating to other
>types of data as well. In relation to client data for
example, rules on the
>use of that data may be defined in your terms of business
with that client.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>
I'm a SQL Server dba, recently my parent company took over
another company. This company has asked for a copy of our
client data for statical purposes.
Personally I feel it is against the Data Protection act to
do so. Could someone point my to an English web site so I
can provide my manager with the information ?
Apologies for the off topic.Jan
Information about what? That your boss has asked you to copy the data? Do
you think he/she has no rights to do that?
"Jan" <anonymous@.discussions.microsoft.com> wrote in message
news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
> Hello,
> I'm a SQL Server dba, recently my parent company took over
> another company. This company has asked for a copy of our
> client data for statical purposes.
> Personally I feel it is against the Data Protection act to
> do so. Could someone point my to an English web site so I
> can provide my manager with the information ?
> Apologies for the off topic.
>|||The UK Data Protection Act (1998) concerns information about identifiable
individual people. If this describes the data you are referring to then see:
http://www.informationcommissioner.gov.uk
Of course your company may also have other obligations relating to other
types of data as well. In relation to client data for example, rules on the
use of that data may be defined in your terms of business with that client.
David Portas
SQL Server MVP
--|||Thanks for your Replay,
The request came from the other company, and I have been
asked to check on the feasibility of sending the other
company info on our clients.
In answer to your question, our Managing Director asked my
manager.
I will read what David has sent over and see what can be
done.
Thanks
>--Original Message--
>Jan
>Information about what? That your boss has asked you to
copy the data? Do
>you think he/she has no rights to do that?
>"Jan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
over[vbcol=seagreen]
our[vbcol=seagreen]
to[vbcol=seagreen]
I[vbcol=seagreen]
>
>.
>|||Thanks David
>--Original Message--
>The UK Data Protection Act (1998) concerns information
about identifiable
>individual people. If this describes the data you are
referring to then see:
>http://www.informationcommissioner.gov.uk
>Of course your company may also have other obligations
relating to other
>types of data as well. In relation to client data for
example, rules on the
>use of that data may be defined in your terms of business
with that client.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>
Off Topic question on Data Protection.
Hello,
I'm a SQL Server dba, recently my parent company took over
another company. This company has asked for a copy of our
client data for statical purposes.
Personally I feel it is against the Data Protection act to
do so. Could someone point my to an English web site so I
can provide my manager with the information ?
Apologies for the off topic.Jan
Information about what? That your boss has asked you to copy the data? Do
you think he/she has no rights to do that?
"Jan" <anonymous@.discussions.microsoft.com> wrote in message
news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
> Hello,
> I'm a SQL Server dba, recently my parent company took over
> another company. This company has asked for a copy of our
> client data for statical purposes.
> Personally I feel it is against the Data Protection act to
> do so. Could someone point my to an English web site so I
> can provide my manager with the information ?
> Apologies for the off topic.
>|||The UK Data Protection Act (1998) concerns information about identifiable
individual people. If this describes the data you are referring to then see:
http://www.informationcommissioner.gov.uk
Of course your company may also have other obligations relating to other
types of data as well. In relation to client data for example, rules on the
use of that data may be defined in your terms of business with that client.
--
David Portas
SQL Server MVP
--|||Thanks for your Replay,
The request came from the other company, and I have been
asked to check on the feasibility of sending the other
company info on our clients.
In answer to your question, our Managing Director asked my
manager.
I will read what David has sent over and see what can be
done.
Thanks
>--Original Message--
>Jan
>Information about what? That your boss has asked you to
copy the data? Do
>you think he/she has no rights to do that?
>"Jan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
>> Hello,
>> I'm a SQL Server dba, recently my parent company took
over
>> another company. This company has asked for a copy of
our
>> client data for statical purposes.
>> Personally I feel it is against the Data Protection act
to
>> do so. Could someone point my to an English web site so
I
>> can provide my manager with the information ?
>> Apologies for the off topic.
>
>.
>|||Thanks David
>--Original Message--
>The UK Data Protection Act (1998) concerns information
about identifiable
>individual people. If this describes the data you are
referring to then see:
>http://www.informationcommissioner.gov.uk
>Of course your company may also have other obligations
relating to other
>types of data as well. In relation to client data for
example, rules on the
>use of that data may be defined in your terms of business
with that client.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>sql
I'm a SQL Server dba, recently my parent company took over
another company. This company has asked for a copy of our
client data for statical purposes.
Personally I feel it is against the Data Protection act to
do so. Could someone point my to an English web site so I
can provide my manager with the information ?
Apologies for the off topic.Jan
Information about what? That your boss has asked you to copy the data? Do
you think he/she has no rights to do that?
"Jan" <anonymous@.discussions.microsoft.com> wrote in message
news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
> Hello,
> I'm a SQL Server dba, recently my parent company took over
> another company. This company has asked for a copy of our
> client data for statical purposes.
> Personally I feel it is against the Data Protection act to
> do so. Could someone point my to an English web site so I
> can provide my manager with the information ?
> Apologies for the off topic.
>|||The UK Data Protection Act (1998) concerns information about identifiable
individual people. If this describes the data you are referring to then see:
http://www.informationcommissioner.gov.uk
Of course your company may also have other obligations relating to other
types of data as well. In relation to client data for example, rules on the
use of that data may be defined in your terms of business with that client.
--
David Portas
SQL Server MVP
--|||Thanks for your Replay,
The request came from the other company, and I have been
asked to check on the feasibility of sending the other
company info on our clients.
In answer to your question, our Managing Director asked my
manager.
I will read what David has sent over and see what can be
done.
Thanks
>--Original Message--
>Jan
>Information about what? That your boss has asked you to
copy the data? Do
>you think he/she has no rights to do that?
>"Jan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:8ec701c47882$9044dc10$a301280a@.phx.gbl...
>> Hello,
>> I'm a SQL Server dba, recently my parent company took
over
>> another company. This company has asked for a copy of
our
>> client data for statical purposes.
>> Personally I feel it is against the Data Protection act
to
>> do so. Could someone point my to an English web site so
I
>> can provide my manager with the information ?
>> Apologies for the off topic.
>
>.
>|||Thanks David
>--Original Message--
>The UK Data Protection Act (1998) concerns information
about identifiable
>individual people. If this describes the data you are
referring to then see:
>http://www.informationcommissioner.gov.uk
>Of course your company may also have other obligations
relating to other
>types of data as well. In relation to client data for
example, rules on the
>use of that data may be defined in your terms of business
with that client.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>sql
Wednesday, March 21, 2012
Odd SqlException
I'm using .NET 2.0
I designed my BLL to work as follows:
'Update existing company <System.ComponentModel.DataObjectMethodAttribute _ (System.ComponentModel.DataObjectMethodType.Update,True)> _Public Function UpdateCompany(ByVal Original_CompanyIDAs Int64, ...)As Boolean'Get current recordDim CompaniesAs biodata.CompaniesDataTable = CompaniesAdapter.GetCompanyByID(Original_CompanyID)'If no record exists, Update failsIf Companies.Count = 0Then Throw New ApplicationException("Company does not exist.")End If Dim CompanyAs biodata.CompaniesRow = Companies(0)'Set all the values to load into the database Company.CompanyName = CompanyName ...Dim RowsAffectedAs Integer = CompaniesAdapter.Update(Company)Return (RowsAffected = 1)End FunctionRecently I deleted a column in my SQL database. In order to account for this change, I deleted the same column in my DAL. Then, because of the obvious compile errors that would occur if I didn't, I deleted all references to that column in my BLL. My DAL automatically creates the Update and Insert statements. Now, the error I'm getting is as follows:
Exception Details:System.Data.SqlClient.SqlException: Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.
The statement has been terminated.
Source Error:
Line 18409: System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _Line 18410: Public Overloads Overridable Function Update(ByVal dataRow As System.Data.DataRow) As IntegerLine 18411: Return Me.Adapter.Update(New System.Data.DataRow() {dataRow})Line 18412: End FunctionLine 18413:Stack Trace:
[SqlException (0x80131904): Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.The statement has been terminated.] System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +200 System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +104 System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +3042 System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows) +345 biodataTableAdapters.CompaniesTableAdapter.Update(DataRow dataRow) in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\67b7db20\aea00f88\App_Code.nf1apfb7.1.vb:18411 CompaniesBLL.UpdateCompany(Int64 Original_CompanyID, String CompanyName, String Division, String Website, Nullable`1 CompanyInactive, String CompanyInactiveReason, Nullable`1 EmployeeCount, Nullable`1 YearFounded, Nullable`1 YearStartedBiobased, Nullable`1 NAICS, String Address1, String Address2, String City, String StateCode, String Territory, String CountryCode, String Zip, String CompanyNotes, String Prefix, String FName, String LName, String Suffix, String Title, String Email, String Phone1, String PhoneType1, String Phone2, String PhoneType2, String Phone3, String PhoneType3, String UpdateType, String UpdatedBy, Int64 SecurityLevel, Int64[] Flags) in F:\App_Code\BLL\CompaniesBLL.vb:376
Now, this exception makes no sense to me because the DAL should automatically fix the update and insert statements itself, and I never directly access those statements. The error is occuring at CompaniesAdapter.Update(Company) in my code above. Any ideas?
Thanks,
BSY E-718
Turn on SQL Profiler... and watch the actual query that is being executed... that might point you in the right direction.
Subscribe to:
Posts (Atom)