| Author |
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'' (0xE61E1EABD380A84EB
F33FB1AA12D6AD9) - 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"'
| |
| Uri Dimant 2006-10-24, 6:28 pm |
| 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'' (0xE61E1EABD380A84EB
F33FB1AA12D6AD9) - 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"'
>
| |
| Hari Prasad 2006-10-24, 6:28 pm |
| 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...
>
>
|
|
|
|