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

-- connect to the database

Isql-Usa-Scmproce

-- Building equipment

Disk init name=contract_data2011_new,physname='d:\ sybase_db\ data\ contract_data2011_new.dat',size='6500M'

Go

Disk init name=contract_log2011_new,physname='d:\ sybase_db\ data\ contract_log2011_new.dat',size='3000M'

Go

-- Building a database

Create database contract2011_new on contract_data2011_new=6500 log on contract_log2011_new=3000

Go

-- Source database backup data

Dump database contract2011 to'd:\ contract2011.dmp'

Go

-- the target database recovers data

Load database contract2011 from'd:\ contract2011.dmp'

Go

Online database audit

Go

Modify the settings of the device:

Sp_configure 'number of device',20

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.