June 30, 2004 at 4:29 am
hi,
I've migrated some SQL DBs to a new SQL cluster. This cluster is running W2003 and SQL 2000 sp3.
I've created 2 separate DB Maint plans - one for the system dbs and the other for the user dbs. Whilst the backups for the system db complete successfully the one for the user dbs report as successful but there are no backup files.
I found out that the backup files are being created but are deleted as soon as the backup job completes. The plan is set to keep backups for 1 day - I even removed this but the files are still being deleted. The funny thing is that the transaction log backups for one of the user dbs is not deleting the files whilst for the other it is.
All backups are writing to the same drive.
If anyone can help I would be most grateful.
June 30, 2004 at 5:24 am
Are there any other processes running on the box to collect these backups to another location? Do you have any other maintainece jobs that might be interfering? The fact it is saying the backsup were done successfully is intriging. Try maybe doing a backup manuallly and see if it disappears.
June 30, 2004 at 6:32 am
There are no other processes running on this server nor any other jobs. I can backup the dbs manually using query analyser - in fact as a workaround I have created a separate job that backs up the dbs and it works fine. Only having an issue when using Maint plans.
June 30, 2004 at 11:54 am
There is an option to EXPIRE backups. Check that to see if it is set incorrectly.
-SQLBill
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply