import a backup to SqlServer 2005

Hi,
this might be a pretty ovious question but anyhow
I created a backup file of my Databases in SQLserver 2000
How can i load these into SqlSErver 2005 that I just installed
I always seem to get errors...
thxYes, it is possible to restore a SQL 2000 backup to SQL 2005. The database
will be upgraded to 2005 during the process. What errors are you getting?
Consider using the SQL Server 2005 Upgrade Adviser to analyze the
database(s) before the upgrade. SQL 2005 is a major release and some
applications may be affected by breaking changes. Be sure to peruse the
Upgrading to SQL Server 2005 topic in the Books Online
<ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/f7e79c63-875a-446c-9860
-439486928ba1.htm>.
Hope this helps.
Dan Guzman
SQL Server MVP
"benoit" <benoit@.discussions.microsoft.com> wrote in message
news:0E4CAC91-B775-4B1E-A256-B1652479CE5C@.microsoft.com...
> Hi,
> this might be a pretty ovious question but anyhow
> I created a backup file of my Databases in SQLserver 2000
> How can i load these into SqlSErver 2005 that I just installed
> I always seem to get errors...
> thx|||Thx
in meantime i got it working
I was getting the error that i was restoring the data from another database
and that it could not work
but by overwriting the destination DB it worked fine and all data is fully
operational
thanx anyway..
"Dan Guzman" wrote:

> Yes, it is possible to restore a SQL 2000 backup to SQL 2005. The databas
e
> will be upgraded to 2005 during the process. What errors are you getting?
> Consider using the SQL Server 2005 Upgrade Adviser to analyze the
> database(s) before the upgrade. SQL 2005 is a major release and some
> applications may be affected by breaking changes. Be sure to peruse the
> Upgrading to SQL Server 2005 topic in the Books Online
> <ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/f7e79c63-875a-446c-98
60-439486928ba1.htm>.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "benoit" <benoit@.discussions.microsoft.com> wrote in message
> news:0E4CAC91-B775-4B1E-A256-B1652479CE5C@.microsoft.com...
>
>