Post reply

Server move

  • October 14, 2011 at 1:28 am

    #246480

    For a variety of reasons, we are rebuilding one of the production servers into a new domain. Due to the nature of some of the problems that we have, it has been decided to build the new server and copy / move the data across via backup / restore, copy database or whatever. That part of it I am happy with (even if it is for 100 + databases).

    My main concern is that the server is also used for Reporting services. Will it be sufficient for the new server to have IIS and reporting services installed and restore the existing ReportServer database for all to work again, or am I being too simplistic?

    I won't be able to check for any replies over the next few days, I will though give any further info when I can

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • October 14, 2011 at 8:53 am

    #1394684

    use reporting service scripter to extract all objects and then import to the new instance.

    http://www.sqldbatips.com/showarticle.asp?ID=62

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 14, 2011 at 9:52 am

    #1394735

    Thanks for that I'll give it a go in Dev

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply