We have a Everyday Growing Database in MSSQLServer7 with an approximate current size of 300MB consisting of 50 tables and 30 stored procedures and few triggers.
Need a software-utility program to automatically/manually perform "Live-Backup" onto another server(IP Address) in "real-time", so that both the servers are in-sync.
The Interface of the program should provide the means of selecting any server on the network(thru the use of IP Address) to backedup-to.
The program should let either "All" or selected DB-Objects to be backedup
Confirmation screens should display the results,
Ex:
* Total Numbers of tables backed up
* Total numbers of records backed/copied
* etc....etc
Also in the utility should be included a routine to "ARCHIVE" data from different tables, as an example we currently have about 800,000 Orders from past 4 years, we want you to provide a means by which we shall be able to "remove all orders" which are 3 years old and archive it into a "Order_History" table.
We have "normalized" the Database to the maximum but need the bidder to help in re-configuring the indexes and help in enhancing the performance by coming up with fine-tuning procedures (if any) is required.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Win 2000/NT