mirror

I would like to set up a new SQL server on a completely different box in a
different location in the company (perhaps even offsite). I want this new
server to be a mirror of the original SQL server, such that when data in the
original server is updated the data in the new one is also updated etc...
I would like to do this for security reasons, such that if the original
server goes up in flames, I can recover all the data and quickly switch to
the new server.
I have only ever had to deal with one SQL server at once before, so what I
want to know is:
Is this the best way to ensure against catastrophic failure of the server.
What do I need to read up on to achieve this.
Thanks.Hi
There are different options available depending on which version of SQL
Server you are running and what your system configuration is. With SQL 7 -
2005 you can use log shipping or replication. SQL 2005 has database
mirroring. There are also options that require specific hardware such as
failover clustering and SAN replication.
You may want to check out
http://www.microsoft.com/sql/techno...ty/default.mspx for
an introduction.
John
"JosephByrns" wrote:

> I would like to set up a new SQL server on a completely different box in a
> different location in the company (perhaps even offsite). I want this new
> server to be a mirror of the original SQL server, such that when data in t
he
> original server is updated the data in the new one is also updated etc...
> I would like to do this for security reasons, such that if the original
> server goes up in flames, I can recover all the data and quickly switch to
> the new server.
> I have only ever had to deal with one SQL server at once before, so what I
> want to know is:
> Is this the best way to ensure against catastrophic failure of the server.
> What do I need to read up on to achieve this.
> Thanks.
>
>|||Bear in mind that there is a Microsoft article on Mirroring that stipulates
that they do not recommend database mirroring in a production environment,
and should only be used in development and test environments.
Please see this article.
http://www.microsoft.com/technet/pr...5/dbmirror.mspx
AndyP,
Sr. Database Administrator,
MCDBA 2003
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> There are different options available depending on which version of SQL
> Server you are running and what your system configuration is. With SQL 7 -
> 2005 you can use log shipping or replication. SQL 2005 has database
> mirroring. There are also options that require specific hardware such as
> failover clustering and SAN replication.
> You may want to check out
> http://www.microsoft.com/sql/techno...ty/default.mspx fo
r
> an introduction.
> John
> "JosephByrns" wrote:
>|||Thank you both for the info, this is on SQL Server 2000, so I guess
mirriring doesn't apply here.
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:16EFB1CD-473F-4FE6-92FF-9B8D7979D1F9@.microsoft.com...[vbcol=seagreen]
> Bear in mind that there is a Microsoft article on Mirroring that
> stipulates
> that they do not recommend database mirroring in a production environment,
> and should only be used in development and test environments.
> Please see this article.
> http://www.microsoft.com/technet/pr...5/dbmirror.mspx
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "John Bell" wrote:
>|||OK, it looks like log shipping will do what I want, unfortunately it appears
that Log Shipping is only available to SQL 2000 Enterprise (I have
Professional), can you confirm this is true? Will I require enterprise for
the replication approach?
Thanks.
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:16EFB1CD-473F-4FE6-92FF-9B8D7979D1F9@.microsoft.com...[vbcol=seagreen]
> Bear in mind that there is a Microsoft article on Mirroring that
> stipulates
> that they do not recommend database mirroring in a production environment,
> and should only be used in development and test environments.
> Please see this article.
> http://www.microsoft.com/technet/pr...5/dbmirror.mspx
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "John Bell" wrote:
>|||I mean I have standard edition.
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:16EFB1CD-473F-4FE6-92FF-9B8D7979D1F9@.microsoft.com...[vbcol=seagreen]
> Bear in mind that there is a Microsoft article on Mirroring that
> stipulates
> that they do not recommend database mirroring in a production environment,
> and should only be used in development and test environments.
> Please see this article.
> http://www.microsoft.com/technet/pr...5/dbmirror.mspx
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "John Bell" wrote:
>|||Log shipping is only backup and restore. Can be done with any edition. But i
f you don't have EE, you
have to write your own jobs (or Google if someone has shared).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JosephByrns" <josephbyrns@.yahoo.com> wrote in message news:uCkLgGdTGHA.4952@.TK2MSFTNGP09.ph
x.gbl...
> OK, it looks like log shipping will do what I want, unfortunately it appea
rs that Log Shipping is
> only available to SQL 2000 Enterprise (I have Professional), can you confi
rm this is true? Will I
> require enterprise for the replication approach?
> Thanks.
> "AndyP" <AndyP@.discussions.microsoft.com> wrote in message
> news:16EFB1CD-473F-4FE6-92FF-9B8D7979D1F9@.microsoft.com...
>|||Great, thanks, I'll look into it.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23nDpl8lTGHA.4308@.TK2MSFTNGP10.phx.gbl...
> Log shipping is only backup and restore. Can be done with any edition. But
> if you don't have EE, you have to write your own jobs (or Google if
> someone has shared).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "JosephByrns" <josephbyrns@.yahoo.com> wrote in message
> news:uCkLgGdTGHA.4952@.TK2MSFTNGP09.phx.gbl...
>|||This is an outdated article.
Since Microsoft didn't strictly test data mirror on SQL 2005 RTM, so, Micros
oft doesn't recommend you carry out mirroring in a product environment.
But now, as you know, SQL 2005 SP1 has been release on 18th, April. We can c
omplete implement
it in your product server.
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message news:16EFB1CD-473
F-4FE6-92FF-9B8D7979D1F9@.microsoft.com...
Bear in mind that there is a Microsoft article on Mirroring that stipulates
that they do not recommend database mirroring in a production environment,
and should only be used in development and test environments.
Please see this article.
http://www.microsoft.com/technet/pr...5/dbmirror.mspx
--
AndyP,
Sr. Database Administrator,
MCDBA 2003
"John Bell" wrote:
[vbcol=seagreen]
> Hi
>
> There are different options available depending on which version of SQL
> Server you are running and what your system configuration is. With SQL 7 -
> 2005 you can use log shipping or replication. SQL 2005 has database
> mirroring. There are also options that require specific hardware such as
> failover clustering and SAN replication.
>
> You may want to check out
> http://www.microsoft.com/sql/techno...ty/default.mspx fo
r
> an introduction.
>
> John
>
> "JosephByrns" wrote:
>|||Hi
That was prior to SP1.
John
"AndyP" wrote:
[vbcol=seagreen]
> Bear in mind that there is a Microsoft article on Mirroring that stipulate
s
> that they do not recommend database mirroring in a production environment,
> and should only be used in development and test environments.
> Please see this article.
> http://www.microsoft.com/technet/pr...5/dbmirror.mspx
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "John Bell" wrote:
>