I made a transaction log backup job, running every night at 10.00pm, but it won't run. I get an error message:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'db-maint'' (0x714C193CE9C4A74C80C28002766AE3D1) - Status: Failed - Invoked on: 2003-03-19 22:00:00 - Message: The job failed. The Job was invoked by Schedule 6 (Schedule 1).
Can somebody explain to me what i can do to fix this problem?
The database backup method is FULL so i can make transaction log backups.
1. In the maintains plain set the DB to be full Back Up once a day
2. Set the Transaction log to back Up every 1 hr / 30 Min according to the number of transaction / size of each back
3. configure the back up to delete old back up
In order to start the back up now – just make full back up of the DB , than shrink the transaction log , and than Back up again the DB .
Now you can start he schedule job of the the maintains plain and it should be O.K