Post reply

"attach" sql2000 db on a new sql2005 ??

  • May 22, 2006 at 7:18 am

    #112923

    hi

    i'm running SQL2000 over Win2000 AdServer

    i need to upgrade to SQL2005 over Win2003 Server

    if i format the OS partition

    and then install both Win2003 Server and SQL2005,

    can i simply "ATTACH" my SQL2000 databases

    to the new SQL2005 ??

    what's the way ?

    thanks

  • May 22, 2006 at 10:22 am

    #639319

    I've checked this and it works, you can deattach database from sql 2000 and attach on sql 2005.

  • May 22, 2006 at 11:08 am

    #639331

    i'm formatting the OS partition

    and installing OS and SQL again,

    am i still need to dettach the dbs ?

  • May 22, 2006 at 3:40 pm

    #639381

    Yes, do detach the databases first. SQL Server 2005 Books Online (BOL) states the following in the Remarks section of the sp_attach_db reference: "The sp_attach_db stored procedure should only be executed on databases that were previously detached from the database server by using an explicit sp_detach_db operation or on copied databases." It may work without performing the sp_detach_db, but it's not a chance I'd care to take.

    Steve


    This posting is provided "AS IS" with no warranties, and confers no rights.

  • May 23, 2006 at 5:59 am

    #639466

    ok

    thanks for your post

Viewing 5 posts - 1 through 4 (of 4 total)

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