Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-03-15 : 06:02:23
|
| Hi allNormally when I try to restart the SQL service for a reason, couple thing that I look at it before shutting SQL:1. Look the job that is currently is running or not2. Look at the Process Info (status and Login Time)The schenario is that the box has many databases and we don't have a time to let other user get out from the system or potentially that there is scheduled job that running within from instance that we don't know.Am I looking the right thing here before restarting the service? What is the best practise anyway to handle this.I am appreciated your comment.Thanks |
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-03-15 : 13:22:25
|
| schedule the restart, first send out emails, pause all jobs then restart.Jay |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-03-16 : 16:48:12
|
| Anyone have another input regarding this? |
|
|
|
|
|
|
Restarting the SQL Service