Issue with Restore database in sql server

Submit Blog |

Blogs Home |

Ads

While restoring the database I got a peculiar issue and started googling for the same. Got a link from Microsof BOL about this issue.

http://msdn.microsoft.com/en-us/library/bb283410.aspx

Reason for this issue: You are trying to restore the database on the existing database.

SQL Server is thinking that the new restore database is a tail database for the existing database available in the system . Due to this, it's trying to check for the tail end.

Solution : We need to delete the existing one and add the new one

or else Goto the options page of the restore window and you need to select the option "overwrite the existing database (With replace )

Cheers,

Venkatesan Prabu .J

Head, KaaShiv InfoTech

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx

Found interesting? Add this to:

| More | Bookmark It

More Blogs from Jvprabhusanthi

More ...

About Venkatesan Jayakantham

Experience:	9 year(s)
Home page:	http://www.dotnetfunda.com
Member since:	Tuesday, May 01, 2012
Level:	Starter
Status:	[Member]
Biography:

>> Write Response - Respond to this post and get points

More Blogs
	SeriesCollection Convert Varchar to Xml in Sql Server Insert XML data into SQL Server Pivoting in SQL Server Convert String to ASCII in C# Control one item check in CheckedListBox Operator cannot be applied to operands of type 'decimal' and 'double' Sorting Data in C# DataTable XML for Analysis Parser Submit Blog \| More ...