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.SqlE rror: 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
System.Data.SqlClient.SqlE
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
dtodd is correct, my answer is the same, I just presumed you use "Management Studio"
Just tried to add my two cents :)
Cheers,
Co
Just tried to add my two cents :)
Cheers,
Co
ASKER
Many thanks for the excellent solutions.
With kind Regards
With kind Regards
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