Re: Transaction Log Shipping setup

Ron,

In SQL 2005 Log Shipping, you have a Standby option in the restore tab of
the Log Shipping Properties GUI, which will put your database in read-only
between restores. If your logs take 30 minutes to restore and you restore
every 30 mionutes, you'll be perpetually restoring...

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Ron" <Ron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:82650E96-2E17-4435-AF9B-5FF154AB8F10@xxxxxxxxxxxxxxxx
I was wondering the same thing. Our databases are in "restoring" mode and
transaction logs are being applied every 30 minutes.

I vaguely remember reading that to get the database to a readable state
you
must recover the database. I'm not sure what the syntax would be or if
it's
a dummy restore with recover.

Ron

"David" wrote:

We setup Log Shipping on our servers and all seems to have gone well.
However, on the secondary server, the restored database seems to be in a
perpetual restore state. I cannot find any documentation that goes past
the
setup. Is this normal, and if so how do you stop the restore to verify
the
data is being restored correctly.

SQL 2005 SP2

David



.

Relevant Pages

  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • 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)
  • Re: Restore leaves DB in Loading state
    ... state of loading after the database restore - rather than in read only. ... > leave SQL restore hanging until it could write to that file. ... > I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Problem causing me to have to restore tlogs WITH MOVE
    ... I have a database i am m oving to another server, ... am moving the data and log files to another drive.(Which I have done ... The problem I am having is after I restore the database using the ... TO ?D:\Program Files\Microsoft SQL ...
    (comp.databases.ms-sqlserver)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)