backup files not created

I am trying to backup a database and transaction log as part of a maintenanc
e
plan. The job indicates that it runs successfully but the .bak and .trn file
s
do not get created in the location specified. I tried different drive and
server locations and checked all the permissions. Two other databases in the
same maintenance plan work properly but just this one does not. The log file
within the scheduled job shows the path to the files, but they are not there
.
The SQL Server Log says that the database did not get backed up but gives no
specific error message, except to indicate that Backup failed to complete th
e
command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
Full.Tom,
What happens if you try to backup the database manually via EM or T-SQL?
Does this work? Might provide more details as to the cause of the failure.
HTH
Jerry
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>I am trying to backup a database and transaction log as part of a
>maintenance
> plan. The job indicates that it runs successfully but the .bak and .trn
> files
> do not get created in the location specified. I tried different drive and
> server locations and checked all the permissions. Two other databases in
> the
> same maintenance plan work properly but just this one does not. The log
> file
> within the scheduled job shows the path to the files, but they are not
> there.
> The SQL Server Log says that the database did not get backed up but gives
> no
> specific error message, except to indicate that Backup failed to complete
> the
> command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> Full.|||Also make sure you have not selected the 'Attempt to repair any minor
problems' checkbox. Requires the DB to be in single user mode.
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>I am trying to backup a database and transaction log as part of a
>maintenance
> plan. The job indicates that it runs successfully but the .bak and .trn
> files
> do not get created in the location specified. I tried different drive and
> server locations and checked all the permissions. Two other databases in
> the
> same maintenance plan work properly but just this one does not. The log
> file
> within the scheduled job shows the path to the files, but they are not
> there.
> The SQL Server Log says that the database did not get backed up but gives
> no
> specific error message, except to indicate that Backup failed to complete
> the
> command BACKUP DATABASE. SQL 2000 SP3 on Win 2003 server, recovery method
> Full.|||A manual backup (complete) from EM worked today for the database. I
deselected everything under the Options tab. I also did a transaction log
backup successfully through EM. The scheduled job did not complete when I
re-tried it.
On the DB maintenance job, I am only selecting that database and transaction
log and am taking the default location. I don't see any "Attempt to
repair..." settings in the maintenance plan.
Thanks.
"Jerry Spivey" wrote:

> Tom,
> What happens if you try to backup the database manually via EM or T-SQL?
> Does this work? Might provide more details as to the cause of the failure
.
> HTH
> Jerry
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:BA480BD6-24CC-4447-9C9B-A31145C27827@.microsoft.com...
>
>|||If you specify a report file for the maint job, you should be able to see an
y error messages in that
generated report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...[vbcol=seagreen]
>A manual backup (complete) from EM worked today for the database. I
> deselected everything under the Options tab. I also did a transaction log
> backup successfully through EM. The scheduled job did not complete when I
> re-tried it.
> On the DB maintenance job, I am only selecting that database and transacti
on
> log and am taking the default location. I don't see any "Attempt to
> repair..." settings in the maintenance plan.
> Thanks.
> "Jerry Spivey" wrote:
>|||Tibor,
I did that and it tells me that the job was successful. It even gives me the
name of the file that is supposed to be created. The file isn't there and th
e
SQL log gives me the same error as previously mentioned.
"Tibor Karaszi" wrote:

