July 14, 2013 at 2:10 pm
Receive notifications that the Transaction Log Backup has failed when it has succeeded.
I have been receiving notifications that the Transaction Log Backup has failed.
I look in the Job History and it shows that it succeeded.
The backup file is there.
I changed the recovery model to Simple before performing a REBUILD of Indexes and I switched it back to Full after.
Then I performed complete backups.
Any ideas?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2013 at 8:49 am
The transaction log for one of the Database was huge so the backup does not appear to working.
In the job history lists the job as successful and the backup file is created.
Any ideas?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply