473,326 Members | 2,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Bypassing recovery for database

MS SQL-Server 7.0
Bypassing recovery for database 'EfW_765' because it is marked IN LOAD.
What does this mean?
Our customer is backing up is maindatabase and is recovering it to this
database for testing.
Our custumer tries it serveral times and then the recovery works and the
data are corrupt.
I have written a little programm which does some selects to this database.
The program is stopped during recovery but our customer beleves that this
has something to do with our program.
http://support.microsoft.com/default...b;en-us;272683
This article doesnt halp me much. So hwat is the meaning of IN LOAD and what
does the server do if it bypasses the recovery.

THX

Jens
Jul 20 '05 #1
2 11138

"Jens Kalkbrenner" <je**************@wsk.de> wrote in message
news:c5*************@news.t-online.com...
MS SQL-Server 7.0
Bypassing recovery for database 'EfW_765' because it is marked IN LOAD.
What does this mean?
Our customer is backing up is maindatabase and is recovering it to this
database for testing.
Our custumer tries it serveral times and then the recovery works and the
data are corrupt.
I have written a little programm which does some selects to this database.
The program is stopped during recovery but our customer beleves that this
has something to do with our program.
http://support.microsoft.com/default...b;en-us;272683
This article doesnt halp me much. So hwat is the meaning of IN LOAD and what does the server do if it bypasses the recovery.

THX

Jens


I'm not entirely sure, but it sounds as if the database has been partially
recovered, and then the MSSQLServer service has been restarted. This might
be normal, if someone is recovering the database by applying mutiple log
files, for example. Have you tried this, to restore the database and make it
available?

RESTORE DATABASE EfW_765 FROM ... WITH RECOVERY

If this doesn't help, can you give some more details about exactly what is
happening? Is the recovery from a full backup only or from a full backup
plus logfiles? What do you mean when you say the data is "corrupt"? Are you
sure you're recovering the correct backup set? Is the customer trying to
copy database A to database B using backup/restore? If so, have you followed
the steps in Books Online under "Copying Databases"?

Simon
Jul 20 '05 #2

"Jens Kalkbrenner" <je**************@wsk.de> wrote in message
news:c5*************@news.t-online.com...
MS SQL-Server 7.0
Bypassing recovery for database 'EfW_765' because it is marked IN LOAD.
What does this mean?
Our customer is backing up is maindatabase and is recovering it to this
database for testing.
Our custumer tries it serveral times and then the recovery works and the
data are corrupt.
I have written a little programm which does some selects to this database.
The program is stopped during recovery but our customer beleves that this
has something to do with our program.
http://support.microsoft.com/default...b;en-us;272683
This article doesnt halp me much. So hwat is the meaning of IN LOAD and what does the server do if it bypasses the recovery.

THX

Jens


I'm not entirely sure, but it sounds as if the database has been partially
recovered, and then the MSSQLServer service has been restarted. This might
be normal, if someone is recovering the database by applying mutiple log
files, for example. Have you tried this, to restore the database and make it
available?

RESTORE DATABASE EfW_765 FROM ... WITH RECOVERY

If this doesn't help, can you give some more details about exactly what is
happening? Is the recovery from a full backup only or from a full backup
plus logfiles? What do you mean when you say the data is "corrupt"? Are you
sure you're recovering the correct backup set? Is the customer trying to
copy database A to database B using backup/restore? If so, have you followed
the steps in Books Online under "Copying Databases"?

Simon
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Praveen | last post by:
Hi All, I'm using Oracle 8.1.7 on Win2k Prof. Today morning because of power problem, my system has restarted 8 times. When the power became stable and switch on my system, the oracle says...
5
by: rcamarda | last post by:
I need a sql statment to return a list of tables for a given database where the Recovery Model option is Simple. TIA Rob
7
by: Network Administrator | last post by:
Looks like for the first time in 6 years, I'm experienced some database table corruption. This was due to the space filling up on a server (you don't want to know how that happened). I have 3...
8
by: Neil Truby | last post by:
There's something clearly missing in my understanding of recovery: I set up a small sample datavase and deleted all the rows from a table. Crucially, I omitted the "commit". I then shut down...
10
by: xixi | last post by:
i have db2 udb v8.1 on windows 64 bit 2003 server, after db2 server start , i found this in the db2diag.log, is this error? 2004-05-05-15.28.30.780000 Instance:DB2 Node:000...
3
by: jignesh shah | last post by:
Hi all, Is there a way to recover a single container if its been corrupted or mark bad without restoring whole tablespace? environment: db28.1/aix5.1/tsm/rs-6000. Regards Jignesh
5
by: NG | last post by:
Hi, We are having DB2-V7.2 DB on AIX 5.2 machine. Recently we upgraded our system to fixpack 13 and activated activate AIX asynchronous IO function. Our DB is going to crash recovery with...
2
by: Matik | last post by:
Hello, I've follow problem - thing to consider. SQLServer 200 sp3a, ms win 2003 server db simple recovery There is a production database, wich is around 20gb big. Db is backed up each...
2
by: Racerx | last post by:
Hi All : I use db2 8.1 fixpack 3 on AIX. I recieved the following message in the diaglog ====================================================== ADM7513W Database manager has started. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.