During of my database service procedure I check that I can do backup and can restore that backup, so I also know about problems of corrupted bacups and possible reasons of metadata corruption. For preventing orphan pages or backversions I turn off autosweep. So for the last month I don't see any orphan pages or orphan backversions.
I know that shutdown during sweep can broke database, so I turn off autosweep and do only manual sweep. My service of database looks like this: 1) try normally close all connections(all my applications get commands for starting of autoclose procedure) 2) kill all terminal instance of my applications 3) shutdown database(my software use non root access, so it's guarantee single user access) 4) killing all processes fb_inet_server.exe 5) Waiting for 10 seconds for restarting windows service of FB 6) sweep 7) Bring database online How can I close all connections normally if something goes wrong, for example my application can't get command for closing so user still working(or maybe not, for example application is opened but no one working)? Is there any normal way for single user access without using of shutdown mode?
