AntonioCuomo Posted December 17, 2021 Share Posted December 17, 2021 If I want to perform backups with sqlserver using an fdquery how should I implement it? unitimer and fdquery1 on main Form? Quote Link to comment Share on other sites More sharing options...
Wilton Ergon Posted December 20, 2021 Share Posted December 20, 2021 if the backup routine is automatic without user intervention that will run at a scheduled time, use a tunitreadtimer, on the servermodule. create a specific connection for this backup routine. I don't think it's a good idea to have a routine like this for your end user to run, it can generate I/O overhead on your server. 1 Quote Link to comment Share on other sites More sharing options...
picyka Posted December 20, 2021 Share Posted December 20, 2021 Better to create a .bat file, and link to server tasks. 1 Quote Link to comment Share on other sites More sharing options...
adragan Posted January 3, 2022 Share Posted January 3, 2022 As far as I know Sqlserver has it's own backup cron. Template, backup plan and such. Why don't you use it ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.