.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sql 2005 express restore problem

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server


i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :



TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'CLIENT193\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476


System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'MedicalStore' database. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476






pls some one can help me ???



View Complete Post

More Related Resource Links

sql server express 2005 9.0.2047 - problem RESTORE VERIFYONLY FROM DISK


Hi all

every time I try to verify the backup file I get the error:

backup set on file '1' is not valid (translated from italian).

this is my backup script:

BACKUP DATABASE [ahr_sistema] TO DISK = N'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ahr_sistema\ahr_sistema_backup_1.bak' WITH FORMAT, INIT, NAME = N'ahr_sistema-Completo Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10


declare @backupSetId as int

select @backupSetId = position from msdb..backupset where database_name=N'ahr_sistema' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'ahr_sistema' )

if @backupSetId is null begin raiserror(N'Verifica non riuscita. Impossibile trovare le informazioni di backup per il database ''ahr_sistema''.', 16, 1) end

RESTORE VERIFYONLY FROM DISK = N'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ahr_sistema\ahr_sistema_backup_1.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND


Restore Failed for Server: SQL Express 2005


I am moving my data base from one computer to a new one. I placed the .bak file in the backup folder on the new computer (Windows Vista). I keep getting these errors I have checked the security settings and my user account has full privledges. I added my windows login to the SQL Administrators as well.

Here is the error msg.:  TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'laptop\sqlexpress'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476


System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)'

Connectivity problem between MS Access 2007 and SQL Server Express 2005


I have linked my tables, in SQL Server Express 2005, to MS Access 2007 and created a File DSN named LocalSQLServer.dsn. Both the front end (MS Access 2007) and the back end (SQL Express 2005) are on the same machine.