> If you specify a report file for the maint job, you should be able to see
any error messages in that
> generated report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:3DDF43BE-AD8D-4A45-B169-E40050A3474D@.microsoft.com...
>|||Strange... Is below correct:
No error in the maint wiz report file.
No backup file.
An error in the eventlog and the same error in the eventlog. Can you post th
at exact error
message(s)?
Other databases backup OK to the same location.
Is this database bigger than the other database?
Do you backup over a network to an UNC name?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:7E5093F4-DAA2-4F3A-BF23-BF1B929E582E@.microsoft.com...[vbcol=seagreen]
> Tibor,
> I did that and it tells me that the job was successful. It even gives me t
he
> name of the file that is supposed to be created. The file isn't there and
the
> SQL log gives me the same error as previously mentioned.
> "Tibor Karaszi" wrote:
>|||Yes, very strange.
Everything you have listed is accurate. TLog grows rapidly and is now around
5gb, db about 7 GB total, other db's much smaller. I ran dbcc shrinkfile on
log file but db still did not backup. I tried backing up to a remote server
as well as the default location. Manual backup does work. Other dbs backup a
s
scheduled.
This is error from SQL Log:
BACKUP failed to complete the command BACKUP DATABASE [Kronos_LS] TO DI
SK =
N'e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kron
os_LS_db_200509201123.BAK' WITH INI
T
, NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
This is from Maint. Plan log:
Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' : Step 1,
'Step 1' : Began Executing 2005-09-20 11:23:40
output
----
----
----
--
(null)
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Copyright (C) Microsoft Corporation, 1995 - 1998
(null)
Logged on to SQL Server 'NAMSDATWN500'
as 'sa' (non-trusted)
(null)
Starting maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:40 AM
(null)
[1] Database Kronos_LS: Database Backup...
(null)
Destination:
& #91;e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kr
onos_LS_db_200509201123.BAK]
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 8 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:48 AM
(null)
SQLMAINT.EXE Process Exit Code: 0 (Success)
(null)
"Tibor Karaszi" wrote:

> Strange... Is below correct:
> No error in the maint wiz report file.
> No backup file.
> An error in the eventlog and the same error in the eventlog. Can you post
that exact error
> message(s)?
> Other databases backup OK to the same location.
> Is this database bigger than the other database?
> Do you backup over a network to an UNC name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:7E5093F4-DAA2-4F3A-BF23-BF1B929E582E@.microsoft.com...
>|||I'm sorry, but I'm out of ideas. Unless someone else jumps in here, you migh
t want to open a case
with MS Support...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"TomM" <TomM@.discussions.microsoft.com> wrote in message
news:FFCE3E14-E2A3-4D40-A27C-335E99FFF4A8@.microsoft.com...
> Yes, very strange.
> Everything you have listed is accurate. TLog grows rapidly and is now arou
nd
> 5gb, db about 7 GB total, other db's much smaller. I ran dbcc shrinkfile o
n
> log file but db still did not backup. I tried backing up to a remote serve
r
> as well as the default location. Manual backup does work. Other dbs backup
as
> scheduled.
> This is error from SQL Log:
> BACKUP failed to complete the command BACKUP DATABASE [Kronos_LS] TO
DISK =
> N'e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kron
os_LS_db_200509201123.BAK' WITH I
NIT
> , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> This is from Maint. Plan log:
> Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' : Step
1,
> 'Step 1' : Began Executing 2005-09-20 11:23:40
> output
>
> ----
----
----
--
--[vbcol=seagreen]
> (null)
> Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
>
> Copyright (C) Microsoft Corporation, 1995 - 1998
>
> (null)
> Logged on to SQL Server 'NAMSDATWN500'
>
> as 'sa' (non-trusted)
>
> (null)
> Starting maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:40 AM
>
> (null)
> [1] Database Kronos_LS: Database Backup...
>
> (null)
> Destination:
> & #91;e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kr
onos_LS_db_200509201123.BAK]
>
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 8 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 9/20/2005 11:23:48 AM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 0 (Success)
>
> (null)
>
> "Tibor Karaszi" wrote:
>|||Thanks for trying.
"Tibor Karaszi" wrote:

> I'm sorry, but I'm out of ideas. Unless someone else jumps in here, you mi
ght want to open a case
> with MS Support...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "TomM" <TomM@.discussions.microsoft.com> wrote in message
> news:FFCE3E14-E2A3-4D40-A27C-335E99FFF4A8@.microsoft.com...
--[vbcol=seagreen]
>