Friday, February 24, 2012

Backup Abort

I have a SQL Server 2000 Enterprise database on a Windows 2003 server. I
created a database-complete backup from SQL Server 2000 Enterprise GUI. When
the backup job finishes it displays the following message: The backup
operation has been completed sucessfully.
But SQL Server errorlog states that BACKUP failed to complete.
No backup file was created.
Please help me with this problem.
Thank You,
SQL Server errorlog
BACKUP failed to complete the command BACKUP LOG [DATABASE] TO DISK = N'K:\D_tlog_200412150700.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10,
NOFORMATJoe,
You need to check to see if you process has WRITE privs to the K: drive.
Also, look in the Event viewer to see what errors where logged there as
well.
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:CCD38392-52DD-4FC5-AB65-F33C0FEF2D84@.microsoft.com...
> I have a SQL Server 2000 Enterprise database on a Windows 2003 server. I
> created a database-complete backup from SQL Server 2000 Enterprise GUI.
When
> the backup job finishes it displays the following message: The backup
> operation has been completed sucessfully.
> But SQL Server errorlog states that BACKUP failed to complete.
> No backup file was created.
> Please help me with this problem.
> Thank You,
>
> SQL Server errorlog
> BACKUP failed to complete the command BACKUP LOG [DATABASE] TO DISK => N'K:\D_tlog_200412150700.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS =10,
> NOFORMAT

No comments:

Post a Comment