Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set database to single user mode
Message
De
17/06/2013 21:50:52
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01576584
Message ID:
01576589
Vues:
33
>I agree that a backup is something that is typically done on system level, not on application level. In this specific case, it is a function that the users use to create a snapshot before posting the monthly transaction files irreversibly to history and update all balances to open the next month. There is no practical way to create the possibility to re-open the closed months, but what happens in practice is that the users close the month and afterwards realize that they forgot something and would like to go back in time before the posting. So we introduced this backup/restore function so the users can create this snapshot and restore just before the posting happens. Sometimes the users go back and forward multiple times until everything is perfect. And that often after hours when the system admin is already long at home.

Ok, an image in time for the related purpose. Interesting!
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform