Post reply

Linked server setup

  • June 2, 2010 at 7:14 pm

    #145163

    I need to move a linked server from one server to another. For this, should I just script it out and run it on the new server?

    Do I need to do anything else?

    Thanks everyone.

  • June 2, 2010 at 9:25 pm

    #1175672

    Scripting it out will do MOST of what you need. You will find that SQL does not script out ANY passwords, so you will need to change the scripted password with the actual one.

    Other than that, what SQL scripts out has always worked for me.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

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

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