Because VS2010 needs to be installed, and all VS2008 and sql server2005 are uninstalled. and cleared the registry remnants. However, after installing VS2010, the SQL server 2008 instance cannot start normally. In the event log I see that there is
FCB::Open failed: 无法打开文件号 1 的文件 e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\model.mdf。操作系统错误: 3(系统找不到指定的路径。)。 Unable to create tempdb. There may not be enough free disk space. Please delete other files on the tempdb drive and restart SQL Server to free up more disk space. Check the event log for any other errors that indicate why the tempdb file could not be initialized.
I see, I cant do that because the Visual Studio 2010 RC comes with SQL Express RC2 and i dont want to go the trouble of uninstalling and re-installing over again. But anyway, i did able to solve by referring to the answer i found somewhere. it was by repacking the database by running:
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\setup.exe
with the following parameters
/ACTION=REBUILDDATABASE /INSTANCENAME=SQLEXPRESS /SQLSYSADMINACCOUNTS=<account name>
it fixed the invalid reference to that drive E:. Thanks for the info by the way, i will use that the next time I re-install the whole OS which i do often.
The translation is as follows:
I see, I can't do that because in Visual Studio 2010 RC RC2 with SQL Express I don't want to go through the hassle of uninstalling and reinstalling over and over again. But anyway, I was not able to solve it with reference to the answer I found somewhere. It is done by repacking, by running the database:
C:\Program Files\Microsoft SQL Server\100\Setup Boot\Release\SETUP.EXE
Use the following parameters
/ ACTION = REBUILDDATABASE/ INSTANCENAME= SQLEXPRESS/ SQLSYSADMINACCOUNTS=<帐户名称>
It fixes invalid references to that drive E:. Thanks for the info, I'll use the next time I reinstall the whole OS, which I do often.
|
Posted on 10/5/2015 5:57:31 PM
|
|
|
