May 31, 2011 at 3:30 am
I have taken a complete backup of database "NiAccDb11" from SQL Management Studio.
When I try to restore backup to the same database on another server, I get the following error message
Restore failed for Server "SRV-NEWINDIA" (Microsoft.SqlServer.SmoExteded)
Additional Information:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing "NiAccdb11" database. (Micorsoft.SqlServer.Smo)
How can I overcome this error message.
May 31, 2011 at 3:34 am
Do you already have a database called 'NiAccdb11' on the server?
You could use with replace on the restore or restore the dataabse to a new name.
May 31, 2011 at 5:20 am
In the Option TAB of Restore,check the Overwrite on the Exising Database or check the space is available for restore database in the drive you mentioned
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply