VSS Backup SQLWriter failure
Posted on 2010-09-16
I have a Windows 2008 SP2 server that is running a DotnetNuke website with a SQLExpress 2005 database. Here is the conneciton string in the web.config file...
connectionstring="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providername="System.Data.SQLClient"
This server is a Virtual Server on a Windows 2008R2 Hyper-V host. When I try to run a backup of the VM from the host, I get a VSS error related to the DotNetNuke server.
When I examine the event logs on the DotNetNuke server, I see Event ID 24583, Source SQLWriter, with an error message stating "Error Message: Unable to open the physical file 'c:\websites\dotnetnuke\app_data\datebase.mdf'. Operating system error 3 '3(the system cannot find the file specified)'"
The reason it can't find the file specified is because it is not in that location. The base DotnetNuke install created the path and placed the database.mdf file there originally but I later renamed the folder to "C:\Websites\LSSCSupport". The site has been running for months but this problem just started happening because we are now using a different backup process. I don't want to rename the folder back to DotNetNuke because it is now referenced in a lot of locations within the project.
I can't tell where the SQLWriter is getting the old path "C:\Websites\DotnetNuke" so that I can correct it.