if object_id('hfitu_data') is not null drop database hfitu_data create database hfity_data on (file='hitu_data', filename='d:\hitu_data.log', maxsize=50MB, size=10MB, Filegrowth=5MB ) log on ( file='hitu_data', filename='d:\hitu_data.log', maxsize=50MB, size=10MB, filegrowth=5MB)
纠正错误 if object_id('hfitu_data') is not null drop database hfitu_data create database hfity_data on (file='hitu_data', filename='d:\hitu_data.mdf', maxsize=50MB, size=10MB, Filegrowth=5MB ) log on ( file='hitu_data', filename='d:\hitu_data.ldf', maxsize=50MB, size=10MB, filegrowth=5MB)
如果不要原来的'hfitu_data',先删除吧。不然就另起名字了。if object_id('hfitu_data') is not null drop database hfitu_data create database hfity_data
看看时候是否存在同名库文件了
drop database hfitu_data
create database hfity_data
on
(file='hitu_data',
filename='d:\hitu_data.log',
maxsize=50MB,
size=10MB,
Filegrowth=5MB
)
log on
(
file='hitu_data',
filename='d:\hitu_data.log',
maxsize=50MB,
size=10MB,
filegrowth=5MB)
if object_id('hfitu_data') is not null
drop database hfitu_data
create database hfity_data
on
(file='hitu_data',
filename='d:\hitu_data.mdf',
maxsize=50MB,
size=10MB,
Filegrowth=5MB
)
log on
(
file='hitu_data',
filename='d:\hitu_data.ldf',
maxsize=50MB,
size=10MB,
filegrowth=5MB)
drop database hfitu_data
create database hfity_data