Shulou(Shulou.com)06/01 Report--

[sybase@cnpm_server] $isql-Usa-P12345678

1 > use master

2 > go

1 > load database smss from'/ opt/sybase/130620_131112.dmp'

2 > go

Msg 3101, Level 16, State 1:

Server 'CNPM_SERVER', Line 1:

Database in use. A user with System Administrator (SA) role must have exclusive

Use of database to run load.

1 > select spid,hostname,loggedindatetime,ipaddr from master.dbo.sysprocesses where db_name (dbid) = 'smss'

2 > go

Spid hostname loggedindatetime

Ipaddr

-

58 localhost.localdomain Mar 7 2014 9:59AM

192.168.1.236

(1 rows affected)

1 > select 'kill' + convert (varchar,spid) from master.dbo.sysprocesses where db_name (dbid) = 'smss'

2 > go

-

Kill 58

(1 rows affected)

1 > kill 58

2 > go

1 > load database smss from'/ opt/sybase/130620_131112.dmp'

2 > go

Backup Server session id is: 19. Use this value when executing the

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.