hi,

full backup job was scheduled, in the log of jobs ( backup failed for online isssue)

Following error:

Executed as user: NT AUTHORITY\SYSTEM. The backup of the file or...

thanks for your reply.

database is online.

hi,

thx for ur replay. But why i'm getting this issue in same page like editurdetails.aspx.

thank you

hi thanks for ur post,

but in this article Error as:

DateTimeSPID Error: 17065, Severity: 16, State: 1.

DateTimeSPID SQL Server Assertion: File: , line = 2565 Failed Assertion = 'fFalse' Attempt to...

i don't know exact functional area, but how can i prevent it.

Warning: Fatal error 3624 occurred at Aug 19 2009 10:30AM. Note the error and time, and contact your system...

thanks for ur post,

but when server will give this error.is there any code change requires?

hi,

its working fine in query window(manual run), but it is giving the error for job only.

I Have total 600 tales to archive data, same script for the each and every table in a batch.

will it be affected by version?

my production server configuration

is 9.00.1399.06

Enterprise Evaluation...

hi thanks for your reply,

when we rebuild the index, the log size will be increased, so i'm planning to change the recovery model to simple/bulk logged. how it will affect...

this is the script i have written:

select * into [dblog].[dbo].[um_table]

from [dbprod].[dbo].[um_table]

go

truncate table [dbprod].[dbo].[um_table]

i've checked with ur mentioned path,

for the agent log on as : local system account,

job owner is sa .

is this really issue with the owner? i have other jobs like backups, it's working fine.

hi,

i've tried with your script, but still job is giving error.But in query analyzer it's not gving error.

is there any problem with the version:

my server version is :...

thanks for you r response.

what is RTM,