'"Error 5180: Could not open FCB for invalid file id : 120"
When we attach the mdf and ldf files we get this error, what can we do to restore the database?
SEe this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;815183 to fix.'"Error 5180: Could not open FCB for invalid file id : 120"
When we attach the mdf and ldf files we get this error, what can we do to restore the database?
SEe this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;815183 to fix.'"Error 5180: Could not open FCB for invalid file id : 120"
When we attach the mdf and ldf files we get this error, what can we do to restore the database?
SEe this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;815183 to fix.|||I de-tached and then attempted reattached a database from my server. I was not able to reattached, so I changed the name of the old database file by adding an X to the end. I then created a new database with the same name as the old one, deleted the new database file, and then renamed the old file by removing the X. Now when I try to open tables or veiws, I get error 5180: Could not open FCB... I followed the link to the suggestion about parallelism, ran the code, and still have the problem. I am running SQL Server 2000, but I don't know about the service packs.
http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
I have the same error and did the same thing according to your link. Thx.
|||You said everything is fine except one application which you don't originally own. Can you post the connection string used by the application? Are you able to connect to the same server using SQL Management Studio? Are you app using .Net, SNAC(sqlncli), or MDAC? Thanks.
|||I must ask your forgiveness. I realize now that I there were two connection strings. One for regular database usage, the other for Session state, it seems. After changing the other I am able to connect to my local one. Thank you for your reply.
http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
I have the same error and did the same thing according to your link. Thx.
|||You said everything is fine except one application which you don't originally own. Can you post the connection string used by the application? Are you able to connect to the same server using SQL Management Studio? Are you app using .Net, SNAC(sqlncli), or MDAC? Thanks.
|||I must ask your forgiveness. I realize now that I there were two connection strings. One for regular database usage, the other for Session state, it seems. After changing the other I am able to connect to my local one. Thank you for your reply.
Error 207,Sql Error