|
| 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]ConnectionOpe
n
(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'..
|
|