IMporting sql2000 backup database ?

Dear all,
I have an database backup from SQL server2000.
How can I import it inside SQL server 2005 ?
regards
serge
serge calderara wrote:
> Dear all,
> I have an database backup from SQL server2000.
> How can I import it inside SQL server 2005 ?
> regards
> serge
Use the RESTORE DATABASE command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||here is how I am proceedig.
First I have creat a new database named NOMOS, same as my old backup. Only
system tables are created here as I want to restore the whol configuration
from my backup.
Then I select the Restore backup from management studio and select my new
created database NOMOS as the destination and my backup file as a source
Then I get error message :
"The backup sets hold a backup of a database other than the existing 'NOMOS'
database"
Which is not treu casue I just made the backup of that databased before
installing 2005 ?
thnaks for comments
regards
serge
"Tracy McKibben" wrote:

> serge calderara wrote:
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||Sorry I find it out...
I forgot to set the overwrite option
:-)
"Tracy McKibben" wrote:

> serge calderara wrote:
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>