| Groups | Blog | Home |
sql server replication : How do you replicate one server ot another to be a backup??
WE have two SQL 2000 servers running on Windows Server 2003. One server is
setup and works fine. What we wanted to do (without going outside of Microsoft software) was to replicate one server to the other either nightly or on the fly. Reason is, if we lost the first server we need to be able to failover quickly. Help! BJ
The simplest way to do this for smaller databases is a backup restore. For
larger databases use log shipping, or transactional replication. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "BJ" <lmelogra@optonline.net> wrote in message news:eVDk7qOvGHA.1808@TK2MSFTNGP06.phx.gbl... > WE have two SQL 2000 servers running on Windows Server 2003. One server > is setup and works fine. What we wanted to do (without going outside of > Microsoft software) was to replicate one server to the other either > nightly or on the fly. Reason is, if we lost the first server we need to > be able to failover quickly. > > Help! > > BJ >
For more info on Hilary's suggestions, you might want to take a look at the
Microsoft SQL Server 2000 High Availability Series (http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx). Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com
I have similar problem. I do want to backup database on source SQL 2000 box
and restored it on the other target box with same DB name daily. Is there a way to automated backup and restore to another server for a small 12GB database? I can shedule backup to a file and ad a step to copy but how schedule dayly restore from the file? Thank you, LP [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:e$ql%23CPvGHA.428@TK2MSFTNGP03.phx.gbl... > The simplest way to do this for smaller databases is a backup restore. For > larger databases use log shipping, or transactional replication. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "BJ" <lmelogra@optonline.net> wrote in message > news:eVDk7qOvGHA.1808@TK2MSFTNGP06.phx.gbl... >> WE have two SQL 2000 servers running on Windows Server 2003. One server >> is setup and works fine. What we wanted to do (without going outside of >> Microsoft software) was to replicate one server to the other either >> nightly or on the fly. Reason is, if we lost the first server we need to >> be able to failover quickly. >> >> Help! >> >> BJ >> > >
Restore using Enterprise Manager the first time. Before you start the
restore run profiler, and capture the commands used. Then encapsulate these in a job. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "LP" <leo.p@comcast.net> wrote in message news:fJ-dnRorOJFuBEHZnZ2dnUVZ_qadnZ2d@comcast.com... >I have similar problem. I do want to backup database on source SQL 2000 box >and restored it on the other target box with same DB name daily. Is there a >way to automated backup and restore to another server for a small 12GB >database? > I can shedule backup to a file and ad a step to copy but how schedule > dayly restore from the file? > Thank you, > LP > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:e$ql%23CPvGHA.428@TK2MSFTNGP03.phx.gbl... >> The simplest way to do this for smaller databases is a backup restore. >> For larger databases use log shipping, or transactional replication. >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "BJ" <lmelogra@optonline.net> wrote in message >> news:eVDk7qOvGHA.1808@TK2MSFTNGP06.phx.gbl... >>> WE have two SQL 2000 servers running on Windows Server 2003. One server >>> is setup and works fine. What we wanted to do (without going outside of >>> Microsoft software) was to replicate one server to the other either >>> nightly or on the fly. Reason is, if we lost the first server we need >>> to be able to failover quickly. >>> >>> Help! >>> >>> BJ >>> >> >> > >
thank you.
[quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:eRxcruVvGHA.1512@TK2MSFTNGP04.phx.gbl... > Restore using Enterprise Manager the first time. Before you start the > restore run profiler, and capture the commands used. Then encapsulate > these in a job. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "LP" <leo.p@comcast.net> wrote in message > news:fJ-dnRorOJFuBEHZnZ2dnUVZ_qadnZ2d@comcast.com... >>I have similar problem. I do want to backup database on source SQL 2000 >>box and restored it on the other target box with same DB name daily. Is >>there a way to automated backup and restore to another server for a small >>12GB database? >> I can shedule backup to a file and ad a step to copy but how schedule >> dayly restore from the file? >> Thank you, >> LP >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:e$ql%23CPvGHA.428@TK2MSFTNGP03.phx.gbl... >>> The simplest way to do this for smaller databases is a backup restore. >>> For larger databases use log shipping, or transactional replication. >>> >>> -- >>> Hilary Cotter >>> Director of Text Mining and Database Strategy >>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >>> >>> This posting is my own and doesn't necessarily represent RelevantNoise's >>> positions, strategies or opinions. >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "BJ" <lmelogra@optonline.net> wrote in message >>> news:eVDk7qOvGHA.1808@TK2MSFTNGP06.phx.gbl... >>>> WE have two SQL 2000 servers running on Windows Server 2003. One >>>> server is setup and works fine. What we wanted to do (without going >>>> outside of Microsoft software) was to replicate one server to the other >>>> either nightly or on the fly. Reason is, if we lost the first server >>>> we need to be able to failover quickly. >>>> >>>> Help! >>>> >>>> BJ >>>> >>> >>> >> >> > >
I was looking to have it done automatically every night.
[quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:uIDYt5RvGHA.1436@TK2MSFTNGP02.phx.gbl... > For more info on Hilary's suggestions, you might want to take a look at > the Microsoft SQL Server 2000 High Availability Series > (http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx). > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com >
The thing is that the available options each have their own quirks, and only
a full understanding of what is available will lead you to make the right choice. However from the small explanation you gave, I would take a look at log-shipping as your solution. The schedule of the restore job can ensure that the logs are applied during the night. If you want to just backup and restore the full database, this is achieved by a similar set of routines, but the setup will be manual to a large extent, as opposed to log-shipping which has a wizard and a monitoring ability also. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |