RESTORE DATABASE his

FROM DISK = ‘E:\RDHL文件\HIS相关文档\数据库备份\biaozhun.bak’

with replace,

MOVE ‘his’ TO ‘C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\his.mdf’,

MOVE ‘his_log’ TO ‘C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\his_log.ldf’

his为数据库,要在系统数据库mastre上右键新建查询

发表评论

共有 0 条评论