x

How to recover a suspect database which is in standby mode(restoring Database)

Hi all Actually I configured Log shipping to one of my database. i configured secondary database as standby with disconnect users while restoring.It all working fine When I restared my server on daily basis. Suddenly my Secondary database firstly it went into to standby/restoring State then now it is showing suspect/standby I Am trying to recover the database it did'nt worked because it is restored state as we cannot alter database. and what is solution I can for Do that????? thanks in Advance

alt text

capture.png (3.9 kB)
more ▼

asked Feb 04, 2015 at 06:51 AM in Default

avatar image

UnishSQL
419 6 11 21

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Drop the suspect secondary database, restore a new copy of it and restart logshipping. No point in recovering it since it's the secondary.

Though you should check the logs or I/O subsystem for reasons that could make your database suspect. But you write "When I restarted my server on daily basis", are you restarting your server on a daily basis? If so, why?

more ▼

answered Feb 04, 2015 at 08:24 AM

avatar image

raadee
4.5k 13 18 22

my server its not production server it is in my Local System..i shut Down My system after i logout

Feb 04, 2015 at 09:06 AM UnishSQL

i dont know what Happened Now It Working Fine Now and I didn't Do anything @raadee

Feb 04, 2015 at 09:07 AM UnishSQL

Well it is hard to say exactly since your laptop/workstation isn't the most reliable system to have a log shipping config on. Just restore the database and reinitialize the log shipping is it goes broke and does not magically fix itself.

Feb 04, 2015 at 09:11 AM raadee
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2221
x86
x22
x11
x4

asked: Feb 04, 2015 at 06:51 AM

Seen: 580 times

Last Updated: Feb 04, 2015 at 09:11 AM

Copyright 2018 Redgate Software. Privacy Policy