There are two most common issues while restoring the database (usually ending in .bak format).
First error
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘user_database‘ database. (Microsoft.SqlServer.Express.Smo)
Solution for First error

System.Data.SqlClient.SqlError: Directory lookup for the file “D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\user_database.mdf” failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Express.Smo)
On an html page, one of our customers was getting this issue. Despite asking him to change the extension to .asp, he insisted to have html extension and still process the HTTP verbs, where it is POST method here.
Situation becomes like this a static page wants to be read a dynamic page and process the values obtaining from POST method. Solution is to make the .html read as .asp with asp dll, just like we do html parse as php in Linux boxes Here are the steps to do it on a Windows 2003 machine
1. Start –> Run –> inetmgr
2. Websites –> website/domain name in question
3. Right Click on the domain –> Properties –> Home Directory –> Configuration
4. In the tab Mappings –> Add an extension for .html and .htm , if it is missing (most cases it will be missing) and edit to add all verbs (POST, GET, HEAD are needed)
5. Fields to be added are as below,
Executable : C:\WINDOWS\system32\inetsrv\asp.dll
Extension : .html
Limit to : GET,HEAD,POST,TRACE
And Click Apply, OK
All is well !!
Customer wanted to have a dedicated IP, but once I change the IP from the plesk control panel, I couldn’t get the website when accessed using IP. Instead, it was giving me the plesk control panel’s default page. Reason ? Default Website was having the IP as “All Unassigned”. Set that to the main IP address. But after that I was getting a new error.
What I could get was “Bad Request (Invalid Hostname)” in bold letters. Here is what I did to fix the same.
Start -> Run -> inetmgr -> Expand the (+) -> Websites -> Right click on the domain name -> Take Properties -> Website -> IP Address (make sure that it has the dedicated IP assigned there) and then click “Advanced”
Add/Edit Web Site Identification
IP Address : Choose the dedicated IP from drop down list
TCP/IP Port : 80
Host Header Value : Leave it blank (Important)
Leaving the Host Header Value should fix the issue and fetch the website when accessing it using the IP.
Continue ReadingThis is common issue, but solutions varies based on situations. It could be one or a combination of a solutions listed below. If you had to go through another solution to solve it, please add it over here for others.
cd %plesk_bin%
websrvmng –update-anon-password –domain-name=domainname.com
Okay those are my current solutions.
Continue Reading