Database is in recovery status.

Question

Post reply

Database is in recovery status.

Viewing 15 posts - 16 through 30 (of 37 total)

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

karthickmca6-620862 SSC Enthusiast Points: 180 More actions · Answer 1

Hi,

Is there any information in Sql errror log ?

same time check the current and previous errorlog files, and NT errorlogs

Only on very rare occasions will SQL Server not recover the database correctly

1. If the database size is too large and no space in the specific drive it occurs (log file full also will cause this )

2. If there is any fault in the hard disk also it may occur

i have faced this problem when handling a huge gb database in sqlserver 2000 , so we restarted the service and checked the error log . the database got recovered upto 40 % and then it skipped , so microsoft suggested to migrate the databse to sqlserver 2005 , that works for us, after that migration we dint face any errors like that

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

charipg (3/24/2010)
no errors in errorlog.

No messages whatsoever relating to this database? Can you post the latest error log (just zip and attach the ERRORLOG file)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

karthickmca6-620862 SSC Enthusiast Points: 180 More actions · Answer 3

Hi Gupta..

I hope detaching and attching will not help,if same problem is raised once again ... so it may be the file corruption or disk corruption

please give ur feedback , go for checkdb and checkdisk with intel team

P.Karthcik

charipg SSCrazy Eights Points: 9888 More actions · Answer 4

I have restarted the services then tried to detach then i got the same error "The data base is in use".

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 5

charipg (3/26/2010)
I have restarted the services then tried to detach then i got the same error "The data base is in use".

charipg,

Read my previous replay.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 6

Restarting sql server (or) detach and attach the db will not bring the database online

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 7

Gail and myself already asked the error logs and application logs.If you give those thing we ll try to help u.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

blue_inelush Ten Centuries Points: 1118 More actions · Answer 8

Hello,

Are you 100% positive there is no process working on that db?

Have you looked in Activity Monitor if there is no process there?

Have you tried to detach the db using

dbcc detachdb('table_name') ?

Wish you good ideas! 🙂
Andreea

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 9

blue_inelush (3/26/2010)
Hello,
Are you 100% positive there is no process working on that db?
Have you looked in Activity Monitor if there is no process there?
Have you tried to detach the db using
dbcc detachdb('table_name') ?

The code is correct.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

charipg SSCrazy Eights Points: 9888 More actions · Answer 10

There is no eventlog and sqlserver errorlog for this .

blue_inelush Ten Centuries Points: 1118 More actions · Answer 11

But... I'm sorry, I really don't want to be rude...I just want to understand.

I don't understand... the db is for 3 months in restoring? What happened?

Why haven't you panicate earlier or someone else was involved in administering the dbs?

Wish you good ideas! 🙂
Andreea

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

charipg (3/26/2010)
There is no eventlog and sqlserver errorlog for this .

Can you post the SQL error log and let us have a look at it? There may be messages in there that you've missed.

SQL logs the startup routine of a database, seeing what has happened and what has not may help in solving this.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

blue_inelush Ten Centuries Points: 1118 More actions · Answer 13

I dont' know if possible, because I have nerver tested them, but have you tried:

1. to update the db files status in the sys.database_files?

or maybe you can read a little about this?

2. http://www.recoverytoolbox.com/sql.html

Hope you'll solve it somehow as soon as possible.

Wish you good ideas! 🙂
Andreea

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

blue_inelush (3/26/2010)
I dont' know if possible, because I have nerver tested them, but have you tried:
1. to update the db files status in the sys.database_files?

Cannot be done. Very, very dangerous to suggest messing with the system tables.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Nitin Gupta - SQL DBA Ten Centuries Points: 1058 More actions · Answer 15

Might be it's not work in this case but I have done this previously as I got my database is in recovery mode. I just stop the SQL services, rename the data files (.mdf & .ldf), drop the existing database and attached the data files with same database name simple.

after that I run DBCC Checkdb to verify database health and I found everything are looks good without any error. 😀

Thanks & Regards,

Nitin Gupta
SQl Server (7.0,2000,2005) - Sr. DBA
HCL Technologies, India