Hi,

How do I bring up the standby server online in sql2k by restoring the last
log backup(backed up with noinit).
This log file has been restored with standby clause. can I restore again
with recovery?

Thanks,

Hi

Yes.

RESTORE <dbname> WITH RECOVERY
will bring the DB into a usable state.

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"mecn" <mecn2002 (AT) yahoo (DOT) com> wrote

Thanks,
But when I doing restore with recovery give me error says Server: Msg 4326,
Level 16, State 1, Line 11
The log in this backup set terminates at LSN 6791000023918900001, which is
too early to apply to the database. A more recent log backup that includes
LSN 6794000015810000001 can be restored.

I don't know why?
"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote

Can you post that exact RESTORE command you are executing?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


"mecn" <mecn2002 (AT) yahoo (DOT) com> wrote

This is the script I excuted with error.

restore log LDNPROD from disk = 'path.bak' with recovery





"Tibor Karaszi" <tibor_please.no.email_karaszi (AT) hotmail (DOT) nomail.com> wrote in
message news:ObMuJOn9FHA.3660 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

If you just want to make the database accessible (fail over), try executing (as suggested by Mike):

RESTORE DATABASE LDNPROD WITH RECOVERY

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


"mecn" <mecn2002 (AT) yahoo (DOT) com> wrote