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

Report Server Backups Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 11:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
I have recently moved RS dbs to test servers using the detach and reaatach method.
What I didn't realise is that using the normal daily backups of my RS dbs couldn't be used on the new server.

Am I correct in thinking that if I needed to perform a rebuild of the LIVE server on new hardware ie the LIVE server is unobtainable.

1 . Previous backup of encryption key will be needed.
2. Backup of REPORTING SERVICES will be needed, which have been backed up using the WITH COPY ONLY method.
3 Restore DBs on New server.
4 Configure via RS Config tool, restore encryption key etc.

If I am correct, I imagine there are many DBAs backing up REPORTS db and REPORTSTEMPDB without the WITH COPY ONLY option and if they needed to rebuild a new server without the use of the current server they would be well and truely stuck.

Is this correct if so I have learnt something very valuable today.
Post #1398593
Posted Thursday, December 20, 2012 2:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Not sure?
Post #1398874
Posted Thursday, December 20, 2012 4:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Normal backup works fine for me.
With COPY is prefered by MS but not essential. It's not a show stopper.
Post #1398910
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse