June 7, 2011 at 5:28 am
can i apply the service pack if some database are in restoring state.
Regard's
----------
shenkar gade
June 25, 2011 at 5:55 pm
Why in the world would you ever want to even attempt that?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 14, 2011 at 8:49 am
Thank you so much.I executed the job after immediately running updateusage and the job was successful.I do not know why consistent errors seem to cropping up at a faster rate.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 15, 2011 at 6:01 am
Not sure what kapfundestanley is talking about; but probably posted to the wrong post.
=========
shenkar.g
As opc.three said, why would you want to do that?
Installing a service pack will alter the master database and perhaps the msdb. If you try to install the SP, it may fail with an error about a "database currently being restored", but I really wouldn't want to try this on anything other than an experimental sql box that I use for "breaking" sql or attempting such a thing that you may be considering.
You can't wait for a restore to complete to install the SP?
Good luck!
July 15, 2011 at 6:11 am
Wrong post sorry!
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 18, 2011 at 2:25 am
Thank you Very much, First time i am using SQL Central Blog and i did't i posted the query in wrong place.
July 18, 2011 at 2:49 am
opc.three (6/25/2011)
Why in the world would you ever want to even attempt that?
May be he has setup Log Shipping...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply