Jump to content

Error of Database Restore To Backup file


Recommended Posts

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.

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.