|
|
| raider2 2005-08-01, 3:23 am |
| is there a good proceedure for transfering DB files from one server to
another for failover. To clairify, I have 2 servers one primary the other
backup. I want to regularly transfer the DB from one to the other so that if
the primary fails they can switch to the backup and the DB will be fairly
recent, within one to two hours.
I am already backing up the primary DB every hour.
Thanks,
Ed
| |
| ChrisR 2005-08-01, 3:23 am |
| See Log Shipping in BOL.
"raider2" <raider2@discussions.microsoft.com> wrote in message
news:3D768DE3-9FC1-409B-94E0- 9D355F5BAB48@microso
ft.com...
> is there a good proceedure for transfering DB files from one server to
> another for failover. To clairify, I have 2 servers one primary the other
> backup. I want to regularly transfer the DB from one to the other so that
if
> the primary fails they can switch to the backup and the DB will be fairly
> recent, within one to two hours.
> I am already backing up the primary DB every hour.
> Thanks,
> Ed
| |
| Peter Lykkegaard 2005-08-01, 3:23 am |
| "ChrisR" wrote
>
> "raider2" wrote
[color=darkred]
> See Log Shipping in BOL.
>
"Log Shipping" requires Enterprise Edition installed
- Peter
| |
| Hari Prasad 2005-08-01, 7:23 am |
| Hi,
See the various approaches from Vyas.
http://vyaskn.tripod.com/ maintaini...
sql_server.htm
Thanks
Hari
SQL Server MVP
"raider2" <raider2@discussions.microsoft.com> wrote in message
news:3D768DE3-9FC1-409B-94E0- 9D355F5BAB48@microso
ft.com...
> is there a good proceedure for transfering DB files from one server to
> another for failover. To clairify, I have 2 servers one primary the other
> backup. I want to regularly transfer the DB from one to the other so that
> if
> the primary fails they can switch to the backup and the DB will be fairly
> recent, within one to two hours.
> I am already backing up the primary DB every hour.
> Thanks,
> Ed
| |
| ChrisR 2005-08-01, 9:23 am |
| Peter as mentioned in the link below, people can use they're own scripts for
Log Shipping if they're not on EE.
See this: http://www.sql-server-performance.c...p
ing.asp
"Peter Lykkegaard" <peter.aghl@gmail.com> wrote in message
news:uHdCNFnlFHA.2444@tk2msftngp13.phx.gbl...
> "ChrisR" wrote
>
>
>
> "Log Shipping" requires Enterprise Edition installed
>
> - Peter
>
>
| |
| Peter Lykkegaard 2005-08-01, 11:23 am |
| "ChrisR" wrote
> Peter as mentioned in the link below, people can use they're own scripts
> for
> Log Shipping if they're not on EE.
>
> See this:
> http://www.sql-server-performance.c...p
ing.asp
>
Ahh excellent :-)
BOL states that Log Shipping as EE only
I will dig into the article as we also occasionally needs a hot standby
server without resorting to a clustered solution
(customer requests)
- Peter
| |
| ChrisR 2005-08-01, 11:23 am |
| Cool. As you will read, Log Shipping is nothing more than a glorified
backup/ restore. I've written my own 3 times and don't know that I would
even use the GUI now as with mine I know exactly whats going on.
"Peter Lykkegaard" <peter.aghl@gmail.com> wrote in message
news:uk997wqlFHA.3568@tk2msftngp13.phx.gbl...
> "ChrisR" wrote
>
> Ahh excellent :-)
> BOL states that Log Shipping as EE only
>
> I will dig into the article as we also occasionally needs a hot standby
> server without resorting to a clustered solution
> (customer requests)
>
> - Peter
>
|
|
|
|