What I need is a dll that can backup SQL Server 7.0 databases even if the database is in use. The SQL Server agent does not work because there was a problem when SQL Server was installed. It cannot be uninstalled because there is a program called [url removed, login to view] that always run behind the scenes when Windows 2000 Server Edition runs. If there is no way to make it save everything, then I need it to at least save the table information (the names of the tables and contents in it as well). The only part that also must be saved is the diagram information so if I had to restore the information, I would have a way of knowing the relationships between the tables (assuming I put it in the diagram). For the dll, there should be the following properties that need to be set.
The first one is the connection string (to connect to the database). Next, the path for the backup tables and path for the backup relationships unless they can both be in the same file. Another property needed would be whether it is a complete or differential backup or restoring. The differential would only be applied to the tables. Also, whether just the tables would be backed up or the tables and the diagrams. If differential is chosen, it would only back up the changes. The same goes with if the differential is chosen and its restoring the backup. The two methods needed are backup and restore. If the restore method is used, it would replace all data with the information restored. If there is a way to only restore data that is different, that would be good as well but not required. I need it in a dll so I can create a program that runs on a timer. There should be 2 events. One would be the error event and the other would be the finished event. The events are necessary so other things could be happening while its waiting. A progress event would be nice but not required.
The compiled dll file and a simple sample project to show how to back up and restore SQL Server databases. Cannot use SQL Agent because the SQL Agent on my computer is corrupted. Cannot simply use filecopy or read the file contents because it shows it in use. The simple sample project must be coded in Visual Basic 6.0, however, the component can be completed in another language. However, if its done in another language, must be tested to make sure it is fully compatible with Visual Basic 6.0 (making sure events work properly, other processes intended still works).
Windows 2000 Server Edition, SQL Server 7.0