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 07, 2011 5:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 06, 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 @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
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: Yesterday @ 6:47 AM
Points: 934, Visits: 1,153
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:22 AM
Points: 881, Visits: 1,352
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: Yesterday @ 6:47 AM
Points: 934, Visits: 1,153
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 06, 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: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
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