I have a MSSQL database mdf/log that is several tens of gigabytes. I do not want to take the database offline with the MSSQL Management Tool to copy it for scripted backups because of the disruption in service.
I need to back up the thing while it is online and being used. If I use the Windows server 64 bit MSSQL import/export tool it disrupts the online database connections in the backup and it doesn't back up things like dbo stored proceedures and MSSQL functions also stored in the database.
So regardless of cost, I need a solution to back up this mega database on a scheduled process without disrupting connections to it, and without taking it offline.
I would like this to run as a Windows service that can run at a scheduled frequency like a crontab.
I won't bother to mention how easy and free this is on other platforms, because at this point I just want the solution.