1

Topic: I can not find as formed in MS SQL 2008 R2

Good afternoon!
Daily form . One on job I am strict on time I see in a broad gull  which job created  during strictly certain time was launched (at 5.00).
And another  forms during other time and noted not strictly on time and in running start of several minutes (23.34-23.55).
I can not understand than there is this . How it is possible to learn it? All adjustments were to me, I want to understand. Explicitly manually every day anybody at us does not create.
Please prompt. Version MS SQL 2008 R2

2

Re: I can not find as formed in MS SQL 2008 R2

makkut;
Good afternoon.
Well it cannot form. Therefore search in jobs more attentively, or procedure with the text ' %Backup DATABASE % ' and further where it is used.

3

Re: I can not find as formed in MS SQL 2008 R2

Sergey Vikt., in jobs precisely is not present, in window Log File Viewer I select all   on time is not present there for 23.34... Or even it is close to this time.
And here is how procedure to find? In mojabaza/programmability/stored Procedures only a nested folder system stored procedures here I so understand system procedures.

4

Re: I can not find as formed in MS SQL 2008 R2

Found there was a task the heap of actions and in the end of it under the circuit , here began from 19.00 there and time varied

5

Re: I can not find as formed in MS SQL 2008 R2

makkut;
About it and speech that randomnesses in reserve copying are not present.

6

Re: I can not find as formed in MS SQL 2008 R2

If default trace did not disconnect, it is possible to try this script:
[spoiler who, when, what command and from what application  basis XXX]

use master;
declare @all_files varchar (512);
/* prepare path for all files */
select @all_files=CAST (value AS VARCHAR (200))
FROM sys.fn_trace_getinfo (DEFAULT)
WHERE traceid = 1 AND property = 2
select @all_files=left (@all_files, len (@all_files)-charindex (' _ ', reverse (@all_files))) +right (@all_files, 4);
SELECT top 100
te.name,
ft. SPID;
ft. LoginName;
ft. Hostname;
ft. ClientProcessID;
ft. DatabaseName,
ft. FileName,
ft. StartTime,
dateadd (ms, ft. Duration/1000, ft. StartTime) [FinishTime];
ft. ApplicationName;
ft. ObjectID;
ft. Duration/1000/1000 [Duration (s)];
ft. TextData
FROM sys.traces st CROSS Apply
:: fn_trace_gettable (@all_files, st.max_files) AS ft
INNER JOIN sys.trace_events AS te ON ft. EventClass = te.trace_event_id
WHERE 1=1
and te.name = ' Audit Backup/Restore Event'
and ft. DatabaseName ='XXX ' -
and st.is_default=1 and st.status=1
ORDER BY ft. StartTime desc;

[/spoiler]