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: Yesterday @ 7:01 PM
Points: 7,139, Visits: 12,762
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: Tuesday, December 2, 2014 8:35 AM
Points: 968, Visits: 1,173
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: Tuesday, December 2, 2014 5:58 AM
Points: 924, Visits: 1,445
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: Tuesday, December 2, 2014 8:35 AM
Points: 968, Visits: 1,173
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, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
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