Post reply

sqlserver2000 restore

  • June 5, 2006 at 11:58 pm

    #113366

    Hi

    I currently hold the backup of the sqlserver 2005 database and would like to restore the same on the sqlserver2000 box. Can any one please let me know whether it is possible... if so, what should be the steps that needs to be followed?

     

    thanx in advance.

     

    Thanks & Regards,

    Narayan 

  • June 6, 2006 at 2:47 am

    #641885

    Hi.

    You'll need to restore your backup to a SQL 2005 instance.  From there you could generate script to recreate all of your tables, views, stored procs, triggers, functions, constraints, etc.  Then use DTS from SQL 2000 (or SSIS from 2005) to transfer the data - you could also use bcp or a similar utility or set up one server as a linked server from the other and insert the data that way.  In any case, transfer the data before creating your foreign key constraints to make life easier

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply