How to restore backup file from sqlserver2005 to sqlserver2000?
-
Hi, Can any body suggest me how to take backup file from 2005 to 2000 in sql server. Ex: I have taken backup from Sql2005... I want to restore in 2000. Is it possible? If yes please suggest me. other wise is there any other way to do this task.
-
Hi, Can any body suggest me how to take backup file from 2005 to 2000 in sql server. Ex: I have taken backup from Sql2005... I want to restore in 2000. Is it possible? If yes please suggest me. other wise is there any other way to do this task.
Ashish Kumar Vyas wrote:
Can any body suggest me how to take backup file from 2005 to 2000 in sql server.
You cannot.
Ashish Kumar Vyas wrote:
is there any other way to do this task.
You could look for a scripting tool. Modify the script to remove any SQL Server 2005 enhancements then run the script on SQL Server 2000 - It is still risky though.
Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog
-
Hi, Can any body suggest me how to take backup file from 2005 to 2000 in sql server. Ex: I have taken backup from Sql2005... I want to restore in 2000. Is it possible? If yes please suggest me. other wise is there any other way to do this task.
i think you can not directly restore bak from SQL 2005 to 2000 but if you dont want data n want only structure n procedures of database den u can use Generate script
-
i think you can not directly restore bak from SQL 2005 to 2000 but if you dont want data n want only structure n procedures of database den u can use Generate script
thanx for replying... but I need data too..
-
thanx for replying... but I need data too..
here is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000: 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 check it out i hope dis will work 4 u
Reasons are not Important but Results are Important
modified on Tuesday, August 19, 2008 7:12 AM
-
here is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000: 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 check it out i hope dis will work 4 u
Reasons are not Important but Results are Important
modified on Tuesday, August 19, 2008 7:12 AM
-
No offence but
Tripathi Swati wrote:
hope dis will work 4 u
must be Hope this will work for you.
I Love T-SQL "Don't torture yourself,let the life to do it for you."
[Message Deleted]
-
[Message Deleted]
-
here is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000: 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 check it out i hope dis will work 4 u
Reasons are not Important but Results are Important
modified on Tuesday, August 19, 2008 7:12 AM
Thanx a lot for your valuable suggestion... is it working for sql server 2005 express edition. I have express edition.. can u assist me for express edition.
-
Thanx a lot for your valuable suggestion... is it working for sql server 2005 express edition. I have express edition.. can u assist me for express edition.
In express edition you can not restore.
Reasons are not Important but Results are Important. Swati
-
In express edition you can not restore.
Reasons are not Important but Results are Important. Swati