Backups failed ? 1

[Greg25]

Here's the error I received.

The job failed. The Job was invoked by Schedule 6 (Schedule 1). The last step to run was step 1 (Step 1).

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 63113C0B-13F8-4496-8EF9-1EECF3F0185D -Rpt "C:\MSSQL7\LOG\Normal Backup6.txt" -DelTxtRpt 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "D:\MSSQL Backups" -DelBkUps 4WEEKS -CrBkSubDir -BkExt "TRN"'

Schedule 1 Occurs everyday, every 4 hours between 6:00 am 11:59 pm

I am not to shore what you need to look at, this is some stuff I took off the server

The backups have been working all a long since I started all of this stuff?

 

[dbmsguy]

Take a look in C:\MSSQL7\LOG\Normal Backup6.txt, you should see more specific errors Paul

http://www.dbmsguy.com

 

[Greg25]

This is what i found, Northwind was not found that DB, came with Access I throught and was deleted I created DB Northwind and ran again with no luck same error.

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'METASRV' as 'NT AUTHORITY\SYSTEM' (trusted)
[Microsoft SQL-DMO] Error 21776: [SQL-DMO]The name 'Northwind' was not found in the Databases collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.
Starting maintenance plan 'Normal Backup' on Wed Jul 18 14:40:46 2001

[1] Database MAGC_v_2_2: Transaction Log Backup...
Destination: [D:\MSSQL Backups\MAGC_v_2_2\MAGC_v_2_2_tlog_200107181440.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'MAGC_v_2_2_data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
[2] Database model: Transaction Log Backup...
Destination: [D:\MSSQL Backups\model\model_tlog_200107181440.TRN]

** Execution Time: 0 hrs, 0 mins, 1 secs **

[3] Database model: Verifying Backup...

** Execution Time: 0 hrs, 0 mins, 1 secs **

Deleting old text reports... 0 file(s) deleted.

End of maintenance plan 'Normal Backup' on Wed Jul 18 14:40:47 2001

SQLMAINT.EXE Process Exit Code: 1 (Failed)

 

[tlbroadbent]

The key is in this poart of the error message.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'MAGC_v_2_2_data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.

You cannot do a transaction backup becasue someone did a BCP, Bulk Insert or Insert Into operation on the database,
'MAGC_v_2_2_data.' These operation invalidate the transaction log. Do a full backup and things should return to normal. To prevent this in the future, make sure the 'Select into/bulk copy' option is off on the data base.

If you must allow bulk copy operations, you should set up a Job to start on SQL Server alert event 4213. This Job could do a full or differential backup or send email to the DBA informing him of the problem so he can run a proper backup. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Greg25]

Thats what i jus did and orked fine
Tanks Greg