InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 16:07:59 GMT20http://www.sqlservercentral.com/Forums/Topic1066332-357-1.aspxFrom object explorer, attach database, select the files, give it a new name, click ok.Fri, 18 Feb 2011 12:31:48 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1066332-357-1.aspxWhile performing the step :attach those copied files as a user database.Fri, 18 Feb 2011 10:05:55 GMTaby_dvdhttp://www.sqlservercentral.com/Forums/Topic1066332-357-1.aspxAt what point?I've done exactly what I told you to do, so I know it does work.Fri, 18 Feb 2011 07:02:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1066332-357-1.aspxI followed the steps but i am getting an error message which says :You cant perform this operation for the resource database error :4616Fri, 18 Feb 2011 07:00:11 GMTaby_dvdhttp://www.sqlservercentral.com/Forums/Topic1066332-357-1.aspx[quote][b]abhishek_dwivedi03 (2/18/2011)[/b][hr]I want to restore it with a different name ao that i am able to see the data present in the database .[/quote]Shut down SQL, take a copy of the mdf and ldf files, restart SQL then attach those copied files as a user database. You cannot take a SQL backup of the system resource DB as it is hidden.There's not much data in there, far more it's procedures, views, functions and the like.Fri, 18 Feb 2011 06:46:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1066332-357-1.aspxHi I want to backup resource database ( hidden database ) in my base machine ( sql server 2005 ) .I want to restore it with a different name ao that i am able to see the data present in the database .Pls guide me .I came across an article in the link : http://www.mssqltips.com/tip.asp?tip=1544 .I tried doing it that way using the xcopy command but it just copied the mdf and ldf files for me to a different location .How is it same as the backup ? < as mentioned in the article > Regards,Abhishek Dwivedi.Fri, 18 Feb 2011 06:36:52 GMTaby_dvd