Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

detach and attach Expand / Collapse
Author
Message
Posted Thursday, August 20, 2009 4:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499
i need to detach and attach system database from another server..is it possible
Post #774105
Posted Thursday, August 20, 2009 5:05 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:27 AM
Points: 462, Visits: 148
There is no option available to detach system database, but you can restore the system databases from backup.

AQKhan
Post #774114
Posted Thursday, August 20, 2009 5:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 40,438, Visits: 36,894
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 2008, MVP
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

Post #774129
Posted Thursday, August 20, 2009 7:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 20, 2014 6:35 PM
Points: 93, Visits: 338
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
Post #774198
Posted Thursday, August 20, 2009 6:59 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
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
Post #774708
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse