Move the database from the SCE server to another SQL server after an install
Is there a way that I can move the SCE database to another SQL box after I've already installed SCE? SQL is killing my processor and I want to move the Database off to a SQL 2005 box with more than enough horse power.
May 6th, 2007 11:50pm

We do not support moving the database to a new server. The only support we really have for something like this isthe backup/recovery scenario: 1. Backup all 3 databases and the WSUS content directory (C:\SCE) 2. Reinstall SCE to a server with the same name, and select a SQL instance with the same name as the previous installation 3. Stop the services, detach the databases, and attach the backed up databases. 4. Repair all agent if Local Policy option was used.
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2007 5:10am

HiIs this still true with SCE2007 SP1 / WSUS SP1?CheersMichel
March 14th, 2008 1:31am

Bump. Any answer to this?
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2008 3:48pm

Can anyone from the SCE team post an answer to this important question?
July 29th, 2009 3:48pm

Can anyone from the SCE team post an answer to this important question? I'm not from the SCE team, but i'v done it and it works! http://technet.microsoft.com/en-us/library/bb437269.aspx : http://dimka.yz74.ru
Free Windows Admin Tool Kit Click here and download it now
September 26th, 2009 7:51am

Is this still true for SCE 2010?
October 27th, 2010 10:39am

Is this still true for SCE 2010?
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2010 10:39am

What about using a SQL Alias to point to the new SQL server? Is that a posibility?
March 29th, 2011 10:11am

I did use a SQL Alias to point SCE 2007 to a new SQL server and that worked just fine for me.
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 9:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics