Help with Bkup jobs

Hi,
I have a daily job programmed to backup two sets of dbs with their
respective BAK and TRN extensions.
Job 1 is executing normally creating the backup files BAK and TRN but job 2
is only creating the BAK file and not the TRN.
Both jobs were created with the db maintenance plans.
What could be possible wrong? Or where should I start looking?
Any help is appreciated.
Ana.
Here's the application's logger description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The Job
was invoked by User sa. The last step to run was step 1 (Step 1).
Job1:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
SQL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
Job2:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
SQL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'Ana
I have already answered this question posted by you a few days ago
Please make sure that the second database is not set to SIMPLE recovery
mode
"Ana_T" <nospam@.yahoo.com> wrote in message
news:OKSW09J3GHA.1568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have a daily job programmed to backup two sets of dbs with their
> respective BAK and TRN extensions.
> Job 1 is executing normally creating the backup files BAK and TRN but job
> 2
> is only creating the BAK file and not the TRN.
> Both jobs were created with the db maintenance plans.
> What could be possible wrong? Or where should I start looking?
>
> Any help is appreciated.
> Ana.
>
>
> Here's the application's logger description:
>
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan
> 'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
> Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The
> Job
> was invoked by User sa. The last step to run was step 1 (Step 1).
>
>
> Job1:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
> QL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
> Job2:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
> QL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>|||Thank you Uri, I couldn't find the post.
Where is the recovery selection hidden at? I cannot find it. I used the
wizard to create the jobs.
"Uri Dimant" <urid@.iscar.co.il> escribió en el mensaje
news:eHeaaIK3GHA.1256@.TK2MSFTNGP04.phx.gbl...
> Ana
> I have already answered this question posted by you a few days ago
> Please make sure that the second database is not set to SIMPLE recovery
> mode
>
> "Ana_T" <nospam@.yahoo.com> wrote in message
> news:OKSW09J3GHA.1568@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I have a daily job programmed to backup two sets of dbs with their
>> respective BAK and TRN extensions.
>> Job 1 is executing normally creating the backup files BAK and TRN but job
>> 2
>> is only creating the BAK file and not the TRN.
>> Both jobs were created with the db maintenance plans.
>> What could be possible wrong? Or where should I start looking?
>>
>> Any help is appreciated.
>> Ana.
>>
>>
>> Here's the application's logger description:
>>
>> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
>> Plan
>> 'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
>> Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The
>> Job
>> was invoked by User sa. The last step to run was step 1 (Step 1).
>>
>>
>> Job1:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
>>
>> L_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
>> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>> Job2:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
>>
>> L_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
>> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>|||hi
make sure that your maintenance plane is not talking transactional log
backup of master database.
to get the actual error message query msdb.sysdbmaintplan_history table
Vinu
"Ana_T" wrote:
> Hi,
> I have a daily job programmed to backup two sets of dbs with their
> respective BAK and TRN extensions.
> Job 1 is executing normally creating the backup files BAK and TRN but job 2
> is only creating the BAK file and not the TRN.
> Both jobs were created with the db maintenance plans.
> What could be possible wrong? Or where should I start looking?
>
> Any help is appreciated.
> Ana.
>
>
> Here's the application's logger description:
>
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
> Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The Job
> was invoked by User sa. The last step to run was step 1 (Step 1).
>
>
> Job1:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
> SQL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
> Job2:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
> SQL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>
>|||Ana
SELECT DATABASEPROPERTYEX('Northwind', 'Recovery')
"Ana_T" <nospam@.yahoo.com> wrote in message
news:OGS$voK3GHA.480@.TK2MSFTNGP06.phx.gbl...
> Thank you Uri, I couldn't find the post.
> Where is the recovery selection hidden at? I cannot find it. I used the
> wizard to create the jobs.
> "Uri Dimant" <urid@.iscar.co.il> escribió en el mensaje
> news:eHeaaIK3GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> Ana
>> I have already answered this question posted by you a few days ago
>> Please make sure that the second database is not set to SIMPLE recovery
>> mode
>>
>> "Ana_T" <nospam@.yahoo.com> wrote in message
>> news:OKSW09J3GHA.1568@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I have a daily job programmed to backup two sets of dbs with their
>> respective BAK and TRN extensions.
>> Job 1 is executing normally creating the backup files BAK and TRN but
>> job 2
>> is only creating the BAK file and not the TRN.
>> Both jobs were created with the db maintenance plans.
>> What could be possible wrong? Or where should I start looking?
>>
>> Any help is appreciated.
>> Ana.
>>
>>
>> Here's the application's logger description:
>>
>> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
>> Plan
>> 'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
>> Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The
>> Job
>> was invoked by User sa. The last step to run was step 1 (Step 1).
>>
>>
>> Job1:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
>>
>> _Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
>> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>> Job2:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
>>
>> _Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
>> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>>
>

Help w/backup jobs

Hi,
I have a daily job programmed to backup two sets of dbs with their
respective BAK and TRN extensions.
Job 1 is executing normally creating the backup files BAK and TRN but job 2
is only creating the BAK file and not the TRN.
Both jobs were created with the db maintenance plans.
What could be possible wrong? Or where should I start looking?
Any help is appreciated.
Ana.
Here's the application's logger description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The Job
was invoked by User sa. The last step to run was step 1 (Step 1).
Job1:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
SQL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
Job2:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
SQL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'Ana_T
Is it possible that the second database is set to SIMPLE recovery mode?
"Ana_T" <nospam@.yahoo.com> wrote in message
news:u9SdT3k2GHA.5048@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I have a daily job programmed to backup two sets of dbs with their
> respective BAK and TRN extensions.
> Job 1 is executing normally creating the backup files BAK and TRN but job
> 2 is only creating the BAK file and not the TRN.
> Both jobs were created with the db maintenance plans.
> What could be possible wrong? Or where should I start looking?
>
> Any help is appreciated.
> Ana.
>
>
> Here's the application's logger description:
>
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
> Plan 'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) - Status:
> Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job failed. The
> Job was invoked by User sa. The last step to run was step 1 (Step 1).
>
>
> Job1:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
> QL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
> Job2:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
> QL_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>|||Hello,
As Uri pointed out the issue might be because of SIMPLE recovery mode.
Please verigy the recovery model by executing the below query.
Select databasepropertyex('DBNAME','Recovery')
-- Replace DBname with actual dbname.
If it return SIMPLE and if the database is critical then do:-
1. Set the Recovery model to FULL.
2. DO a full database backup (.BAK) -- this is to create a new backup chain
3. Then you could try a trnasction log backup.
Thanks
Hari
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23kIm64k2GHA.1288@.TK2MSFTNGP03.phx.gbl...
> Ana_T
> Is it possible that the second database is set to SIMPLE recovery mode?
>
>
>
>
> "Ana_T" <nospam@.yahoo.com> wrote in message
> news:u9SdT3k2GHA.5048@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I have a daily job programmed to backup two sets of dbs with their
>> respective BAK and TRN extensions.
>> Job 1 is executing normally creating the backup files BAK and TRN but job
>> 2 is only creating the BAK file and not the TRN.
>> Both jobs were created with the db maintenance plans.
>> What could be possible wrong? Or where should I start looking?
>>
>> Any help is appreciated.
>> Ana.
>>
>>
>> Here's the application's logger description:
>>
>> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance
>> Plan 'DB Maintenance REGV'' (0xE61E1EABD380A84EBF33FB1AA12D6AD9) -
>> Status: Failed - Invoked on: 2006-09-17 13:27:11 - Message: The job
>> failed. The Job was invoked by User sa. The last step to run was step 1
>> (Step 1).
>>
>>
>> Job1:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> CF77F56D-B303-4429-AD22-D1FCADD80EEB -To
>> L_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
>> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>> Job2:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 25E1CF45-FDAA-4B0B-B209-60176367F5BF -To
>> L_Errores" -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDBRepair -BkUpMedia
>> DISK -BkUpLog -UseDefDir -DelBkUps 4WEEKS -BkExt "TRN"'
>