incubator140 Posted April 27, 2010 Share Posted April 27, 2010 hi, When i tried to restore DB using SQL Server 2005, am getting errors as follows. TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'INC133'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The backup set holds a backup of a database other than the existing 'LenderDetails' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Can anyone help me? Thank, Bindi. Quote Link to comment https://forums.phpfreaks.com/topic/199885-error-of-database-restore-to-backup-file/ Share on other sites More sharing options...
Brian Swan Posted April 27, 2010 Share Posted April 27, 2010 Bindi- I wrote a blog post about backing up a SQL Server Database from PHP: http://blogs.msdn.com/brian_swan/archive/2010/04/06/backup-and-restore-with-the-sql-server-driver-for-php.aspx This might not be exactly what you are looking for, but it might help. If it isn't helpful, let me know and I'll see what I can do. Thanks. -Brian Quote Link to comment https://forums.phpfreaks.com/topic/199885-error-of-database-restore-to-backup-file/#findComment-1049344 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.