QUESTION POSED ON: 05 July 2005
I am a new DBA and support Microsoft's Retail Management System (RMS). RMS uses MSDE at each retail location to collect data from each of its cash registers (POS). Each store is connected to our main office which collects sales information from each store and stores it on an instance of SQL Server 2000. The store servers are NOT on the Corporate domain.
What is the best way to ensure the store information is backed up and saved to a domain/network drive? MSDE has poor backup tools. I have tried trial versions of a few backup applications, but they require the store locations to be on the domain to copy the file to our network drive which is not really helpful.
I think I will need a script of some sort to connect to each store server and copy it back to the HQ Server. Any ideas would be appreciated.
|
