DB in 'Restoring' mode.

Question

Post reply

DB in 'Restoring' mode.

beejug1983

SSCertifiable

Points: 6491
More actions
April 8, 2010 at 11:25 pm

#139345

I have a db in sql 2005 with two file group. I had to restore one of the file group, when I restored one of file group since then, my db showing in 'Restoring' mode. I checked all error logs but could not find any clue. Please suggest me what to do ?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

how long has it been running as "Restoring" ?

If you suspect it's not actually restoring,try:

restore log dbname with norecovery

and see if it comes online. Beware, you will lose some changes.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

beejug1983 SSCertifiable Points: 6491 More actions · Answer 2

Thanks Henrico

I tried this & my problem got solved. Thnak you very much.

beejug1983 SSCertifiable Points: 6491 More actions · Answer 3

beejug1983

SSCertifiable

Points: 6491

April 9, 2010 at 1:25 am

#1148859

But can you describe it, why this happened ?

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 4

Is this database a destination for log shipping, or part of a failover solution?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

beejug1983 SSCertifiable Points: 6491 More actions · Answer 5

Its neither log shipping nor part of failure solutions.

beejug1983 SSCertifiable Points: 6491 More actions · Answer 6

Every time when I take file group backup, & restore it, restoration gets done successfully but after restoring file group, that db begins to show in 'Restoring' mode. And the first time when I take file group backup an error occurs i.e. take tail log backup for the db, when I take tail log backup then my file group backup succeeds.

Restore command is as follow:-

RESTORE DATABASE ICT FILEGROUP='detailsofname' FROM DISK='z\data\detailsofname.bak' WITH norecovery;