nivedita talukdar (6/20/2013)
Had checked the rollover option as it is by default but no use...job still fails..
Yes, it will. The rollover's not for restarting the job, it's for running the job for long periods and using multiple files
Ok if I have to run this 24/7 and need to keep the data for not more than 1 or 2 months...how do I keep it running?
Specify EndTime as null on the trace definition, and make sure that you have a good sized file and the rollover option
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability