Re: SQL 2005 Log Shipping


hobbzilla wrote:
So, I have a primary database performing log shipping to a secondary
database. The logs are being backed up shipped and restored onto the
secondary.. NOW WHAT?

Trying to test the effectiveness of the solution, but have not found a
single article on how to promote or activate, etc the secondary backup
database and move it into a normal database instead of "Restoring". I
understand doing so would require a new full backup on the primary and
restore onto the secondary.


These topics in Books Online may help - if you haven't found them
already.
Failing Over to a Log Shipping Secondary

Using Warm Standby Servers

.

Relevant Pages

  • Re: Is this normal
    ... it is constantly restoring the shipped logs. ... I have restored the database to the primary server and this has worked fine. ... The secondary server starts the restore and the log files are placed on the ...
    (microsoft.public.sqlserver.replication)
  • Re: How to replay current log files after an restore????
    ... When database is restored and logs are replayed, ... My intention is to restoring the database to the current ... state using the last night backup and with the current transaction ...
    (microsoft.public.exchange.admin)
  • Placing Log on another drive
    ... After a new disk has been installed what is the ... easiest way way to move the logs to the new ... I'm thinking of dumping and restoring the database using ...
    (microsoft.public.sqlserver.server)
  • Re: Placing Log on another drive
    ... Steps to move LDF file to new drive ... Attach the database (SP_DETACH_DB,'MDF file with path','LDF file ... > easiest way way to move the logs to the new ... > I'm thinking of dumping and restoring the database using ...
    (microsoft.public.sqlserver.server)
  • Re: Dynamic Firewall/IDS System
    ... some thoughts about event handling software. ... > is almost impossible to handle manually just reading logs. ... > This is how we fill our database. ... this is logging, way like acid does with snort logs. ...
    (FreeBSD-Security)