System.Data.Sqlclient.Sqlerror: - Backup, Recovery and Disaster Recovery

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » System.Data.Sqlclient.Sqlerror:

System.Data.Sqlclient.Sqlerror:

Options

Previous Topic · Next Topic

mohit.piscean

Posted: Thursday, April 03, 2008 11:21:20 PM

Rank: Newbie

Joined: 4/3/2008
Posts: 0
Points: 3
Location: delhi

Restore failed for the server 'HOME-561A7DCDE2/SQL'.(Microsoft.sqlserver.smo)
System.Data.Sqlclient.Sqlerror: the backup set a holds a backup of database other than the existing 'Transecure' database.(Microsoft.sqlserver.smo)

this message is coming when i m trying to restore my sql bakup(.bak file) to the sql server which i installed on my pc.
plese help me out

Scott Whigham

Posted: Friday, April 04, 2008 7:23:23 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

9 times out of 10 when I see this it is because someone has inadvertently backed up their database across 2 or more files. If you backed up to two files, you have to restore from two files.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.