문의자

re installing sce2007 sp1 problems

질문

After problems with sce2007 sp1 i decided to remove and install sce2007 sp1. The current version registered i had did not install so i downloaded the newest sce2007 sp1 and that installed. Before i made a backup in SQL management studio for every database.
Now i am trying to restore all the settings in sce2007 but restoring the databases or re attach the databases is nog possible, different errors appearing.

What i see in the folders where the database backups are made there is no .bak files bu all mdf files. So restoring is not possible only attach i believe. I also see in the management studio that there is, now after the install off sce, no OperationmanagerDW
database and no WSUS database, they where there before the deinstall?
I had also made printscreen for the locations where the files for the database where and saw that the OperationmanagerDW database was the same file as OperationManager database.

So how can i restore the databases or settings for sce. I have downloaded a instruction from Microsoft that says to de attach the current databases and attach the new one but that fails..error opening the physicall file, not found....but the file is there..

There are a few questions now restoring the settings for sce is the most important because i don't know the settings...
The systems that where monitored can be installed again that is no problem..

To restore Essentials 2007 data

Repair the failing management server, or designate a new server for that role. In either case, follow these guidelines:

The new management server must be configured with the original management server name.

The new management server must be in the same original domain. If it was not possible to properly uninstall Essentials 2007 after the failure, then you must delete the computer container for the Essentials 2007 management server prior to re-joining
the server to the domain.

If Active Directory has also been failing, then it must be restored. Ensure that the System Center Essentials All Computers Policy and the SCE managed computers policy ([SCESERVER]_MG) exist.

If you have a backup of the update content files folder, copy those files into a location that the Essentials 2007 Management Server can access.

Install Essentials 2007 on the new management server:

Select a database instance with the same name as the previous Essentials 2007 database instance.

Set ENABLE_BROKER for the OperationsManager database if needed. See the Set ENABLE_BROKER section below to determine if this step is needed, and for information about how to perform it.

Run the SecureStorageBackup tool from the System Center Essentials 2007 installation folder, and use the Encryption Key Backup or Restore Wizard to restore the management server encryption key. For information about how to restore the encryption key, see How
to Restore the Encryption Key.

Restart the following services:

OpsMgr Health Service

OpsMgr Config Service

OpsMgr SDK Service

Update Services

If you are running the SP1 version of Essentials 2007, then you can restore the WSUS Code Signing Certificate as follows:

In the Add Standalone Snap-in dialog box, in the Snap-in list, double-click Certificates.

On the Certificates snap-in page, click Computer account, and then click Next.

In the Select Computer page, select Local computer, and then click Finish.

Close the Add Standalone Snap-in dialog box, and then click OK the Add/Remove Snap-in dialog box.

In the Console Root window, expand Certificates (Local Computer).

Run the Certificate Import Wizard to import the <SCE InstallDir>/Certificates/WSUSCodeSigningCert.cer (the WSUS code signing certificate file) to the Local Computer Trusted Publisher store, the Trusted Root
Certification Authorities, and the Third-Party Root Certification Authorities stores.

Use the WSUSCertificateRestore.exe tool to restore the WSUS Code Signing Certificate’s PFX file to the management server. In a command prompt, go to the <SCE installation>\Tools folder, and type:

WSUSCertificateRestore [PFXCertificateFile] [PFXPassword]

Ensure that the WSUSCodeSigningCert.cer certificate file is in the <SCE Installation>/Certificates folder.

If the domain based policies System Center Essentials All Computers Policy and the SCE managed computers policy ([SCESERVER]_MG) were previously used, and are no longer available in Active Directory, then start the Essentials 2007 console, and run the
Feature Configuration Wizard to re-create them.

Run the Certificate Import Wizard to import the <SCE InstallDir>/Certificates/WSUSSSLCert.cer certificate file to the Local Computer Trusted Root Certification Authorities store.

If using local policy or if the domain based policy is still available, attach the WSUSSSLCert.cer to the WSUS Administration website in IIS. Ensure that the WSUSSSLCert.cer certificate file is in the <SCE Installation> /Certificates folder.

This step is necessary only if you selected the Local Policy option for configuring Essentials 2007 servers and managed computers in the Feature Configuration Wizard. Select the Repair option for all
managed computers as follows:

In the Essentials 2007 console, click the Administration button.

In the Administration pane, expand Device Management.

Click Agent Managed.

Right-click all managed computers, and click Repair.

If any computers were added after the date of the database snapshot, then you can restore them as follows:

In the Essentials console, select Administration.

In the Administration pane, select Settings.

In the Settings pane, expand the Server group, and double-click Security.

In the Server Settings–Security dialog box, select the Review new manual agent installation in pending management view option, and then click OK.

You can view and re-approve these agents in the Administration pane when you expand Device Management, and Pending Management.

Set ENABLE_BROKER

Before you can run tasks and use the Discovery Wizard to install agents, you need to set the ENABLE_BROKER value.

After moving the OperationsManager database, the status of the Sql Broker Availability Monitor might be set to ‘critical’ or to 'Sql Broker is disabled'. You can check the state of the Sql Broker Availability Monitor by running the following SQL query:

SELECT is_broker_enabled FROM sys.databases WHERE name='OperationsManager'

Where ‘OperationsManager’ is the default database name, replace this name as appropriate.

If the query result is ‘0’, then the Sql Broker is disabled and you must re-enable it using the following procedure.

To set ENABLE_BROKER

Open SQL Server Management Studio.

In the Connect to Server dialog box, select the appropriate values in the Server type list, in the Server name list, in the Authentication list, and
then click Connect.

Closing SQL Server Management Studio closes the connection to the database in single user mode. Depending on your configuration, you may have to manually kill any process that is connected to the database before completing the ALTER query below.

Open SQL Server Management Studio.

In the Connect to Server dialog box, select the appropriate values in the Server type list, in the Server name list, in the Authentication list, and
then click Connect.

Click New Query.

In the query window, enter the following query:

ALTER DATABASE OperationsManager SET MULTI_USER

Click Execute.

You can verify the setting for ENABLE_BROKER is set to 1 by using this SQL query: SELECT is_broker_enabled FROM sys.databases WHERE name='OperationsManager'.

Note

Before you can use discovery, you must restart the following services: OpsMgr SDK Service, OpsMgr Config Service, and OpsMgr Health Service.
You may also need to restart the following services: SQL Server and SQL Server Agent.

Repeat step b for the WSUS and the Essentials 2007 Data Warehouse databases?

Is this the OperationManagerDW. This database is not present after a restore and like i mentioned in the ts this database used the same file as Operationmanager.mdf.. How do i attach it then. And the problem is that i get a error with the attaching of the
database, that is the problem....

I now have for example detach the temp database and tried to re attach it: a error appears. Then i thought maybe delete the temp database and try to restore it or re attach it but his also results in a error: database already excists but i can't see it anymore....restart
the services sql does not had a good result..

It looks simple deattaching and re attaching but it doesn't work by me. Must the services of sql running while re attaching or restoring anything?