Link to home
Start Free TrialLog in
Avatar of ihbemd6rb
ihbemd6rb

asked on

SqlServer 2008 Express- Problem Restoring a backup

Hello, I want to restore an old backup from express 2008 to express 2008. Made a new database, now I get the message:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'vDis' database. (Microsoft.SqlServer.Smo)
I can't remember the structut of the tables and data. Is there any way to find out how to design the new database to accept the old one?
Thanks
ASKER CERTIFIED SOLUTION
Avatar of David Todd
David Todd
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,

Just to clarify: My answer was based on you running scripts for everything; Co's answer was based on using a GUI. I believe that both of us are right.

What are you using to connect to/administer SQL 2008 Express? SQL Server Management Studio Express? or something else?

Cheers
  David
Avatar of Co
Co

dtodd is correct, my answer is the same, I just presumed you use "Management Studio"
Just tried to add my two cents :)

Cheers,

Co
Avatar of ihbemd6rb

ASKER

Many thanks for the excellent solutions.
With kind Regards