当使用restore .bak文件的时候.显示如信息:Use WITH MOVE to identify a valid location for the file
来源:互联网 发布:手机淘宝店招图 编辑:程序博客网 时间:2024/06/05 03:26
1.首先使用restore Filelistonly 显示bak 文件中包含的数据库和日志文件列表
RESTORE FILELISTONLY FROM DISK = 'D:\FMSDB\AuthoringTool\FMSGuo.bak'
信息如下
LogicalName PhysialName
SystemCatelogFile
SystemCatelogFile_1
SystemCatelogFile2
SystemLogFile
2.使用MOVE TO
1)首先删除掉你刚才创建的DB,用来还原.bak
2) 使用如下语句(MOVE 后面的文件对应上面的LogicalName)
RESTORE DATABASE FMSAuthoringDB FROM DISK = 'D:\FMSDB\AuthoringTool\FMSGuo.bak'WITH MOVE 'SystemCatalogFile' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data.mdf',MOVE 'SystemLogFile' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data.ldf',MOVE 'SystemCatalogFile_1' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data_1.ldf'MOVE 'SystemCatalogFile2' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WS_HGO\MSSQL\DATA/FMSAuthoringDB_data_2.ldf',NOUNLOAD, REPLACE
- 当使用restore .bak文件的时候.显示如信息:Use WITH MOVE to identify a valid location for the file
- unable to dequeue a cell with identifier Identify - must register a nib or a class for the identifie
- How to use iPhone with File I/O Functions: A Tutorial for Software Developers
- How to use iPhone with File I/O Functions: A Tutorial for Software Developers
- ERROR: Unable to identify a valid CodeWarrior for Symbian OS installation
- 在重做系统的时候 出现了“output error file to the following location 的提示
- 换bak 文件-debug 请使用WITH MOVE选项来 xxx 错误
- 126.Identify the two situations in which you use the alert log file in your database to check the de
- restore bak 文件
- RESTORE DATAFILE TO A NEW LOCATION
- 当使用phpize的时候出现Can't find PHP headers in /usr/include/php The php-devel package is required for use o
- How to identify the location of DIMM or CPU
- Creating a Data dictionary file to use with LogMi
- How to use a CSV file with JMeter
- 解决Genymotion模拟器无法使用问题“the file is currupt”,“uable to boot-please use a kernel appropriate for your c
- matlab出现Invalid file identifier. Use fopen to generate a valid file identifier错误
- matlab出现Invalid file identifier. Use fopen to generate a valid file identifier错误
- The server failed to respond with a valid HTTP response
- ECB CBC DES TDES
- 歌词悬浮
- 关于Jquery的日历控件
- GPS 研究一 (Android2.3)
- java 实现二分查找法
- 当使用restore .bak文件的时候.显示如信息:Use WITH MOVE to identify a valid location for the file
- GPS 研究二 (Android 2.3__gingerbread)
- android 小技巧 EditText密码模式 与 水印功能
- return 2011.06.03
- C#与Matlab混合编程入门教程一:几种混合编程的方法
- GPS 研究三 (android2.3__gingerbread)
- TabHost ----使用1(用代码来实现功能但没有将界面设计和代码分开)
- 如何在matla中修改传进来的参数
- MySQL字符集管理