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. 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 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
Archived
This topic is now archived and is closed to further replies.