Welcome to
Sign in
|
Help
in
T-SQL (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
T-SQL
»
Istoric Job-uri SQL Server
Istoric Job-uri SQL Server
Last post 12-06-2012, 2:44 PM by
neo
. 4 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
12-05-2012, 4:42 PM
9487
neo
Joined on 11-06-2007
Bucharest
sysadmin
Istoric Job-uri SQL Server
Reply
Quote
Salut,
Pe un SQL Server 2005 SP1 Standard Edition pot sa vad cine mi-a modificat un job SQL (trecerea lui pe disable)?
Mentionez ca nu am avut activat C2 Audit-ul.
Multumesc.
G.
Report abuse
12-06-2012, 11:23 AM
9488
in reply to
9487
Diana
Joined on 03-21-2006
sysadmin
Re: Istoric Job-uri SQL Server
Reply
Quote
Incearca sa vezi daca prinzi ceva in default trace, pe evenimentul "object altered"
http://blogs.technet.com/b/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx
Report abuse
12-06-2012, 12:08 PM
9489
in reply to
9488
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: Istoric Job-uri SQL Server
Reply
Quote
In trace-uri nu apare nimic.
G.
Report abuse
12-06-2012, 12:25 PM
9490
in reply to
9487
rsocol
Joined on 10-03-2006
Bucuresti
sysadmin
Re: Istoric Job-uri SQL Server
Reply
Quote
Dacă msdb are Recovery Model-ul Full, ai putea să sapi în transaction log, cu ceva de genul Lumigent Log Explorer sau ApexSQL Log.
Report abuse
12-06-2012, 2:44 PM
9491
in reply to
9490
neo
Joined on 11-06-2007
Bucharest
sysadmin
Re: Istoric Job-uri SQL Server
Reply
Quote
Modelul de business ma obliga sa lucrez pe RecoveryModel 'Simple' din motive de performanta.
G.
Report abuse