LearnItFirst User Forum

 SQL Server 2008 SSAS Training Videos
Welcome Guest Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » 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
Where do you live?: 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
Back to top
 
Scott Whigham
Posted: Friday, April 04, 2008 7:23:23 AM


Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: 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.
Back to top
Web  
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.

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.