Error occuring when seeking to backup of transaction log with no_truncate

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

Error Msg with backup

I am getting an error msg:
BackupMedium::ReportIoError : write failure on backup device 'D:\MSSQL$DBSQL4A\L
thats all I can see. Now thi is been running for a few weeks with no problem. Untill yesterday.
Any help appreciated.the D drive on the server may be full
You may have too many backups out there?

Just a thought.|||I did have little space there but I blew away some old backups and free up some space. Looking at previous stuff it has enough space but its still coming back with the same error.|||try saving in other location
maybe it helps|||check the event viewer on the server for both system and application errors.|||Thanks I got the issue resolved. I have deleted 2 of 5 previous backups and it worked. But it still had more than enough space before that. So I got it figured oout for now.
Thanks

Error messages of return codes of SQL installer

Hi all,

I have one application through which i m installing SQL Server 2005 Express Edition.

If some failure occures, all I get is one exitCode which is a return code of SQL Express installer. Is there any way by which I can find out the exact reason of failure.

One example is error code 28062.

This error code is for "sql is unable to install on compressed folder / drive".

Please help

Thanks and regards,

-Anup

Are you using either encrypted or compressed drives where you want to install the edition on ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error message SQL server

I have recently installed SQL server and keep getting this
error message. Error #-2147467256 (Description: connection
failure) (Source: Microsift OLE DB Provider for SQL Server)
(Module: basEH.bas)(Procedure:
General_EHProcessContinuousEVENTS)
Can anyone spread a bit of light on what to do?
Thanks,
MikeHi:
It does not seems that it is a error of SQL or OLEDB, I guest it is
caused by (Module: basEH.bas)(Procedure:
General_EHProcessContinuousEVENTS).
According the Error #-2147467256, I look up KB and get the article list
below.
http://support.microsoft.com/default.aspx?scid=KB;en-us;270061
It says thet this error caused by
"The callee (server [not server application]) is not available and
disappeared; all connections are invalid. The call did not execute. "
So I suggest you check thw connect string and see if it work.
Best Wishes
Wei Ci Zhou