detach and attach

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

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

    AQKhan

  • 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
  • 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

  • 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