It is currently Sun, 28 May 2017 21:39:56 GMT

Author Message
 DHCP Database Corrupt

I started getting the following two events this morning from DHCPServer:

1014 - The JET Database call returned the follwing error: -1032
1016 - The DHCP server encountered the following erre when backing up the
user datase:
    Data: 0000:  2d 4e 00 00  -N..

I'd like to restore the database, but before I do I would like any thoughts
about two concerns:

1. What are the chances that the backup copy stored in the backup directory
is corrupted as well (I suspect it wouldn't be and should be ok to use) or
would it be better to restore from tape backup (I do a full backup every
night) performed 20 hours before the events started?  Naturally, I'd like to
use a backup that was an hour old instead of 20 hours old.

2. What are the consequences if one of my clients lease expired and was not
renewed since the database became corrupt?

Any thoughts would be appreciated.

Ned Butler

 Sat, 25 Aug 2001 03:00:00 GMT   
 DHCP Database Corrupt


Go ahead and try to restore the most recent.  It should be OK, but if it doesn't
work, then grab the one off of the backup.

I wouldn't worry too much about the clients.  DHCP is flexible enough to handle
this sort of thing.  Make sure you enable the option on the DHCP service to ping
an address before it assigns it.  That way, if you restore your database and
somebody got an address after it was backed-up, it won't be issued to a second
client.  As for clients whose DHCP lease has expired- just restart them and
they'll grab a new address.

I've completely deleted a DHCP scope and recreated a new one without my clients
having any problems.

--Brian Purcell, MCSE, MCP+I
Local Area Network Manager
Office of Educational Resources
University of Texas Health Science Center at San Antonio

 Sat, 25 Aug 2001 03:00:00 GMT   
 DHCP Database Corrupt
technet article q173396

Ned Butler <> wrote in article

 Sat, 25 Aug 2001 03:00:00 GMT   
 DHCP Database Corrupt
UPDATE:  Still a problem.

Near as I can tell, it is not the current database
(%systemroot%\system32\dhcp\dhcp.mdb) that is corrupt but is actually the
backup database (%systemroot%\system32\dhcp\backup\jet\new\dhcp.mdb) which
is corrupt.

The error mentioned in my event log for the JET database is 1032 - Cannot
Access File.  I was able to successfully JETPACK the current DHCP.mdb,
however I still come up with the event log errors.  So I tried to JETPACK
the backup DHCP.mdb which returned error 528 - Current Log File Missing.

This leads me to believe the file that error 1032 is referring to is the
backup DHCP.mdb.  What can I do to replace the backup DHCP database files?
Am I going to have to delete the scope and create a new one?

By the way, DHCP is renewing leases and other than the above problem,
appears to be functioning properly.

Ned Butler

 Sun, 26 Aug 2001 03:00:00 GMT   
 DHCP Database Corrupt
If nothing else, delete the scope and start fresh.  Creating scopes is
pretty easy.  

Ned Butler <> wrote in article

 Sun, 26 Aug 2001 03:00:00 GMT   
 DHCP Database Corrupt
I had completed the steps in Q173396 to no avail.  I believe the problem was
actually with the backup database being corrupt and not the current
database.  I think the errors were generated as a result of a failure to
write to the backup database.

Looks like I have it fixed and here is (to the best of my recollection) what
I did:

1. I deleted the j50.log and J#####.log files in the main dhcp directory
and, unlike what the article said, I also deleted the dhcp.mdb file (of
course, I ran a backup first).

2. I restored the whole dhcp directory from what I believed to be the last
good backup of that directory (meaning prior to the database becoming

3.  I made sure that the only files in the dhcp\backup\jet\new directory
were dchp.mdb, dhcp.pat and a j####.log file.  Then I copied the dhcp.mdb to
the dhcp directory.

4.  Then I restarted the DHCP service, checked the event log - saw no
errors.  Then stopped the DHCP service, checked the event log - saw no
errors.  Then restarted the DHCP service again and checked the event log and
saw no errors.

So, for now everything seems to be fixed (I'm keeping my fingers crossed).

Ned Butler

 Mon, 27 Aug 2001 03:00:00 GMT   
   [ 6 post ] 

Similar Threads

1.DHCP/WINS database viewer

I would like to be able to view the contents of our DHCP & WINS
databases.  Does anyone know of any utilities that can achieve this?

I am familiar with the DHCPCMD & WINSCL utilities but these do not
appear to give full details of the database contents (e.g. I would
like to see which MAC addresses have been assigned against particular
IP reservations in the DHCP database).

I understand that the databases are based on a modified Jet database,
so when trying to use tools such VB & Access, they report an error
opening the MDB file.

Many thanks for any assistance that can be given.

Mike Welham

2. DHCP database losing entries

3. Exporting Winnt4 DHCP database

4. Microsofts DHCP database

5. Search/Dump DHCP database?

6. DHCP database corruption

7. DHCP database corruption

8. DHCP Database

9. How to Backup the Contacts Database&#12289;Tasks Database&#12289;Appointment Database

10. configuration registy database is corrupt

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software