I have 5 databases that I backup nightly, but one of them won't allow me to
backup to the .DEV file on the server. I just tried to backup manually and
got the following error. I search on the KB and Google, but didn't find much
.
I even recreated the .DEV file without luck. Any ideas?
(running SQL 2000 SP4 on Windows 2003 sp1)
EVENT # 17530
EVENT LOG Application
EVENT TYPE Error
SOURCE MSSQLSERVER
CATEGORY Backup
EVENT ID 17055
USERNAME ADVOCACYINC\Administrator
COMPUTERNAME INTAKE2003
TIME 1/9/2007 10:10:27 AM
MESSAGE 3041 :
BACKUP failed to complete the command BACKUP DATABASE [EducationAndTrain
ing]
TO DISK = N'E:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\EducationAndTraining
\EducationAndTraining.BAK' WITH
NOINIT , NOUNLOAD , NAME = N'EducationAndTraining backup', NOSKIP , STATS =
10, NOFORMAT
BINARY DATA 0000: E1 0B 00 00 10 00 00 00 0B 00 00 00 49 00 4E 00
0010: 54 00 41 00 4B 00 45 00 32 00 30 00 30 00 33 00
0020: 00 00 15 00 00 00 45 00 64 00 75 00 63 00 61 00
0030: 74 00 69 00 6F 00 6E 00 41 00 6E 00 64 00 54 00
0040: 72 00 61 00 69 00 6E 00 69 00 6E 00 67 00 00 00
0050:Hello,
Check if you have enough hard disk space in E Drive. I feel that this is
because you do not have enough room to backup the database into the hard
disk.
One more suggestion is you are using NOINIT, this will append the backups
files and cause the file to grow very high resulting in using the
hard disk space. So instead you NOINIT you can use WITH INIT. This will
reinitialize the backup file.
Thanks
Hari
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:B74FA9F7-B751-4891-8AA8-D6F64EB37FD0@.microsoft.com...
>I have 5 databases that I backup nightly, but one of them won't allow me to
> backup to the .DEV file on the server. I just tried to backup manually and
> got the following error. I search on the KB and Google, but didn't find
> much.
> I even recreated the .DEV file without luck. Any ideas?
> (running SQL 2000 SP4 on Windows 2003 sp1)
> EVENT # 17530
> EVENT LOG Application
> EVENT TYPE Error
> SOURCE MSSQLSERVER
> CATEGORY Backup
> EVENT ID 17055
> USERNAME ADVOCACYINC\Administrator
> COMPUTERNAME INTAKE2003
> TIME 1/9/2007 10:10:27 AM
> MESSAGE 3041 :
> BACKUP failed to complete the command BACKUP DATABASE
> [EducationAndTraining]
> TO DISK = N'E:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\EducationAndTraining
\EducationAndTraining.BAK' WITH
> NOINIT , NOUNLOAD , NAME = N'EducationAndTraining backup', NOSKIP , STATS
> =
> 10, NOFORMAT
> BINARY DATA 0000: E1 0B 00 00 10 00 00 00 0B 00 00 00 49 00 4E 00
> 0010: 54 00 41 00 4B 00 45 00 32 00 30 00 30 00 33 00
> 0020: 00 00 15 00 00 00 45 00 64 00 75 00 63 00 61 00
> 0030: 74 00 69 00 6F 00 6E 00 41 00 6E 00 64 00 54 00
> 0040: 72 00 61 00 69 00 6E 00 69 00 6E 00 67 00 00 00
> 0050:
>|||The hard drive has plenty of disk space. I'm wondering if the database might
be corrupt. Is there a way to check? If so, what is the procedure to cleanup
a corrupt database?
thanks,
Carlton.
"Hari Prasad" wrote:
> Hello,
> Check if you have enough hard disk space in E Drive. I feel that this is
> because you do not have enough room to backup the database into the hard
> disk.
> One more suggestion is you are using NOINIT, this will append the backups
> files and cause the file to grow very high resulting in using the
> hard disk space. So instead you NOINIT you can use WITH INIT. This will
> reinitialize the backup file.
> Thanks
> Hari
> "Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
> news:B74FA9F7-B751-4891-8AA8-D6F64EB37FD0@.microsoft.com...
>
>|||use
"DBCC Checkdb" on the database to see if some corruption is there...
also try "dbcc checkalloc" on the database.
"Cwhitmore" wrote:
[vbcol=seagreen]
> The hard drive has plenty of disk space. I'm wondering if the database mig
ht
> be corrupt. Is there a way to check? If so, what is the procedure to clean
up
> a corrupt database?
> thanks,
> Carlton.
> "Hari Prasad" wrote:
>
