Re: can't mount the database error

From: Mike Manjunath [MSFT] (mikeman_at_online.microsoft.com)
Date: 02/01/04 

Date: Sun, 1 Feb 2004 13:38:35 -0600

=> First of all Don't worry about Event Service. You don't need that until u
r running any Event Scripts.

Now coming back to ur database question:
"You should never touch the logs unless u know what you are doing."

Missing logs is most likely the cause of your current problem.

Run the following command on the priv1.edb,
Eseutil /mh Priv1.edb

In the output, check out a line called "Logs required".
For example it will be something like "Logs required: 2345-2348"
Put the number 2345 into the scientific calculator and then cover it to
"Hex". The result will be something like 929.
Find out if you have a log file with that name E00929.log.
In order to bring the database to clean shutdown, you need all logs starting
from E00929.log to E00.log

Here are the resolutions if u cannot find those logs:
1) Restore from previous backup.
2) Repair the databases. When u run repair you should also run the defrag
and isinteg. 

-- 
Mike Manjunath
Microsoft Corp.
"Please do not send email directly to this alias. This alias is for
newsgroup purposes only."
"This posting is provided "AS IS" with no warranties, and confers no
rights."
"me" <anonymous@discussions.microsoft.com> wrote in message
news:79b101c3e8ca$2ba187b0$a101280a@phx.gbl...
> I'mnot sure what is going on. Restated the server and all
> exchange services are up and running (exceptevent service)
> but my databases are not mounted.
> I have no back up what so ever of these databases.
> We deleted some transaction logs but not E00.log.
> we don't have backup of these but might try a recovery
> software.
> when we checked the state for both databases it returned
> dirty shutdown.
> also, when we checked the integrity,we got a warning
> message that the database is not up to date and need to
> use the recovery option.
>
> what should we do next? try to recover the log files?
> or try the eseutilwith the soft recovery option?
>
> wedon't have a virus scanner on the machine,we have an
> exchnage virus scanner.
>
> please let me know what do.
> Dose this mean that we have lost everyhting?
>

Relevant Pages

  • Re: Question about Exchange Logs and DBs Best Practice
    ... Yes, even from 5.5 days, the primary reason you separate logs from databases ... For Exchange news, links and tips, check: ... > If you put ALL the databases in one RAID set, then if that one RAID set ...
    (microsoft.public.exchange2000.admin)
  • Re: Disk Partitioning/RAID recommendations
    ... Probably the best thing you can do is to separate the databases and logs ... However, you may be tight for space on the mirror this way, so you could ... Repartitioning drives as we move from Exchange 2000 to ...
    (microsoft.public.exchange2000.setup.installation)
  • Re: E2K7 SP1 Configuring Storage
    ... So any info you can provide on how NetApp has their databases or storage ... One Volume has one LUN in it and one database inside that LUN. ... Put the SNAPINFO on the same LUN as the transaction logs. ... talk to NetApp about your aggregates. ...
    (microsoft.public.exchange.setup)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... Yes, you are right, I read that Michelle is writing about logs not log, is ... there possibility that she looks at transaction logs on databases with full ... > You cannot set the recovery model in tempdb. ... >> We have at least two databases on this server in simple recovery model. ...
    (microsoft.public.sqlserver.server)
  • Re: RAID5 Data disk and Mirrored Controller disks -- Best Practices?
    ... How big do you expect the log files to be? ... Put the databases and logs on the RAID 5 volume. ... if I have a RAID5 data partition on a separate SCSI channel and then ...
    (microsoft.public.sqlserver.setup)