Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 moving to SQL 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-05 : 08:15:13
jogy writes "SQLTeam on 2/3/2003 in The Topic
jogy writes "I am trying to move my sql2k-sp2 databases from one server to another.
I have sucessfully restored the master databse. When trying to restore other DBs I am getting the following error:
"could not open FCB for invalid file ID 2 in database "

Please help!!!" "

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-02-05 : 08:54:50
Could this be your problem
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&threadm=O%23SnhdQvCHA.2372%40TK2MSFTNGP12&rnum=5&prev=/groups%3Fq%3Dcould%2Bnot%2Bopen%2BFCB%2Bfor%2Binvalid%2Bfile%2BID%2B2%2Bin%2Bdatabase%2B%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26safe%3Doff%26selm%3DO%2523SnhdQvCHA.2372%2540TK2MSFTNGP12%26rnum%3D5

Go to Top of Page
   

- Advertisement -