Re: Transaction Log Shipping setup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Seems like something has gone awry...how big is the source database?

--

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.



"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C1E22071-7E42-4555-91CC-B0C3143891DA@xxxxxxxxxxxxxxxx
Yes, this is the initial restore. I have stopped all jobs related to this
and the database still says it is restoring. I looked at the job activity
monitor and it says the jobs succeeded without error.

"Kevin3NF" wrote:

I would look into the LS_Restore job and see if it is actually running.
Also check the Activity Monitor to see if there is a restore command
going.

Is this on the initial restore, or are you at the point that the T-logs
are
in process?

--

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.



"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DEDECF4B-63FC-4D89-9739-48FEF56566BA@xxxxxxxxxxxxxxxx
Thanks for the reply Kevin,
ive got that and disconnect users checked. The database says it is
still
in the middle of a restore and has been for a day.

"Kevin3NF" wrote:

Look in the restore tab of the Transaction log shipping properties on
the
Source database...there's an option to let the database be in stanby
mode
between restores. You might have to re-initialize the log shipping to
turn
that on...don't think I've flipped that bit in mid-stream before.

--

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.



"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D62BFB90-B9AD-4715-B1E4-4C8981F7BE76@xxxxxxxxxxxxxxxx
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: Transaction Log Shipping setup
    ... and the database still says it is restoring. ... monitor and it says the jobs succeeded without error. ... Also check the Activity Monitor to see if there is a restore command going. ... SQL Server dude ...
    (microsoft.public.sqlserver.replication)
  • Re: Backup
    ... SQL Server dude ... Do we need to backup the master db as well? ... right-clicking on the database in the GUI and following the wizard ... CD to easily restore it once we go live. ...
    (microsoft.public.sqlserver.setup)
  • Re: Transaction Log Shipping setup
    ... Also check the Activity Monitor to see if there is a restore command going. ... SQL Server dude ... Hit my blog and the contact links if necessary...I may be available. ... Source database...there's an option to let the database be in stanby mode ...
    (microsoft.public.sqlserver.replication)
  • Re: Transaction Log Shipping setup
    ... Look in the restore tab of the Transaction log shipping properties on the ... Source database...there's an option to let the database be in stanby mode ... SQL Server dude ...
    (microsoft.public.sqlserver.replication)
  • 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)