–1创建数据库
create database testbase1
on
(name = testbase1_data,
filename = 'd:\张小山数据库\testbase1_data.mdf')
log on
(name = testbase1_log,
filename = 'd:\张小山据库\testbase1_log.ldf')
go
–2数据库文件的分离
exec sp_detach_db testbase1,true
—3.1分离数据库,再复制数据库的物理文件 —3.2停止“sql server2008服务”,再赋值数据库testbase1物理文件
–4附加数据库
exec sp_attach_single_file_db @dbname = 'testbase1',
@physname = 'g:\testbase1_data.mdf'
–5删除数据库
drop database testbase1