备份还原数据库的语句

备份数据库
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