Attaching LDF n MDF file of sql 2005 in SQL 2000

• satyam kumar

  Grasshopper

  Points: 12

  More actions

  March 28, 2006 at 10:40 pm

  #112309

  Hi,

   

  Pl help me to attach mdf and ldf file of sql 2005 with password protected in my sql 2000 server.

   

  Pl help me

  ---

  Kindest Regards,

  satyam kumar

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  March 29, 2006 at 6:27 am

  #629460

  Satyam,

  There is no backward compatibility with sql 2005.

  You cannot Attach or Restore sql2005 db to sql2000.

  The only available option is SSIS to import/export data from

  2005 to 2000.

  Hope this helps,

   

   

   

   

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com