SQL Maintenance blooper

Sometime back I received a call from one of my clients. Client was having some system setup related issue that required a SQL Maintenance to be done. I quickly guided him over phone to go to MS Dynamics GP | Maintenance | SQL and select the required tables. Prior to this, I asked him if he kept a backup of DYNAMICS database and the answer was Yes. However, the system administrator of the client being new to the Dynamics GP environment (which I came to know only later) selected all tables by mistake and hit Drop Tables. Worst part was that there were users working online at this time. More worst was that after this happened, the new system administrator realized he doesn’t have a proper backup. Needless to say, the damage was real quick. All the users working online have been kicked out. There are several companies linked to the DYNAMICS database that got totally messed up. What would I do in this scenario?
I realized there must be some way out. Then, came a flashing idea. Why can’t we try hooking up any old(not so old) copy of DYNAMICS to this. Started searching for the same in the server directories and could find a copy of DYNAMICS that was 2 months older. Client was lazy enough to keep proper backups. I restored this DYNAMICS database to the existing database. Yes, it worked. However, minor data loss in the form of say, a new user record created recently was not there, so, we could quickly create the same. Similar but minor issues like some users who are assigned modified reports security wasn’t out there so have to set it up. Finally, things are back up and running. I just told myself “Oh! Boy..Today is your day!”
Why am I sharing this out here? Is to just let my readers know how scary it can be sometimes,  SQL Maintenance, if not done without having proper backups.Which is why I always tell my clients to keep proper data backups prior to doing any SQL maintenance. Specially, these are certain tasks that are recommended to be done with the help of either the Partners or experienced System administrators unless otherwise trust me, You got to pay for it!

UPDATE : Please do see a word of caution on linked Notes from David Musgrave in the Comments. Added on 18/08/2009

Please do see a similar experience shared by Doug, David Musgrave and Mariano from the link in the comments. Added on 19/08/2009

Popular posts from this blog

Dynamics GP Fixed Assets GL Posting Batch Missing After Depreciation Run

Image
I got a call from a user who was seemingly worried about her monthly depreciation batch went missing from GL posting routine in the Dynamics GP Fixed Assets. I quickly took her desktop on Teamviewer Quick support and understood the problem she is facing. Let me explain the issue in detail before I tell you the solution. Dynamics GP Fixed Assets GL Posting Issue Issue The user ran the depreciation routine in Dynamics GP for November month through Dynamics GP | Financial | Routines | Depreciate All Assets. Till here, all was good. She then proceeded to FA GL posting routine. Dynamics GP | Financial | Routines | GL Posting. She could not find the batch in GL posting lookup. In other words, the monthly depreciation batch is not accessible for posting. She then ran the depreciation process again and this time when she went to GL posting window and tried processing, the system threw an error message as below There are no transactions matching these restrictions. Modify yo
Read more

How to Enable and Disable Maintenance Mode in Dynamics 365 FO

Image
Maintenance mode in Dynamics 365 for Finance and Operations is required to be switched on for system administrators to make system changes that might affect system functionality. It is available for the safe use of the application. Only those users with Maintenance mode user role and system administrators roles can sign into the application till the time the mode is turned off. When the maintenance mode is switched off, there can't be changes made in certain areas of the system. Maintenance mode is required for activities such as activating financial dimensions, creating departments/cost centres, account structure activation and other system related functions. Enable and Disable Maintenance Mode  The easy way to enable and disable maintenance mode is using SQL query the D365 FO on premises is installed. Previously, Lifecycle services (LCS) used to have such an option for configuring the maintenance mode.  Maintenance mode can be changed from enabled to disabled and v
Read more