June 4, 2002 at 5:49 pm
I just upgraded from SQL Server 7.0 SP4 to SQL Server 2000 SP2. All seems to have gone fine expect for the backups. After getting a backup error problem last night with a transaction log backup, I have been trying to manually invoke. It doesn't work. I then tried on a maintenance plan and that too doesn't work. Here is the error message from the Event Viewer:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Metadata Database Maintenance Plan'' (0x71E5F937C437D6118B1D00104BCC2CB5) - Status: Failed - Invoked on: 2002-06-04 16:11:02 - Message: The job failed. The Job was invoked by User PUBLIC_WORKS\gisadmin. The last step to run was step 1 (Step 1).
I changed tapes to a fresh tape right before I upgraded SQL Server if that matters. For a little while, I was getting another error saying that I had an unnamed tape in my drive. I then took the tape, opened it in MSBACKUP (same server), and named the tape by backing up one file. After the unnamed tape error went away. However now I am receiving the other error.
Any ideas?
Thanks in advance!
June 5, 2002 at 5:17 am
Duplicate thread please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4625&FORUM_ID=24&CAT_ID=1&Topic_Title=backup+problems&Forum_Title=Backups
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply