installing service pack

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Disaster Recovery » installing service pack

installing service pack

Rate Topic

Display Mode

Topic Options

Author

Message

shenkar.g

Posted Tuesday, June 07, 2011 5:28 AM

Grasshopper

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

opc.three

Posted Saturday, June 25, 2011 5:55 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 6,826, Visits: 11,950

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

kapfundestanley

Posted Thursday, July 14, 2011 8:49 AM

Right there with Babe

Group: General Forum Members
Last Login: Monday, June 10, 2013 1:49 AM
Points: 781, Visits: 1,050

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

Steve-3_5_7_9

Posted Friday, July 15, 2011 6:01 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:21 AM
Points: 812, Visits: 1,202

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

kapfundestanley

Posted Friday, July 15, 2011 6:11 AM

Right there with Babe

Group: General Forum Members
Last Login: Monday, June 10, 2013 1:49 AM
Points: 781, Visits: 1,050

Wrong post sorry!

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Post #1142422

shenkar.g

Posted Monday, July 18, 2011 2:25 AM

Grasshopper

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

Suresh B.

Posted Monday, July 18, 2011 2:49 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:54 AM
Points: 1,076, Visits: 5,128

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 »

Permissions