none
Unable to open the physical file RRS feed

  • 问题

  • HI,

    I got a strange problem when backuping my wwwroot folder with backup server on window2008 r2.

    I have sql express 2008 r2. Backup database fail with "Unable to open the physical file D:\wwwroot\App_Data\MyShop.mdf". But I don't have this file at that folder at all. I deployed my website to this folder before but I already removed my website. So I guess sql server remember something invalid information. What can I do ? reinstall sql doesn't help...

    The error in event log for sqlwriter is:

    Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
    Error state: 1, Severity: 16
    Source: Microsoft SQL Server Native Client 10.0
    Error message: BACKUP DATABASE is terminating abnormally.
    SQLSTATE: 42000, Native Error: 5120
    Error state: 101, Severity: 16
    Source: Microsoft SQL Server Native Client 10.0
    Error message: Unable to open the physical file "D:\wwwroot\App_Data\MyShop.mdf". Operating system error 3: "3(failed to retrieve text for this error. Reason: 15105)".

    2011年9月18日 16:08

答案

  • Just to update this in case other people has the same problem.

    I end up to change to SQL standard version. And use server connection instead of using the mdf file directly in connection string. And everything works fine.

    • 已标记为答案 supcxc 2011年11月3日 2:40
    2011年11月3日 2:40

全部回复