backup files not created

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.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...
> >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.
>
>|||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...
>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...
>> >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.
>>|||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 the
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...
> >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...
> >> >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.
> >>
> >>
> >>
>|||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...
> 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 the
> 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...
>> >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...
>> >> >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.
>> >>
>> >>
>> >>
>>|||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 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\Kronos_LS_db_200509201123.BAK' WITH INIT
, 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:
[e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_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...
> > 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 the
> > 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...
> >> >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...
> >> >> >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.
> >> >>
> >> >>
> >> >>
> >>
> >>
>|||I'm sorry, but I'm out of ideas. Unless someone else jumps in here, you might 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 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 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\Kronos_LS_db_200509201123.BAK' WITH INIT
> , 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:
> [e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_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...
>> > 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 the
>> > 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...
>> >> >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...
>> >> >> >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.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>|||Thanks for trying.
"Tibor Karaszi" wrote:
> I'm sorry, but I'm out of ideas. Unless someone else jumps in here, you might 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 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 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\Kronos_LS_db_200509201123.BAK' WITH INIT
> > , 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:
> > [e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_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...
> >> > 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 the
> >> > 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...
> >> >> >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...
> >> >> >> >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.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>