SQL2005使用sql语句备份还原数据库

备份一句话
backup database zlhotel to disk = 'zlhotel.bak' with init
还原三句话：


alter database zlhotel set offline with rollback immediate
restore database zlhotel from disk= 'zlhotel.bak' with recovery
alter database zlhotel set online with rollback immediate