July 13, 2011 at 4:53 am
Hi all!
I have an sql server that is running the transaction log backup every 10 min.
I need to restart this server and in order to do this i will pause all the jobs that are scheduled to run on this instance. So the question is do i also need to stop the transaction log? or this has to run in any case?
Thank you all for your help.
July 13, 2011 at 5:10 am
thanoseft (7/13/2011)
Hi all!I have an sql server that is running the transaction log backup every 10 min.
I need to restart this server and in order to do this i will pause all the jobs that are scheduled to run on this instance. So the question is do i also need to stop the transaction log? or this has to run in any case?
Thank you all for your help.
What do you mean by "do i also need to stop the transaction log?".
There is no such thing (stop/start transaction long) in SQL Server. Do you mean transaction log backup log JOB?
July 13, 2011 at 5:18 am
yes the backup job.
Sorry for the wrong term.
Do i need that this does not run when i take down the cluster?
thank you
July 13, 2011 at 6:12 am
no , before shutting down the sql server, check point will be raised that will flush dirty data and log pages from the buffer cache of the current database.So you will be safe.and when you do activity in sql side after restart .that will be considered for transnational log backup
see this http://msdn.microsoft.com/en-us/library/aa174542%28v=sql.80%29.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 13, 2011 at 7:14 am
so after i restart the cluster i will get the database back automaticaly and re enable my jobs. ( i wont disable the transaction log backup job)
I have never done this. I just simply disable the jobs and then restart the clustered instance through the clustered administrator, there is no need to put the DBs in any mode or the sql server or sth else?
Thank you all for your help and input
July 13, 2011 at 9:00 am
you don't need to disable the jobs to restart the instance!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:28 am
hi and thanx for your replies.
I will prefer to disable the jobs before the restart because the backup takes 6 hours to perform and i do not want it to run while i am restarting.
Thank you again for your suggestions and all your help!
July 14, 2011 at 1:32 am
thanoseft (7/14/2011)
and i do not want it to run while i restarting
???????
All operations are rolled back anyway. Do what you must but there is no need to disable the jobs while restarting the SQL server instance!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 5:18 am
I do not mean that they will be running while restarting. however i do not see the point in starting a job that needs 6 hours to run, let it run for an hour, roll it back and then restart it 🙂
Anything else i should pay attention to when restarting?
Thank you for your help
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply