Please check the following
1.backup schedule is working properly. Check whether backup is copied to nodes. Create a backup schedule to copy the data base to node in noon. Also set a schedule in the evening. Inform the officials to shut down the system only after the backup is over.
2.copy the server components to one of the nodes. Point of sale , sub accounts, treasury and speed net server componet should be copied to node. If the server fails, we can copy the server components to the new server. So that all users and work allocation can be retrieved.
3. Copy the config files of emoclient and epayment client to another system or another location in the hard disk . If the config file is corrupted we can restore this config file.
4. Go to SQL enterprise manager and check whether any data base is corrupt. If msdb database is corrupted all of our packages will work. But database maintenance plans will not work. This is very important. If msdb is corrupted restore the msdb using the query to restore the same.
5. It is noticed that data base of some sub offices are corrupted due to power failure or some problem with hard disk. Hence while you visit sub office, open the query analyzer and run the following query by selecting data bases one by one . If some problem is with the database, error will display in red colour. Then try to repair the database. If repair fails, restore the latest backup and check the data base for consistency.
DBCC CHECKDB
it is very important. Otherwise the problem will come only after two or three weeks.
6.Shrink the database log files using the query to shrink the database. For sql 2000 , query is available in PTC site. For SQL 2005 it is a part of database maintenance plan. We can check that option in the maintenance plan wizard.
No comments:
Post a Comment