Akash Kava's questions

With great efforts finally I was able to setup Mysql replication (both on windows) from one host to other as simple one way asynchrounous master-slave replication. Now purpose of this replication is just to have upto date backup, and we can switch to slave server at the time of crash.

1. How do I monitor slave status, can it email me if it could not contact host, or more number of failures occur.
2. How to make sure replication is in sync and we are not loosing any data.

If there is any automated solution then great, otherwise if I have to write some tool by myself, I am still open to the idea.

I have enabled following policies,

• "Prohibit TCP/IP advanced connection"
• "Prohibit access to properties of components of a LAN connection"
• "Enable Windows 2000 Network Connections setings for Administrators"

after doing all these, all machines running windows xp, 2000 and vista have network settings properties button disabled as expected.

However all machines running windows 7 have no effect, I believe there are few more steps, all Windows 7 machines are on domain and we want to control this via Domain Controler's GPO.

Please let me know, what I need to do to have Windows 7 disable the properties of network connection, I am not network expert, I read few articles about what new has been added in GPO of windows 7 but I am blank.

Everything works fine on Windows XP, Vista, 2003 Server. Only Windows 7 is a problem.

We are running virtual servers on our windows server, I noticed that one of the server wont connect and when connected through virtual machine interface we found that server is up and running and we can access network/internet within the server but no outsider can connect to server.

We removed virtual network interface and added new one (That will generate new MAC address for virtual network interface) and then server was accessible.

Same problem occured both in VMWare as well as HyperV, not both at same time but with gap of 3-4 days.

I want to know that is it possible that two network interface on same LAN with same MAC address but different IP can create problem?

I have two questions,

1. Can I use existing 2nd Hard Drive as External Hard Drive inside Virtual Server Instance running on same machine?

2. If I use right now Virtual Server 2005 and run my server, tomorrow if I buy HyperV on different machine, can I just simply use same Virtual Hard Drive in Hyper V Without having to reinstall everything?

Here is what I am doing,

1. Take full FILE backup at 1.00 AM
2. Take differential FILE backup every 15 minutes
3. And we ftp all data to other location and restore everything there

So now from My Source database to Destination database, every 15 minutes, its replicated remotely on other node. Now we do have full files, do we still need to backup transaction logs? We are willing to sacrifice last 15 minutes of data in case of disaster, because thats the best we can manage remotely.

Because even if anything crashes, last 15 minutes of data will never be recovered in case of hardware failure event, and to bring everything up will take more then a day, where else other server can start taking over and go on.

So ideally, Imagin a situation as below,

1.00 AM full file backup transferred to server B
1.15 AM differential file backup transferred to server B
1.30 ... same as above
1.45 ... same as above
1.50 ... crash, machine down...

at this position, can Server B continue from 1.45 restored database?

Because if machine crashes at 1.50, it will not be able to transfer Log backups anyway, and we have Full backup and differential backups restored on server B already.

So question redefined, if we have correct Full + Differential File backups, do we still need log backups?

As long as till 1.45 data is consistent we are good to go.

Ok here is probably dumbest question but I really dont understand how sharing works.

I shared a folder with name "Data" and I gave permission to "Administrators" group to everything in Network Sharing Permissions.

On the folder "Data", apart from the usual permissions, I gave "Administrators" group full control to "Data" folder.

Now I added a user in Local Users with name "DataUser" and I made this user member of "Administrators".

Simply:

1. LAN Server (No Active Directory, No Domain, Standalone Server)
2. We access via IP address.
3. "DataUser" is User and is member of "Administrators"
4. "\Server\Data" is shared folder with "Administrators" group being full rights
5. "Data" folder has full control for "Administrators" group
6. I also did "Replace all permissions on child objects" for "Data" folder

Now the problem is, I am on other machine, I can add a new file inside "\Server\Data" folder but i can not delete or overwrite the files which are there right from beginning.

Entire Data folder and its all files have full control of "Administrators" group then why user "DataUser" which is in "Administrators" group cant delete existing files? The newly added files can be deleted but not the old ones. If I right click, I can see old file has full control for "Administrators" group.

We are hosting lot of Win 2008 servers, now I am aware of commercial bandwidth monitoring tools, but I know there are some network tools available in Windows server like NetMon etc, I dont know how to use them, I am sure Windows 2008 Web Edition should have something inbuilt tool.. or else we have to realy go and buy one..

I am trying to setup VPN between two "Windows 2008 Datacenter Edition" servers reciding in two different datacenters.

I did do the setup outlined in help files, but I am sure I missed somewhere how to configure DHCP, because the connecting client machine does not get any IP assigned and it looses its internet connection.

Consider Server A is VPN Server and can host IP range 10.0.0.1 to 255, and it is also having A.A.A.A as its real public internet ip address.

Server B is normal server with B.B.B.B as its public ip address.

Now for some silly reasons SQL on Server B cant replicate from Server A, and it demands VPN !!

Is it possible to create VPN setup such way that, Sevrver B can have VPN to Server A and whenever Server B places request on 10.0.0.X ip, it can go through VPN and rest communication can go through its default original gateway?

One final, if anyone can suggest any other windows based solution like openVPN (it doesnt work on windows !!) that will be great.

We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. After evaluating number of replication options, apart from VPN there is no other way to do replication for SQL Server. We are investigating VPN but I have following questions.

Our Large DB consists of media information (pictures/movies/audio/pdf) etc, so we are not very concerned about security because they are not financial sensitive data.

1. SQL 2005 supports or can be configured to support replication over internet? If Yes then should we downgrade to 2005?

2. If SQL 2008 Publisher is configured for Web Sync, can we write an automatic program (C# Windows Service) to act as pull subscriber and run on the subscriber server and replicate subscriber database?

Or are there any API available in SQL where we can write our own program to do replication in very generic way? (In a nut shell, can we write our own C# Windows Service based Subscriber program?)