Archive

Archive for May, 2008

How to Configure the Digital Certificate on the Update Server in SCUP 2007

In System Center Updates Publisher, a digital certificate used to sign the updates in the catalog must be specified and the certificate must be copied to the appropriate certificate stores on the update server. The certificate must also be copied on the Updates Publisher computer if it is remote from the update server, before the catalog can be published to the update server. For more information about configuring the update server and creating the certificate used by the updates catalog, see How to Configure the Update Server.

There are several methods for adding the certificates to the appropriate certificate stores. The following procedure provides one method for configuring the certificate store.

To configure the certificate store on the update server

  1. Click Start, click Run, type MMC in the text box, and then click
    OK to open the Microsoft Management Console (MMC).
  2. Click File, click Add/Remove Snap-in, click Add, click Certificates,
    click Add, select Computer account, and then click Next.
  3. Select Another computer, type the name of the update server or click Browse to find the update server computer, click Finish, click Close,
    and then click OK.
  4. Expand Certificates (update server name), expand WSUS, and
    then click Certificates.
  5. In the results pane, right-click the desired certificate, click All Tasks,
    and then click Export.
  6. In the Certificate Export Wizard, use the default settings to create an export
    file with the name and location specified in the wizard. This file must be
    available to the update server before proceeding to the next step.
  7. Right-click Trusted Publishers, click All Tasks, and then click Import.
    Complete the Certificate Import Wizard using the exported file from step 6.
  8. If a self-signed certificate is used, such as WSUS Publishers Self-signed,
    right-click Trusted Root Certification Authorities, click All Tasks,
    and then click Import. Complete the Certificate Import Wizard using the
    exported file from step 6.
  9. Right-click Certificates (update server name), click Connect to
    another computer
    , enter the computer name for the Updates Publisher
    computer, and click OK.
  10. If Updates Publisher is remote from the update server, repeat steps 7 through 9 to import the certificate to the certificate store on the Updates Publisher computer.

 

Categories: ConfigMgr'07

SQL data transfer

MOVE SQL DATABASE TO NEW LOCATION

The following example moves a database that is named OnePoint. This database contains one data file, EeaData.mdf.mdf, and one log file, EeaData.ldf. If the database that you are moving has more data files or log files, specify the files in a comma-delimited list in the sp_attach_db stored procedure. The sp_detach_db procedure does not change regardless of how many files the database contains because the sp_detach_db procedure does not list the files.

* Offline your database that you want to move.

Run query as:

ALTER
DATABASE Onepoint SET OFFLINE

* After some time it will show query completed successfully and your data now switched to master.

* Detach the database as follows:

go

Sp_detach_db
‘OnePoint’

go

* Manually move database to the drive where you want to move.

* Now attach your database, run query as:

use
master
go

sp_attach_db’OnePoint’,’E:\Microsoft
SQL Server\MSSQL.1\MASQL\Data\EeaData.mdf’, E:\Microsoft SQL
Server\MSSQL.1\MASQL\Data\EeaLog.ldf’

go

* Verify the change in file locations by using the sp_helpfile stored procedure:

use
OnePoint
go
sp_helpfile
go

Categories: SQL Server