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.

From the Books Online topic - RESTORE (Transact-SQL)
--Recover the database:
RESTORE DATABASE MyDatabase WITH RECOVERY;
GO

This code applies after any individual or series of restores with
NORECOVERY.

.

Relevant Pages

  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: Restore public folders and companyweb
    ... > where the backup of the database. ... Before you can start to restore the SharePoint Services databases, ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)
  • Re: PARTIAL SQL Server RESTOREs
    ... DROP DATABASE mywind_part ... ALTER DATABASE mywind ADD FILEGROUP new_customers ... -- A full database backup is performed. ... RESTORE FILELISTONLY lists the database ...
    (microsoft.public.sqlserver.server)