AX-SQL Tips (Data Backup)

AX-SQL Tips (Data Backup)

Maintenance Plans for Backup

Check Management – Maintenance Plan (Created by Alex)

Back-Up Maintenance Plan – There is a plan in place to do a Full backup of all User Databases including any New databases.

Purge .bak files older than 3 days.

Sp_helpdb will show all the Database backup settings whether Simple or Full.

Shrinking File Sizes

Right Click over Database – Tasks – Shrink – Change from Data to Log – Click ON

Right Click over Database - Click Properties – Click on Files Tab – Check size of File

Stored Procedure – Current Processes

Sp_who2 will show what is running but will not show which user only process owner AXAOS

Blocked Objects

Check the Blk-By column and if anything appears it is locked up. Check further down in this column and see if some other process is locked. Usually more than one lock, kill the offending process.