SQL 2005 Log Shipping

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.

.

Relevant Pages

  • SQLDMO: howto obtain logical file names from a BAK file
    ... what, how, when does a logical file name is determine for a database? ... If I am restoring a db from Enterprise Manager, under the Options tab, ... the actual BAK file, but I haven't figured that out yet. ... file comes from another SQL server, was created in another folder, so ...
    (microsoft.public.sqlserver.programming)
  • Re: replication server crashed
    ... I am unsure what state your replication topology is in. ... If the database is restored and the master, distribution, and msdb database ... the subscribers will fill in missing transactions in the ... keep_replication switch while restoring these databases. ...
    (microsoft.public.sqlserver.replication)
  • Re: Restoring Master and msdb databases
    ... note that you need to stop the SQL Server Agent service when restoring the MSDB database ... The SQL Server needs to be in Single-User mode, not just the master ...
    (microsoft.public.sqlserver.setup)
  • Re: Exiftool
    ... The big question is, which database, how much effort is it going to ... .INI file using XWP Helpers code instead of PM ... restoring my January archive about twice per week. ... use it for a few installs. ...
    (comp.os.os2.apps)
  • XPe SQL Database Backup/Restore
    ... This is a general FYI to anyone having difficulty with restoring the XP ... Embedded Component Database. ... Microsoft SQL Server Management Studio Express ...
    (microsoft.public.windowsxp.embedded)