Error when Backup on SQL Server ( Error 3202 )

[Pelson2003]

Anyone kwows why this happens ? and what I have to do to resolve this ?
Thanks
Pelson2003.

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'Server\TOPSQL' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'MICROSIGA' on 3/15/04 8:00:04 PM
[1] Database DADOSADV: Database Backup...
Destination: [G:\restore\DADOSADV\DADOSADV_db_200403152000.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'G:\restore\DADOSADV\DADOSADV_db_200403152000.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
Deleting old text reports... 1 file(s) deleted.

End of maintenance plan 'MICROSIGA' on 3/15/04 8:00:29 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

 

[SQLBill]

Did you check this:

See the SQL Server error log for more details.


Also, did you check the Windows Event Viewer logs (application, system, security) to see if there was anything else that might be causing the problem?

-SQLBill

 

[yberhane]

Could it be that there is no enough space on your backup device? In case you are using database maintenace to backup your database you should remember that old backup files are not written on while the backup goes (unlike in backup with init option). The old files are deleted after the backup is completed which means you require enough space on your backup device for both fresh and old backup files

 

[JayKusch]

If I were to venture a guess it would be that the backup device(dump device) that is set to the folder/share named ... "G:\restore\DADOSADV\" is not longer valid. Maybe the folder\directory "G:\restore\DADOSADV\" no longer exists.

Thanks

J. Kusch