Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
Showing posts with label runs. Show all posts
Showing posts with label runs. Show all posts
Tuesday, March 20, 2012
Monday, March 19, 2012
backup question
Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
backup question
Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?
Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?
Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
Friday, February 10, 2012
Backup Followed by Crash
Hi. I have a SQL Server 2000 server that runs backups
every night on a handful of not very active databases.
Recently, the server has crashed or hung each time,
following successful backup of all but the last database.
No error message, no warning. The system log shows a
successful completion of the next-to-last backup. About
six seconds later (usually) there is a system time stamp
in the security log. Then the system just checks out,
sometimes powered down, sometimes hung but still powered
on. I have to manually reboot the system.
Any suggestions on how to track down the problem?
Thanks!
Nora Miller
Portland OR
NMiller,
What's in your
* SQL Server error log
* Windows Appication event log
* Windows System event log
Post relevant entries here. Do you have enough disk space? Where are you
backing up to? It could be a driver problem if using a tape device.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
NMiller wrote:
> Hi. I have a SQL Server 2000 server that runs backups
> every night on a handful of not very active databases.
> Recently, the server has crashed or hung each time,
> following successful backup of all but the last database.
> No error message, no warning. The system log shows a
> successful completion of the next-to-last backup. About
> six seconds later (usually) there is a system time stamp
> in the security log. Then the system just checks out,
> sometimes powered down, sometimes hung but still powered
> on. I have to manually reboot the system.
> Any suggestions on how to track down the problem?
> Thanks!
> Nora Miller
> Portland OR
every night on a handful of not very active databases.
Recently, the server has crashed or hung each time,
following successful backup of all but the last database.
No error message, no warning. The system log shows a
successful completion of the next-to-last backup. About
six seconds later (usually) there is a system time stamp
in the security log. Then the system just checks out,
sometimes powered down, sometimes hung but still powered
on. I have to manually reboot the system.
Any suggestions on how to track down the problem?
Thanks!
Nora Miller
Portland OR
NMiller,
What's in your
* SQL Server error log
* Windows Appication event log
* Windows System event log
Post relevant entries here. Do you have enough disk space? Where are you
backing up to? It could be a driver problem if using a tape device.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
NMiller wrote:
> Hi. I have a SQL Server 2000 server that runs backups
> every night on a handful of not very active databases.
> Recently, the server has crashed or hung each time,
> following successful backup of all but the last database.
> No error message, no warning. The system log shows a
> successful completion of the next-to-last backup. About
> six seconds later (usually) there is a system time stamp
> in the security log. Then the system just checks out,
> sometimes powered down, sometimes hung but still powered
> on. I have to manually reboot the system.
> Any suggestions on how to track down the problem?
> Thanks!
> Nora Miller
> Portland OR
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...
>
>
|||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...[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 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:
|||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...
>
|||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...[vbcol=seagreen]
> 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:
|||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_2 00509201123.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_20 0509201123.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 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_2 00509201123.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
>
> ----------
--[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:
> [e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_20 0509201123.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:
[vbcol=seagreen]
> 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...
--
>
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...
>
>
|||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...[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 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:
|||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...
>
|||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...[vbcol=seagreen]
> 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:
|||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_2 00509201123.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_20 0509201123.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 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_2 00509201123.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
>
> ----------
--[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:
> [e:\SQLData\MSSQL\BACKUP\Kronos_LS\Kronos_LS_db_20 0509201123.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:
[vbcol=seagreen]
> 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...
--
>
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.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
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.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
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]
>
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]
>
Subscribe to:
Posts (Atom)