I am trying to check an open connection , and for that I have written a module -- Function CheckConnection(strFileDSNName As String, _

      strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean

strConnect = "Provider=ODBC" & _

";FILE DSN =" & strFileDSNName & _

";Database=" & strDBName


I have created a form with a command button to check the connection, but it is giving the following error

"-2147467259; Method 'Close Connection' of Object'_CurrentProject failed


I am not able to figure it out, if the Connection Parameters that I have taken are correct or not. Please help me in this.



Problem with SQL Express 2005 installed on Windows 7


Hi All, I am facing problem with SQL Express 2005 ..i installed SQL Express ToolKit 2005 in my laptop having Windows 7 and when i opening SQL Express management studio....it did not give my PC name in "Server name" option..

could anyone advise what could be the problem...

Pls Advise


-- Regards Sandeep

Restore Problem with 2005 ..But working in 2008


Hi all,

 I am getting problem while restoring the backup file and getting "SQL Server cannot process this media family " error on SQL Server 2005. but It SUCCESSFULLY restored on SQL Server 2008. But the customer is telling this is 2005 backup and should be restored on SQL Server 2005. I executed RESTORE VERIFYONLY FROM DISK on both 2005 and 2008. In 2005 it gave media related error ...and 2008 it didn't though error. Please suggest what would be the problem..

-- Reddy Balaji C. ##Mark as answer if it solves the issue

SMO 2005 Express Problem in Window 7


Hello, why in window xp the restore and backup is ok.. and when it comes on window 7 the backup is ok.. but the restore.. is failed,

this is my backup codes

          // Create a new backup operation
          Backup bkpDatabase = new Backup();
          // Set the backup type to a database backup
          bkpDatabase.Action = BackupActionType.Database;
          // Set the database that we want to perform a backup on
          bkpDatabase.Database = cmbDatabase.SelectedItem.ToString();

          // Set the backup device to a file
          BackupDeviceItem bkpDevice = new BackupDeviceItem(saveBackupDialog.FileName, DeviceType.File);
          // Add the backup device to the backup
          // Perform the backup

this is my restore codes

 		  // Create a new database restore operation
          Restore rstDatabase = new Restore();
          // Set the restore type to a database restore
          rstDatabase.Action = RestoreActionType.Database;
          // Set the database that we want to perform the restore on
          rstDatabase.Database = cmbDatabase.SelectedItem.ToString();

          // Set the backup device from which we want to restore, to a file

sql server 2005 express and c# 2008 express connection problem



I can't get my C# app to connect to the DB.  I have tried numerous diff ways to connect.  The DB is there, I can get to it thru sql server, just not from C#.  I keep getting the following message -

Error accessing the database, a network-related or instance-specific error occurred while establishing a connection to sql server.  The sever was not found or was not accessible.  Verify that the instance name is correct and that sql server is configured to allow remote connections. Provider: sql network interfaces, error 26 - error locating server / instance specified.

All is on my home PC running XP Home Edition.


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Upgrading VS 2003 Project File to VB Express Edition 2005



I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

Restore - Cube Analysis Services 2005

Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

sql server 2005 express - don't allow to create table

i have downloaded sql server 2005 Express version from the web and use domainname\SQLEXPRESS as server name but now i can't create table seems every create by sa user, what is the password of this user or how to grand right to my window login user so that i can modify/create something in database.

Deploying problem with SQL Express 2008 R2

Scientific software package works fine with SQL Express 2008 R2 on developing (mother) PC and Admin login mode, but difficulties are found elsewhere during installing and deploying on the client PCs.  We have used from year 2000 BDE (Borland Database Engine), which worked fine until now, but recently customers had been installing problems with Vista, Windows 7 and the local administration rights or permissions.   Thus I thought to test NT AUTHORITY\NETWORK SERVICE authentication, as this system is hopefully working again decades with coming new Windows versions. As not need to touch databases, ADO and authentication matters during last decade, I’m newbie with those topics.  Worked now few days with this problem, installed and unistalled SQL servers according to instructions, tested different connecting strings and now cannot found correction.  Solution is maybe and hopefully simple.   Attached is log data cut from (old and many times corrected) the main mother XP platform in Admin and Client (Guest) modes.  Same tests are done also with fresh XP installation on VirtualBox.  Used connecting strings are presented inside log files:           Main mother XP at Admin login:   2010-08-20 08:24:45.82 Server      Server local connection provider is ready to accept connection on [ \\.\pip

SQL 2005 Database Problem

When trying open up a report from a customer database.  I recieved the following error: Please contact technical support with the following information:   Error ID: ERHIG030000340 Error message: There was a problem with the SQL or table when trying to open the display The table name is "taOrderHistory" The SQL is: Underlying problem: Column 'taOrderHistory.OrderHistoryID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at RadWebNet.rwDataSupport.OpenData(String SQLIn, rwConnection ConnIn, OpenDSReturnType ReturnWhat, Int32 TimeOut, Object[] ParamsIn) in D:\Misc Projects\RadWeb\RadwebV4-7-1\rwData.v

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Multiple XML files into SQL SERVER Express 2005

Hello. I am familiar with classic ASP and use this with MS SQL SERVER EXPRESS. I have an SQL table and want to import multiple XML files into this on a daily basis. I currently have 3 files, transferdata.vbs which loops through the XML files. FAQschema.xml which maps XML to the SQL database and test.xml shows the xml in the test file. If I run transferdata.vbs I get the following error "Error opening the data file" line 33 char 3. Microsoft Bulkload for SQL Server". My SQL table is called EnqOrd id (int), Debitor (varchar), PurchaseDate (varchar)     transferdata.vbs set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "Provider=SQLOLEDB; Data Source=XXXXXX\XXXXX; Initial Catalog=XXXX; User ID=XXXXX; Password=XXXXXX" objBL.ErrorLogFile = "E:\fuelsql\Teccom\error.log" ' Here is the path to your XML files Const path = "E:\fuelsql\Teccom\XML\" Dim Text, Title, oFile Dim fso, oFolder, oFiles, wsh ' Object variables Text = "Folder " Title = "XML Files" Set wsh = WScript.CreateObject("WScript.Shell") ' Create FileSystemObject object to access the file system. Set fso = CreateObject("Scripting.FileSystemObject") ' Get Folder object. Set oFolder = fso.GetFolder(wsh.ExpandEnvironmentStrings(path)) ' Get All Files Set oFiles = oFolder.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend