Error

Tech-Archive recommends: Speed Up your PC by fixing your registry

Here is the following stuff which I do for recovery log file ... basically I
have lost log file and I only have a .mdf file.

Before going to the DOS mode I update the status of Health Database to 32768
and I only have a .mdf file.

>From the DOS mode I used the following command

sqlservr -c -T3608 -T4022

after that run the following command in Query Analyzer

select name, status from sysdatabases where name = 'Health'

Output:-
name status
Health 32768
Go
dbcc traceon(3604)
Go
DBCC Rebuild_Log('Health','C:\Health_Log.ldf')
GO

Error:-
Server: Msg 17, Level 16, State 1, Line 0
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
or access denied.
Server: Msg 10061, Level 16, State 1, Line 0
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).

Connection Broken

When I check from the dos mode it gave the following error:-
2005-05-13 11:26:16.01 spid51 Could not open FCB for invalid file ID 0 in
database 'Health'..



.

Relevant Pages

  • Re: ldf file missing...
    ... i'm agree with you but the most recent backup is dated nov 2004.... ... the problem now is the recovery of this mdf file and his recent data... ... >> new log file will be created and you can see the db in EM. ... one database mdf file and one log file. ...
    (microsoft.public.sqlserver.server)
  • Re: Attach
    ... database wasn't detached cleanly. ... What happened to the log file? ... Jasper Smith (SQL Server MVP) ... > How can I reattach a MDF file with only the .MDF available? ...
    (microsoft.public.sqlserver.setup)
  • Re: newbie backup question
    ... > night's backup I still have a 12 GB log file. ... > How do I get the transactions to commit to the .mdf file? ...
    (microsoft.public.sqlserver.setup)
  • Error
    ... Here is the following stuff which I do for recovery log file ... ... have lost log file and I only have a .mdf file. ... Before going to the DOS mode I update the status of Health Database to 32768 ...
    (microsoft.public.sqlserver.clients)
  • Lost Log File !
    ... Here is the following stuff which I do for recovery log file ... ... have lost log file and I only have a .mdf file. ... Before going to the DOS mode I update the status of Health Database to 32768 ...
    (microsoft.public.sqlserver.clients)