July 30, 2008 at 9:12 am
Hey Guys,
I have multiple servers running - a Web Server and a number of Database servers. Our Web Server runs all of our services etc and on the SQL Server instance of this server, we have a master "Registration" and "User" database. These databases have important SPs and tables that every database from the DB Servers need to be able to access. At current, i am creating a "blank" registration and user database on each Database server, creating synonyms for the tables on the Web Server (obviously linking the servers) and then manually copying the SPs and Functions over to the DB servers.
My question is really as to whether there is a way around having to copy the SPs and Functions everytime we add a DB server? I know its not a MASSIVE deal and its not TOO often that a new DB server is added but would still make things simpler. Its just a pain to have to do this every time.
Thanks in advance 🙂
July 30, 2008 at 9:29 am
You can create synonyms for procedures and functions also, but I think the easiest solution for you would be to restore a backup of your user and registration databases from another server that is using the synonyms. Instead of copying everything individually, copy the entire database. As long as the linked server name is the same, it should be fine.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply