I have a remote hosting environment which includes two machines - a web server and an ms sql server. The sql machine uses an internal IP 192.168.0.10 and the web server has a real IP as well as an internal IP (used to connect to sql server). Using this setup its not possible to ping or connect to the sql machine remotly. Is it possible to somehow setup a way to connect to the sql server via either Enterprise manager or Query Analyzer remotely?
If this is not possible is there any other way I can connect to it? I have full control of both machines so I can make any needed changes.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…