现有快表free后台数据库sql2005企业版,快表free后台数据库sqlserver2005express两个系统,将后者备份的数据还原到前者时出现3154错误,经过网上查找,最终解决,具体见如下链接
http://www.cnblogs.com/dachie/archive/2011/12/14/2287496.html
完成后,需要重新注册无限用户、无限模板,然后好像正常了,我的仿照代码如下,希望对大家有帮助
RESTORE DATABASE KuaibiaoFree FROM DISK='H:\KBBACK\20170519.bak'with replace, MOVE 'KuaibiaoFree_data' TO 'D:\Microsoft SQLServer\MSSQL.1\MSSQL\Data\KuaibiaoFree_data.mdf', MOVE 'KuaibiaoFree_LOG' TO 'D:\Microsoft SQLServer\MSSQL.1\MSSQL\Data\KuaibiaoFreee_LOG.Ldf'
|
xuechen