How to move HP SIM SQL 2005 SP2 database (492087-002, January 2009)

11
Moving
HP SIM
SQL
Server
2005
SP2
d
atabase f
rom a
local to a remote machine
1.
Stop and
d
isable the HP SIM service running on Machine 1.
2.
Open SQL Server Management Studio in Machine 1
(Programs

Microsoft SQL server 2005

SQL Server Management Studio)
Figure 1
4
.
Connecting to SQ: Server
3.
With defaul
t settings in the Connect to Server window, click
“
Connect
”
.
4.
Write down the database name. For example,
Insight_v50_xxxxxxxxx
.
5.
Create a new SQL
server 2005
Database on the target machine (Machine 2).
a)
Open SQL Server Management Studio in Machine 2.
(
Program
s

Microsoft SQL server 2005

SQL Server Management Studio
)
b)
Right click
Database
and select
New Database
.