sqlserver2005新建库时如何指定mdf和ldf的存放路径

2025-06-22 10:03:57
推荐回答(1个)
回答1:

create database temp1
on
(
NAME=temp1_data,
FILENAME='D:\Jane.Wang\temp1_data.mdf'
)
LOG ON
(
NAME=temp1_log,
FILENAME='D:\Jane.Wang\temp1_log.ldf'
)