June 28, 2011 at 6:29 pm
Good evening
ive got a question
as operador in a production system there is a procedure we got to run daily. and the procedure is this in the following order:
1. execute a job or process that makes checkpoint to all databases
2. secondly stop and start over the sql service and agent
the question is if someone skips or omits the step 1 and exe step 2. ?
the data will be not consistent ?
ive read some of your useful documents you have posted but ive got to take a thorough course
ill appreciate your help
🙂
June 28, 2011 at 6:46 pm
Why the **** do you stop and restart the server daily?
Whatever problem you think you are fixing, I'm 1 000 000% certain there's a better way!
June 28, 2011 at 6:55 pm
its a company procedure weve got to run daily at night for freeing up system resources
June 28, 2011 at 7:15 pm
pavargasq (6/28/2011)
its a company procedure weve got to run daily at night for freeing up system resources
fire the manager who signed on this and come back to us for a real solution.
June 29, 2011 at 2:33 am
pavargasq (6/28/2011)
its a company procedure weve got to run daily at night for freeing up system resources
To be blunt, that's stupid.
Look for the cause, don;t fix symptoms.
p.s. if you leave out the checkpoint all that will happen is that the restart may take longer.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply