SQL 2000 BackUp files not supporting to restoring SQL 2005

[riyazrasheed1234]

Hi

Any one is there to help me?

I got stuck migrating SQL Server 2000 to SQL 2005 I have many data in SQL 2000 I create backup file but SQL 2005 is not supporting backup file to restore to SQL 2005.

regards,
Riyaz

[Purple]

Hi riyazrasheed123 4,

An approach I have used which works is to detach the sql2000 database, copy the mdf and ldf database files and reattach the to sql2000.

move the copied mdf and ldf files to the sql2005 data folder and then attach these in sql server management studio.

obviously this will be a challenging in a high availability environment..

Regards Purple

[riyazrasheed1234]

Hi riyazrasheed123 4,

An approach I have used which works is to detach the sql2000 database, copy the mdf and ldf database files and reattach the to sql2000.

move the copied mdf and ldf files to the sql2005 data folder and then attach these in sql server management studio.

obviously this will be a challenging in a high availability environment..

Regards Purple

Thanks parple,
Thanks for your help!

[Purple]

Hey the name is Purple :)

Pleased it worked for you.

Regards Purple