备份数据库
BACKUP DATABASE job TO DISK='D:job.bak'
go
删除原有数据库并建立新的数据库
IF EXISTS (Select name FROM master.dbo.sysdatabases Where name = N'job')
Drop DATABASE [job]
GO
Create DATABASE job
go
还原数据库并移动到 E 盘
RESTORE DATABASE job FROM DISK='D:job.bak'
with
move 'job' to 'E:job.mdf',
move 'job_log' to 'E:job_log.ldf'
go
分离数据库
sp_detach_db 'job'
go
附加数据库
sp_attach_db job,'E:job.mdf','E:job_log.ldf'
go