you can uninstall SP3 via control panel - uninstall program (ensure view upgrdes is ticked)

Rollback depends really on what the error is. SPs are pretty robust nowadays. Just make sure...

yes

every command you issue against the principal will be reflected on the mirror, including shrink commands

you can logship to more than one secondary so you could set up another server for reporting purposes and logship to that as well with the secondary in read_only mode.

Mirroring...

Jeff Moden (10/5/2015)

---

GilaMonster (10/2/2015)

---

Checkpoint won't...

just to clarify that a bit (should have mentioned earlier), if the required size is very large, go down to the minimum then increase in 8000MB (not 8GB) chunks so...

chuck.forbes (10/2/2015)

---

This particular database can endure no more than an hour's worth of data loss. So the prior employee has hourly differentials running with a nightly backup, with the database...

because the log is full and so will not shrink, therefore, if you do not need that data you can set recovery to simple so a checkpoint is run and...

or do you have any other components within the instance that are not at SP1, such as SSRS?

If there is nothing for the SP to upgrade, it will do nothing.

yes that will safely restart a server for you without having to go to the console to reboot it.

But it depends on why you have been asked to restart it...

As part of all instance installs I change the default initial size and growth settings to protect against lazy database creations by people or application installers.

Markus (9/3/2015)

---

We just upgraded our last few SQL2000 dbs to 2008R2 earlier this year and that was a very large project that took over 2 years to complete as it...

thanks.

someone, somewhere, sometime is going to be very happy. 🙂

to help others, what was the fix?

you can track them from this site

enter 'build lists' into the search box top right of the screen.

they are mentioned in the database weekly newsletter as well