Dear Group,
I had a database failure and tried to backup the last few
transactions in the log file using the no-truncate option
and it failed with the following error statement
"could not open fcb for invalid file ID 0 in database ..."
I am running SQL Server Enterprise Edition on Windows 2000
Server with SP 4 installed.
SQL Server has SP3 installed.
I have never seen this problem previously.
Just before I tried this operation I installed the latest
Windows Updates for Windows 2000.
Any thoughts.
David Watkins
MCT MCSE MCDBAAre you certain that this isn't SQL7? In SQL7, you couldn't do this is the mdf file was lost. If
this indeed is SQL2K, and the ldf files are healthy, I suggest you open a case with MS...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"david watkins" <dwatkins@.pacific.net.au> wrote in message
news:2023001c458e2$c09526f0$a401280a@.phx.gbl...
> Dear Group,
> I had a database failure and tried to backup the last few
> transactions in the log file using the no-truncate option
> and it failed with the following error statement
> "could not open fcb for invalid file ID 0 in database ..."
> I am running SQL Server Enterprise Edition on Windows 2000
> Server with SP 4 installed.
> SQL Server has SP3 installed.
> I have never seen this problem previously.
> Just before I tried this operation I installed the latest
> Windows Updates for Windows 2000.
> Any thoughts.
> David Watkins
> MCT MCSE MCDBA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment