老兄,给点分吧
use masterif not exists (select * from sysdatabases where name = 'fuel')
begin
CREATE DATABASE fuel
ON
( NAME = fuel_dat,
FILENAME = 'c:\mssql7\data\fuel_dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'fuel_log',
FILENAME = 'c:\mssql7\data\fuel_log.ldf',
SIZE = 1MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
end;RESTORE DATABASE fuel FROM DISK = 'C:\fuel\initdata.bak' WITH MOVE 'test2_data' TO 'c:\mssql7\data\fuel_dat.mdf', MOVE 'test2_log' TO 'c:\mssql7\data\fuel_log.ldf'
,replace;
use masterif not exists (select * from sysdatabases where name = 'fuel')
begin
CREATE DATABASE fuel
ON
( NAME = fuel_dat,
FILENAME = 'c:\mssql7\data\fuel_dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'fuel_log',
FILENAME = 'c:\mssql7\data\fuel_log.ldf',
SIZE = 1MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
end;RESTORE DATABASE fuel FROM DISK = 'C:\fuel\initdata.bak' WITH MOVE 'test2_data' TO 'c:\mssql7\data\fuel_dat.mdf', MOVE 'test2_log' TO 'c:\mssql7\data\fuel_log.ldf'
,replace;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货