Post reply

detach and attach

  • August 20, 2009 at 4:45 am

    #208838

    i need to detach and attach system database from another server..is it possible

  • August 20, 2009 at 5:05 am

    #1042025

    There is no option available to detach system database, but you can restore the system databases from backup.

    AQKhan

  • August 20, 2009 at 5:46 am

    #1042038

    System database can never be detached.

    There are specific ways to restore backups of system databases, and it's different for the different system databases. Consult books online for full details.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 20, 2009 at 7:35 am

    #1042099

    Hi,

    You can reffer below BOL for restoring system databases.

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/0bc9eed6-3441-4b75-af02-2944d321daf7.htm

    Regards

    GURSETHI

  • August 20, 2009 at 6:59 pm

    #1042534

    You can detach the model and the msdb database (with trace flag 3608 (-T3608) but you shouldn't even try it as it won't allow you to attach again.

    See: http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/13428/sql-dont-start-after-detach-model-and-msdb

    MJ

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

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