Error 100 while running full backup in maintenance plan

Question

Error 100 while running full backup in maintenance plan

webrunner

SSC-Dedicated

Points: 31866
More actions
December 3, 2009 at 4:51 pm

#385888

Hello,
I just got this error (See below) from a maintenance plan at the part where it does a full backup of the two user databases on the server.
Does anyone know what this error message means? I Googled it and couldn't find the exact error number described. What is strange is that the database backup files are in their correct locations. So it looks like the backups completed successfully. Yet the error has me uneasy that something went wrong.
Thanks in advance for any help,
webrunner
Task detail: Backup Database on Local server connection
Databases: [DB1, DB2]
Type: Full
Append existing
Error number: 100
Error message: An exception occurred while executing a Transact-SQL statement or batch.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

webrunner (12/3/2009)
Hello,
I just got this error (See below) from a maintenance plan at the part where it does a full backup of the two user databases on the server.
Does anyone know what this error message means? I Googled it and couldn't find the exact error number described. What is strange is that the database backup files are in their correct locations. So it looks like the backups completed successfully. Yet the error has me uneasy that something went wrong.
Thanks in advance for any help,
webrunner
Task detail: Backup Database on Local server connection
Databases: [DB1, DB2]
Type: Full
Append existing
Error number: 100
Error message: An exception occurred while executing a Transact-SQL statement or batch.

Hi,

Execute & Post the result

Select @@version

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Does the maintenance plan log or SQL error log show something more useful?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

joeroshan SSChampion Points: 10377 More actions · Answer 3

webrunner (12/3/2009)
Hello,
What is strange is that the database backup files are in their correct locations. So it looks like the backups completed successfully. Yet the error has me uneasy that something went wrong.

Since you are appending to the existing file, the presence of the file doesnot mean you backup was successful. Restore headeronly to see the content of the file.

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

webrunner SSC-Dedicated Points: 31866 More actions · Answer 4

muthukkumaran (12/4/2009)
... snip ...
Hi,
Execute & Post the result
Select @@version

Here is what the system returned:

Thanks,

webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

webrunner SSC-Dedicated Points: 31866 More actions · Answer 5

joeroshan (12/4/2009)
webrunner (12/3/2009)
Hello,
What is strange is that the database backup files are in their correct locations. So it looks like the backups completed successfully. Yet the error has me uneasy that something went wrong.
Since you are appending to the existing file, the presence of the file doesnot mean you backup was successful. Restore headeronly to see the content of the file.

OK, thank you for this information.

I ran RESTORE HEADERONLY and got the results below. (Exact names anonymized.) The results basically look the same as the RESTORE HEADERONLY from the previous night's backup. But I'm not sure whether that means both backups are good or both backups are bad. Do you see anything indicating one way or the other?

Thanks again,

webrunner

BackupNameDB_backup_20091203180848

BackupDescriptionNULL

BackupType1

ExpirationDateNULL

Compressed0

Position1

DeviceType2

UserNameDomain\User

ServerNameServer

DatabaseNameDB

DatabaseVersion611

DatabaseCreationDate11/20/07 5:48 PM

BackupSize25026221568

FirstLSN363572000001100000000

LastLSN363574000000115000000

CheckpointLSN363572000001100000000

DatabaseBackupLSN362907000000326000000

BackupStartDate12/3/09 6:08 PM

BackupFinishDate12/3/09 6:23 PM

SortOrder52

CodePage0

UnicodeLocaleId1033

UnicodeComparisonStyle196609

CompatibilityLevel80

SoftwareVendorId4608

SoftwareVersionMajor9

SoftwareVersionMinor0

SoftwareVersionBuild3080

MachineNameServer

Flags512

BindingIDE403ED5D-ECD2-428C-8BDA-08CE0D0A796A

RecoveryForkIDC728E033-A76C-4014-B4F7-AECF6C9E3A02

CollationSQL_Latin1_General_CP1_CI_AS

FamilyGUID48F82566-C79A-458C-A59A-72F5E077FF1D

HasBulkLoggedData0

IsSnapshot0

IsReadOnly0

IsSingleUser0

HasBackupChecksums0

IsDamaged0

BeginsLogChain0

HasIncompleteMetaData0

IsForceOffline0

IsCopyOnly0

FirstRecoveryForkIDC728E033-A76C-4014-B4F7-AECF6C9E3A02

ForkPointLSNNULL

RecoveryModelSIMPLE

DifferentialBaseLSNNULL

DifferentialBaseGUIDNULL

BackupTypeDescriptionDatabase

BackupSetGUID9544E20B-7FC4-4E3E-9109-B912219F56AE

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

webrunner SSC-Dedicated Points: 31866 More actions · Answer 6

GilaMonster (12/4/2009)
Does the maintenance plan log or SQL error log show something more useful?

Thanks - so far, I haven't found anything useful to pinpoint the cause. Do you have any suggestions about what to look for?

Thanks again,

webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 7

webrunner (12/4/2009)
muthukkumaran (12/4/2009)
... snip ...
Hi,
Execute & Post the result
Select @@version
Here is what the system returned:
Microsoft SQL Server 2005 - 9.00.3080.00 (X64) Sep 6 2009 09:15:46 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanks,
webrunner

Hi,

Recommend you install the last Service Pack for SQL Server 2005

Latest SP for 2005

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/