SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Server Backups


Report Server Backups

Author
Message
Bobby Glover
Bobby Glover
SSC Eights!
SSC Eights! (825 reputation)SSC Eights! (825 reputation)SSC Eights! (825 reputation)SSC Eights! (825 reputation)SSC Eights! (825 reputation)SSC Eights! (825 reputation)SSC Eights! (825 reputation)SSC Eights! (825 reputation)

Group: General Forum Members
Points: 825 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.
emile.milne
emile.milne
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 224
Not sure?
emile.milne
emile.milne
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 224
Normal backup works fine for me.
With COPY is prefered by MS but not essential. It's not a show stopper.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search