如何创建数据库

[sunnyforever]

create database archive
on
primary (name=arch1,
filename='D:\program files\microsoft sql server\mssql\data\archdat1.mdf',
size=10,
maxsize=20,
filegrowth=2),
(name=arch2,
filename='D:\program files\miscrosoft sql server\mssql\data\archdat2.mdf',
size=10,
maxsize=20,
filegrowth=2),
(name=arch3,
filename='D:\program files\miscrosoft sql server\mssql\data\archdat3.mdf',
size=10,
maxsize=20,
filegrowth=2)
log on
(name=archlog1,
filename='D:\program files\microsoft sql server\mssql\data\archlog1.ldf',
size=10,
maxsize=20,
filegrowth=2),
(name=archlog2,
filename='D:\program files\microsoft sql server\mssql\data\archlog2.ldf',
size=10,
maxsize=20,
filegrowth=2)
go
每次运行这些语句时，都出现如下错误：
服务器: 消息 5105，级别 16，状态 2，行 1
设备激活错误。物理文件名 'D:\program files\miscrosoft sql server\mssql\data\archdat2.mdf' 可能有误。
服务器: 消息 1802，级别 16，状态 1，行 1
CREATE DATABASE 失败。未能创建所列出的某些文件名。请检查前面的错误信息。


请哪位高人给解答一下，谢谢

注：我的SQL安在D盘上

[Rotaxe]

检查一下'D:\program files\miscrosoft sql server\mssql\data目录是否存在

[zjcxc]

create database archive
on
primary (name=arch1,
filename='D:\Program Files\Microsoft SQL Server\MSSQL\Data\archdat1.mdf',
size=10,
maxsize=20,
filegrowth=2),
(name=arch2,
filename='D:\Program Files\Microsoft SQL Server\MSSQL\Data\archdat2.mdf',
size=10,
maxsize=20,
filegrowth=2)
go

[zjcxc]

--楼主写错了目录:
'D:\program files\miscrosoft sql server\mssql\data\archdat2.mdf'
^^^^^^^^^^
应该是 microsoft

[sunnyforever]

我的下'D:\program files\miscrosoft sql server\mssql\data目录存在

[zjcxc]

--查询分析器中执行下面语句的结果是什么?

exec master..xp_dirtree 'D:\program files\miscrosoft sql server\mssql\data',1,1