how to restore bak file of sql 2005 to sql2000

[former_member637595]

we want to restaore a bak data base taken from sql2005 to sql 2000. we find that it is showing errorr that it cant restore more than 64 records.pls assist

[Former Member]

Hi Gangotri,

backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of SQL Server. The only way is do it through export / import - it may be direct from sql to sql. This will restore only data, so I recomend create new databse on sql 2000 and import through this database data from 05, otherwise you lost indexes, trigers, ...

hope it helps you

Petr

[former_member637595]

thank you , we have done restore bak file of sql 2005 to sql 2000

but problem is that when i am working in sap database its not working . some stored procedure are

locked .... could u tell me how to unlock this stored procedure?

we are maintaing following steps

Right-click on DB -> tasks -> generate scripts

select DB and click "script all objects...", hit next

select any options you want, specifically changing "script for server version" to SQL Server 2000

next through and run the script

Now just export data from the 2005 database to the newly-created 2000 database.

Right-click on DB -> tasks -> export...

set source and hit next

set destination and hit next

select "copy data from one or more tables", hit next

select all, check "optimize for many tables" and "run in a transaction"

you may have to edit each table mapping and check "enable identity insert"

next through to finish

plz help me?????

[Former Member]

Hi Gangotri,

how did you restore the data from 05 to 00? Throught restore option on sql server or as I mentioned? I`m asking because I never heard about possibility of restoring from 05 to 00 directly.

What you mean with locking of stored procedures? I guess, that you have created the stored procedures from script, but this will not set permission for execute, you have to set it manually.

Petr

[Former Member]

sorry, I overlook that you wrote how did you restore the data Try set the permissions to sp as I wrote before.

Petr