Steve Jones - Editor (1/9/2009)

---

George, they should be placed according to some standard when you install, but two issues. One is people not familiar with SQL, or perhaps with your...

John Erdovegi (1/9/2009)

---

webrunner (1/9/2009)

---

. . .

1. If the current photo says what you like, then leave it.

2. If you want to dress up a bit, you could make...

This question brings up a real bugbear for me. Why move the system databases at all? why not put them where you want them in the first place as part...

I used to work fully 'suited and booted' but lately have morphed to not bothering wearing a tie as it was getting uncomfortable, and no-one seems to be bothered, nor...

have you got a backup from before you lost it? you could restore that under a different database name and retrieve code from there.

Is systemcentereporting not the MI database behind...

Jennifer Vanderschans (1/8/2009)

---

If I understand you correctly, you'd like to push out the service pack to all of your servers using WSUS, but then apply it manually on each server....

to be able to restore across the network Sql must run under an account that has network privileges. Local system has no such rights, being 'local' to the server. That...

MANU (1/7/2009)

---

1) The SQL Server services, on the Server containing the instance of SQL Server, must be running under a domain-level account (e.g. A Domain Administrator account). This is accomplished...

I would ask if a standby solution is required why on earth you are not allowed to use a domain user account with the correct privileges. AD can be used...

sorry, as I said , don't feel qualified to give a steer either way..............

You would want to check if wsus has advantages over an unattended install from the command line...

thanks for the input Gail.

I feel the need to 'bump' this thread as maybe it was missed having being raised at the weekend.

Anyone out there using SQL 2008 and want...

sorry I don't know wsus well enough to give a definitive answer, you would expect to be able to though.

personally I would be only applying service packs on a per...

do not use it myself, but did partake in a post on this forum where wsus caused problems, see

http://www.sqlservercentral.com/Forums/Topic612095-48-1.aspx

personally I would not want any automated process applying patches to SQL,...

yes. You may want to do a find\replace of...

Mani (1/6/2009)

---

We are doing side-by-side upgrade. In sql server 2005 also when we create maintenance plan,the related job will be created under jobs section right? So if we ran the...