create database YGGL
ON
( name='YGGL_Data',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=10MB,
maxsize=50MB,
filegrowth=5%
)
log on
( name='YGGL_Log',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=2MB,
maxsize=5MB,
filegrowth=1MB
)
服务器: 消息 5170,级别 16,状态 1,行 1
无法创建文件 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',因为该文件已存在。
服务器: 消息 1802,级别 16,状态 1,行 1
CREATE DATABASE 失败。未能创建所列出的某些文件名。请检查前面的错误信息。我以前在企业管理器中添加过同名数据库YGGL,但已经删除了啊,'C:\Program Files\Microsoft SQL Server\MSSQL\Data\'
下没有YGGL_mdf啊,怎么提示文件已存在呢?
ON
( name='YGGL_Data',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=10MB,
maxsize=50MB,
filegrowth=5%
)
log on
( name='YGGL_Log',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=2MB,
maxsize=5MB,
filegrowth=1MB
)
服务器: 消息 5170,级别 16,状态 1,行 1
无法创建文件 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',因为该文件已存在。
服务器: 消息 1802,级别 16,状态 1,行 1
CREATE DATABASE 失败。未能创建所列出的某些文件名。请检查前面的错误信息。我以前在企业管理器中添加过同名数据库YGGL,但已经删除了啊,'C:\Program Files\Microsoft SQL Server\MSSQL\Data\'
下没有YGGL_mdf啊,怎么提示文件已存在呢?
ON
( name='YGGL_Data',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=10MB,
maxsize=50MB,
filegrowth=5%
)
log on
( name='YGGL_Log',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_ldf',
size=2MB,
maxsize=5MB,
filegrowth=1MB
)
ON
( name='YGGL_Data',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=10MB,
maxsize=50MB,
filegrowth=5%
)
log on
( name='YGGL_Log',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=2MB,
maxsize=5MB,
filegrowth=1MB
)红色的路径部分改成C:\试试
'C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf'
ON
( name='YGGL_Data',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf',
size=10MB,
maxsize=50MB,
filegrowth=5%
)
log on
( name='YGGL_Log',
filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\YGGL_mdf', -- YGGL_ldf ??
size=2MB,
maxsize=5MB,
filegrowth=1MB
)
USE master;
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\saledat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = Sales_log,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB ) ;
GO
goif exists(select * from sysdatabases where name='YGGL_Data')
drop database YGGL_Data
--后面再加上你的创建数据库的代码、