Move it not necessary for attach, simply it will be to copies, one working and ond as garbage. Anyway I prefer copying, not moving, after full testing simpy delete first one.
WSUS has two modes of work - first (by default as named instance (usually with MSDE) and as particular database in default instance). First mode isolate each instance, second one conserve a resources. Anatoly Podgoretsky http://www.podgoretsky.com ----- Original Message ----- From: Miller Bonnie L. To: NT System Admin Issues Sent: Monday, June 23, 2008 6:04 PM Subject: RE: WSUS question Joe-I'm not a SQL guru, but had to move a WSUS db from one drive letter to another a couple of times due to space issues. I did a small write-up for myself and will send it to you a sanitized version offlist-maybe it will help. -Bonnie From: Joe Heaton [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 7:28 AM To: NT System Admin Issues Subject: RE: WSUS question When we do this, should I delete the database in the new install location after detaching from it, then copy the old one in, then attach? Joe Heaton ------------------------------------------------------------------------------ From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 3:47 PM To: NT System Admin Issues Subject: RE: WSUS question Sp_detachdb.. Sp_attach_single_file_db Best to get your DBA involved if you aren't comfortable with t-sql. Regards, Michael B. Smith MCITP:EM/MCSE/Exchange MVP http://TheEssentialExchange.com From: Joe Heaton [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 6:34 PM To: NT System Admin Issues Subject: RE: WSUS question Well, I found the old susdb.mdf, it is in fact in a different folder. Any idea if it is possible to have WSUS connect to it, instead of using the blank database it created on install? Joe Heaton ------------------------------------------------------------------------------ From: Damien Solodow [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 2:59 PM To: NT System Admin Issues Subject: RE: WSUS question I think it's susdb.mdf, but you probably don't have many mdf files on the server in the first place. From: Joe Heaton [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 5:56 PM To: NT System Admin Issues Subject: WSUS question Well, my DB manager got a bit over-zealous a few weeks ago, and removed SQL from my WSUS server. Needless to say, that's not a good thing. Today, I downloaded WSUS 3.0 SP1, ran the install, told that to NOT delete the database, and yet, when I now get into it, there are no computers, no updates, nada. I'm hoping there's a small chance that the original installation was not in the default directories, which brings me to my question to you fine people: Does anyone know what the database is actually called, so I could try to do a search for it? Is it possible, if this database does exist in some other directory, to connect my installation to it, or to move it into the directory that the installation is looking in? Thanks in advance, Joe Heaton AISA Employment Training Panel 1100 J Street, 4th Floor Sacramento, CA 95814 (916) 327-5276 [EMAIL PROTECTED] ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
