attatch the sqlserver2005 database

• lamia

  Newbie

  Points: 7

  More actions

  March 15, 2008 at 10:50 am

  #180196

  hi

  I want to attatch the sql server2005 database in the sqlsever2000

  how can i do it?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 15, 2008 at 10:53 am

  #790036

  Short answer, no. You can not attach a database from SQL Server 2005 to SQL Server 2000.

  😎

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  March 15, 2008 at 3:07 pm

  #790058

  What you can do is export your schema and data out to a SQL 2000 database, as long as you haven't used any 2005 features.

  Thanks

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005