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 ««12

copy system database files Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 8:48 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: Yesterday @ 3:37 PM
Points: 40,210, Visits: 36,619
Without shutting SQL Server down, you cannot copy the files of the system databases.


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 #1472189
Posted Friday, July 12, 2013 2:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Thanks!
Post #1472908
Posted Friday, July 12, 2013 3:13 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Take a sql backup of system database. Try to restore them in another instance with different database name.
Then deattach and copy the mdf, ldf file.

But I did not test this.
Post #1472913
Posted Sunday, July 14, 2013 9:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Thanks, This is what i did the last time when the master corrupted.
Post #1473426
Posted Monday, July 15, 2013 5:44 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 11:20 AM
Points: 554, Visits: 1,624
Do a set of system file backups (bak), then the next time you can stop the SQL Service, make copies of the MDF & LDF files.

I wouldn't trust a master database on Server1 after it had been restored to a Server2, even under a different name.
Post #1473931
Posted Monday, July 15, 2013 9:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Thanks :) But, how frequently should i take the backup of this actual files? I mean do they change over time? Can i just take a copy of them once every 6 months?

Or will it suffice to just have one set of copies irrespective of when it was copied over as so i can use it when necessary?


Thanks..
Post #1473962
Posted Tuesday, July 16, 2013 1:25 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: Yesterday @ 3:37 PM
Points: 40,210, Visits: 36,619
After a service pack installation. This isn't a replacement for database backups (which you need to do regularly). It's as well as.


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 #1474008
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse