Guidelines for Process

[Rahulbatra]

We previously faced a great problem of recovering a database that was deleted by mistake. It was a long process to get back the recovered database. We had to use many process like tried using recovery software and many other process. At last we ran sp_resetstatus to regain our database. Now I want to follow a standard procedure of maintaining the database so that we could get the database in full shape easily even if deleted by mistake. Kindly guide me the process to follow for this.

[rachelle]

Yes using sp_resetstatus have the probability of regaining the database after a big process for regaining the database and after again restarting SQL Server. But the above process is only a probability of regaining the database provided the system file pages have not got corrupted. So as you have asked a standard procedure of maintaining the database must be followed so that we could get the database in full shape easily even if deleted by mistake. One of the vital procedures which is a must for this is to make a full backup of database at regular intervals and it must be stored safely so that whenever something happened before the next backup the previous full backup would always be there to prevent full heavy loss of database.