Execute incremental backup of SQL Server database after performing an update
Posted on 2012-09-14
I have a client who runs an update procedure to append and update data in a SQL Server from one of there legacy database systems. The updates are irregular, although the procedure I wrote allows them to kick off the process from a Windows Scheduled activity.
What I want to do is run an incremental backup of the database that gets updated after each upload process. I assume I can do this as a pass-through query (am looking for the proper syntax), but cannot figure out how to write the pass-through as it immediately asks for either a File or System DSN connection, and I want to use a DSN-less connection for this process.
Assuming I'm doing this in a command buttons click event, what should that code look like?