--创建数据库
use master
create database StudentMS--数据库名s
on(
name='StudentDB_data',---‘逻辑名’
fileName='C:\Users\lol\Desktop\Data\StudentDB.mdf',--'物理名及路径'
size=3MB,
fileGrowth=1MB,
maxsize=100MB
)
,
(
name='StudentDB_data2',
fileName='C:\Users\lol\Desktop\Data\StudentDB.ndf',
size=3MB,
?}::>>>>>>=1MB,
maxsize=100MB
)
log on(
name='StudentDB_log',
fileName='C:\Users\lol\Desktop\Data\StudentDB.ldf'
)
GO
--删除数据库
if DB_ID('StudentMS') is not null
drop database StudentMS
--分离数据库
exec sp_detach_db 'StudentMS'
GO
--附加数据库
exec sp_attach_db 'StudentMS','e:\data\studentdb.mdf','e:\data\studentdb.ndf','e:\data\studentdb.ldf'