Question

SQL Server2008如何把数据库建立在指定路径

CREATE DATABASE db09072215
ON
( NAME = db09072215_data,
FILENAME = 'E:\lsq\db09072215.mdf',
SIZE = 3,
MAXSIZE = 5,
FILEGROWTH = 1 )
LOG ON
( NAME = db09072215_log,
FILENAME = 'E:\lsq\db09072215.mdf',
SIZE = 3,
MAXSIZE = 5,
FILEGROWTH = 1 )

Cannot create file 'E:\lsq\db09072215.mdf' because it already exists. Change the file path or the file name, and retry the operation.
可是我E盘lsq文件夹是空的 为什么说已经存在了呢 求高人指点

Answer 1

LOG ON
( NAME = db09072215_log,
FILENAME = 'E:\lsq\db09072215.mdf',
log的文件名filename不对，与data文件名一样了，所以会说存在了。

兄弟，给分哦