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

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

sql server express 2005 9.0.2047 - problem RESTORE VERIFYONLY FROM DISK

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :Sql Server

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


View Complete Post

More Related Resource Links

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.)'

sql 2005 express restore problem



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 ???



Why does SQL Server 2005 Express SP3 prompt to insert next disk when run from CD?



Why does SQL Server 2005 Express SP3 prompt to insert next disk when run from CD?


Replication Steps:


1. Download SQL Server 2005 Express with SP3 (SQLEXPR.EXE)



2. Extract the SQLEXPR.EXE using the "/X" cmd line parameter to c:\DBEngine\SQLSP3\


3. Burn to CD c:\DBEngine\SQLSP3\


4. Install a XP 32bit test machine with SQL Server 2005 Express with SP1 as the default instance with this command





5. Attempt to upgrade the XP 32 bit test machine with the SP3 CD made above with the following command




During the upgrade the installat

Upgrade from SQL Server 9.0.2047 (Express 2005 SP1 I believe) to SP3


I am running the version of SQL I listed in the title and like I said, I believe it is SQL Express 2005 SP1 and I just want to upgrade to SP3.  I tried installing it via Microsoft Update, but that failed without giving me any detail as to why.  When I try to run the SQL Exp 2005 SP3 installer (SQLEXPR.EXE) it just acts like it is going to install a new instance of it.

I saw a post about an unattended upgrade, but frankly I'm not very familiar with that and not really comfortable with doing it.  Is there not an installer I can run that will just upgrade to SP3?

Thanks to anyone who can provide some assistance for me, I appreciate it.

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.



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!


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.

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.

SQL Server 2005 Express Edition Service Pack 3 (KB955706) update is successful but repeats installin

  Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1) This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

SQL Server Express 2005 SP3 Bootstrapper

Hi Guys,I am currently in the process of creating a bootstrapper for SQL2005 Express SP3 so I can slip it into a Visual Studio 2008 setup project.Here's what I did:1) I copied the SqlExpress-SP2 folder (C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\SqlExpress) into a new folder (C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\SqlExpressSP3)2) I replaced the eula.txt and sqlexpr32.exe with the new SP3 ones.3) I changed the following in product.xml:<Product xmlns="http://schemas.microsoft.com/developer/2004/01/bootstrapper" ProductCode="Microsoft.Sql.Server.Express.9.3">4) I changed the following in package.xml:<PackageFile Name="sqlexpr32.exe" HomeSite="SqlExprExeSP3" PublicKey="3082010A0282010100A2DB0A8DCFC2C1499BCDAA3A34AD23596BDB6CBE2122B794C8EAAEBFC6D526C232118BBCDA5D2CFB36561E152BAE8F0DDD14A36E284C7F163F41AC8D40B146880DD98194AD9706D05744765CEAF1FC0EE27F74A333CB74E5EFE361A17E03B745FFD53E12D5B0CA5E0DD07BF2B7130DFC606A2885758CB7ADBC85E817B490BEF516B6625DED11DF3AEE215B8BAF8073C345E3958977609BE7AD77C1378D33142F13DB62C9AE1AA94F9867ADD420393071E08D6746E2C61CF40D5074412FE805246A216B49B092C4B239C742A56D5C184AAB8FD78E833E780A47D8A4B28423C3E2F27B66B14A74BD26414B9C6114604E30C882F3D00B707CEE554D77D2085576810203010001"/>......    <Strings>        <String Name="DisplayNam

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Which SQL Server 2005 Express Edition Service Pack to Install?

I have Windows 2008 Small Business Server Standard Edition.  When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number.  I'm wondering which I should install, or if both, what order to install them in?  The first one is labeled: Microsoft SQL Server 2005 Express Edition Service Pack 3 The second one is labeled: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine.  The new upgrade for this software requires SP3 which is why I need to know which service pack to install.  Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition.  I know sometimes registry settings need to be changed for SQL service packs to be installed properly. Thank you for your help.  

Connection to SQL Server 2005 Express?

Hi all, I've been reading other posts for awhile now and I can't figure out what I'm doing wrong. I'm a Web Developer and not a DBA. I have SQL Server 2005 Express installed on my machine and it's working just fine. I also have the Management Studio Express CTP installed and working. I'm trying to connect to a database using a username and password (from ColdFusion Server which is working fine for external Oracle and Access databases, so that's not an issue), so I set up the server to allow mixed mode authentication. I can log in to the Management Studio using Windows authentication OR the username and password without any issues. I have TCP/IP enabled in the Configuration Manager and enabled. This seems like a ridiculous question, but I need to know the servername, port, username and password to connect to the database. I'm trying all combinations of things but nothing's working. If I put in as the server, 1433 as the port, and use the username and password that worked in Management Studio I get this: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect If I use MACHINENAME\SQLEXPRESS I get this: java.sql.SQLException: [Macromedia][SQLServer
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