![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
备份一句话
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