Congrats. What does that qualify you for?

I am afraid you cannot use the rolling upgrade method on SQL2005, you have to apply it to the active node and it does all the nodes together.

therefore you cannot...

MysteryJimbo (2/20/2014)

---

george sibbald (2/20/2014)

---

MysteryJimbo (2/20/2014)

---

george sibbald (2/20/2014)

---

MysteryJimbo (2/20/2014)

---

You don't even need a full backup to be restored. If...

MysteryJimbo (2/20/2014)

---

george sibbald (2/20/2014)

---

MysteryJimbo (2/20/2014)

---

You don't even need a full backup to be restored. If you have a...

MysteryJimbo (2/20/2014)

---

george sibbald (2/19/2014)

---

you don't have to reconfigure from scratch, you can use the existing logshipping jobs and shares etc, you just need to reinitialise the database with a norecovery...

interesting, thanks for posting back solution. was it just the one job with the error, others were OK?

I would check the errorlog immediately after the upgrade when the instance was in script upgrade mode and make sure there are no errors in there.

you don't have to reconfigure from scratch, you can use the existing logshipping jobs and shares etc, you just need to reinitialise the database with a norecovery restore. That in...

OCTom (2/18/2014)

---

The following was in 1991 and in response to the question, "How many seminars or classes have you attended to keep up on technology?"

Answer: "I'm not really into continuing...

by running SSMS on the server you are using resources on the server.

There is usually a limit to the number of RDP connections that can be made as well.

cough

good stuff.

dear oh dear, strange choice of column types!

please post the schema for the table, any column types such as varbinary?

500000 could be a bit over the top, it has an effect on msdb size.