Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

installing service pack Expand / Collapse
Author
Message
Posted Tuesday, June 7, 2011 5:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 12:03 AM
Points: 20, Visits: 93
can i apply the service pack if some database are in restoring state.

Regard's
----------
shenkar gade
Post #1120894
Posted Saturday, June 25, 2011 5:55 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, July 26, 2014 8:57 AM
Points: 7,081, Visits: 12,575
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
Post #1131718
Posted Thursday, July 14, 2011 8:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:24 AM
Points: 952, Visits: 1,156
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
Post #1141821
Posted Friday, July 15, 2011 6:01 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:35 AM
Points: 905, Visits: 1,416
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!



Post #1142410
Posted Friday, July 15, 2011 6:11 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:24 AM
Points: 952, Visits: 1,156
Wrong post sorry!

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1142422
Posted Monday, July 18, 2011 2:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 12:03 AM
Points: 20, Visits: 93
Thank you Very much, First time i am using SQL Central Blog and i did't i posted the query in wrong place.
Post #1143246
Posted Monday, July 18, 2011 2:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
opc.three (6/25/2011)
Why in the world would you ever want to even attempt that?

May be he has setup Log Shipping...
Post #1143256
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse