Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sanjay_Bakshi
Starting Member
14 Posts |
 Posted - 2008-07-22 : 10:41:49
|
| Dear All,I have taken the backup of Pubs Database on SQL Server 2000 and trying to restore in SQL Server 2005.I am getting following error.System.Data.SQLClient.SQlError : the backup set holds a backup of a database than the existing 'pubs' Database Please help as today is my first day in SQL Server 2005Sanjay |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 10:48:32
|
| Are you sure you chose right backup set? Do backup one more time for Pubs and restore in SQL2005 with Move option? |
 |
|
|
Sanjay_Bakshi
Starting Member
14 Posts |
Posted - 2008-07-22 : 11:10:24
|
| In first time only i got this error.I have checked one site they are saying Use Force Option.But i am not geeing this option in SQL Server 2005Sanjay |
|
|
|
Sanjay_Bakshi
Starting Member
14 Posts |
Posted - 2008-07-22 : 11:31:10
|
| Solved thanks for supportSanjay |
|
|
|
|
|
|
Backup