Solved

SQL Server Client Network Utility

Posted on 2004-09-06
5
356 Views
Last Modified: 2012-05-05
Hello Buddies

I want to open a debate on SQL Server Client Network Utility. What are the strong points and limitions using this technique to use database alias.

Let me describe my position.. i am having 2 servers

1 Application Server (named SIRUS)
2 Database Server (named ORION)

i am running hundreds of applications on SIRUS which is using database named ORION. Now what i want to do is to merge both these servers by putting one strong machine instead of 2 to be used as application as well as database server.

Now my problem is if i name new machine as ORION.. then i have to change all the physical paths of hundreds of applications which is practically not possiblem.. and if i name this new machin as SIRUS than i have to chnage database name of my hundreds of application..which is again not possible.. now i m working on possiblity if i name my mahcin as SIRUS and the database name on this machine as ORION..

@ram has given me idea to use  SQL Server Client Network Utility to create alias of database SIRUS with the name of ORION on the machine named SIRUS..

Now i want views from experts if i m using this structure, is there any limitations in it ?? i have some 10-12 machines in my network and i can create database alias on each of the machine.. is there a way if i can do sometihng only at server to create alias to be used in the network without doing anything with workstations ??

neeraj523
0
Comment
Question by:neeraj523
  • 2
  • 2
5 Comments
 
LVL 10

Accepted Solution

by:
AaronAbend earned 500 total points
ID: 11996461
I have used this technique and it works fine - just don't forget where you are when you launch a command!  As a helpful check, I put a database on the server that has the name of the server so it is very clear which server I am working on (e.g., I would create a 1mb database called "Sirus_Server" on Sirus.

0
 
LVL 10

Expert Comment

by:AaronAbend
ID: 11996487
By the way, I was pointed to this solution by Brett (arbert). Here is the PAQ I asked...

Q_20787347.html
0
 
LVL 22

Author Comment

by:neeraj523
ID: 12003185

hmm.. nice tip... thanx aron

still i will wait for more debate on this..
i don't want to get stuck later once i upgrade my network according to this structure.. i would like to know each and every issue i could face in it..

neeraj523
0
 
LVL 22

Author Comment

by:neeraj523
ID: 12197032

Thanx TheLearnedOne for reminding to close this question.. i guess now i can;'t expect any more debate on this topic..

anyway thanx a lot @Aaron for your valuable help..

neeraj523
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now