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:03 PM
Points: 7,099, Visits: 12,608
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: Friday, August 22, 2014 6:57 AM
Points: 952, Visits: 1,159
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: Thursday, August 21, 2014 7:01 AM
Points: 914, Visits: 1,431
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: Friday, August 22, 2014 6:57 AM
Points: 952, Visits: 1,159
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, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
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