SQLServer2008还原数据库3154错误解决方法
发布时间：2020-12-12 13:40:57 所属栏目：MsSql教程 来源：网络整理
导读：USE MASTER RESTORE DATABASE DB_DEMO FROM DISK = 'D:DB_DEMO_backup.bak' WITH MOVE 'DB_DEMO' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADB_DEMO.mdf', MOVE 'DB_DEMO_LOG' TO 'D:Program FilesMicrosoft SQL Ser
|
USE MASTER
RESTORE DATABASE DB_DEMO FROM DISK = 'D:DB_DEMO_backup.bak' WITH MOVE 'DB_DEMO' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADB_DEMO.mdf', MOVE 'DB_DEMO_LOG' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADB_DEMO_log.ldf', STATS = 10,REPLACE GO ps.原因在于备份数据库物的理文件名，物理地址在还原环境上有所改变. （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |