restoration at sql 2005 from sql 2000 backup.

[Former Member]

Hi experts,

Is it possible to restore a backup taken from sql 2000 database to sql 2005 database?

And how about attaching datafiles of sql2000 into sql 2005 server?

Thanks and Regards,

Amit Jana.

[Former Member · Accepted solution]

> Is it possible to restore a backup taken from sql 2000 database to sql 2005 database?

Yes its possible.

> And how about attaching datafiles of sql2000 into sql 2005 server?

Same method of attach/deattach.

But recommanded you first install 2000 instance restore database and do inplace sql 2005 upgrade.

Why you can't follow recommanded mothed ?

Regards,

Nikunj Thaker

[Former Member]

Hi,

The restoration has been completed successfully.

Thank you for your suggestions.

Regards,

Amit jana.