Sql Server 2005, restore?

Glaucus · 19 Dec 2007 at 21:27

I'm trying to restore a database. I think it was made on sql server 2000

I'm getting the following error?

Anyone, know what it means

Stelly · 20 Dec 2007 at 11:27

if you are still having problems with this I know whats wrong mate

Stelly

Glaucus · 20 Dec 2007 at 16:56

Stelly said:
if you are still having problems with this I know whats wrong mate

Stelly

yep still having problems.

I assume it's because the database doesn't exist. So it can't restore. However how do you create a database from a bak up file.

huppy · 20 Dec 2007 at 17:12

Create a new database with the same name, and just leave it blank.

Then restore the database from the .bak, telling it to 'overwrite the existing database' in the options.

That works for me

Glaucus · 20 Dec 2007 at 17:17

tried that doesn't work.

Adz · 20 Dec 2007 at 17:24

Are you *sure* you have the overwrite option ticked (in the 'options' tab)?

Stelly · 20 Dec 2007 at 17:25

Yer he is right that should work, you just need a database called the same name...

Stelly

TrUz · 20 Dec 2007 at 17:25

When you select a .BAK file to restore a database from it will have the path of the original database. Make sure you change the path to match that of the new database you have created.

EDIT: Actually looking at the error again it does look like he has not ticked the option to overwrite the existing database.

TrUz

Glaucus · 20 Dec 2007 at 17:27

Doh'

Thanks guys. I didn't have the overwrite checked.

You can now call me N00bie..