`
weimou66
  • 浏览: 1244735 次
文章分类
社区版块
存档分类
最新评论

当使用restore .bak文件的时候.显示如信息:Use WITH MOVE to identify a valid location for the file

 
阅读更多

1.首先使用restore Filelistonly 显示bak 文件中包含的数据库和日志文件列表

信息如下

LogicalName PhysialName

SystemCatelogFile

SystemCatelogFile_1

SystemCatelogFile2

SystemLogFile

2.使用MOVE TO

1)首先删除掉你刚才创建的DB,用来还原.bak

2) 使用如下语句(MOVE 后面的文件对应上面的LogicalName)


分享到:
评论

相关推荐

    linux.chmod.bak

    根目录777 不在怕 一个命令解决 这是CentOS 7.4版本的纯净系统目录权限文件导入出问题的机器即可 setfacl --restore=/root/linux.chmod.bak

    UE(官方下载)

    You can use these functions to insert a file into the current file, delete the active file, send the file through email, or insert a string into the file at every specified increment HTML preview ...

    ZendFramework中文文档

    1. Introduction to Zend Framework 1.1. 概述 1.2. 安装 2. Zend_Acl 2.1. 简介 2.1.1. 关于资源(Resource) 2.1.2. 关于角色(Role) 2.1.3. 创建访问控制列表(ACL) 2.1.4. 注册角色(Role) 2.1.5. 定义访问...

    pro_apache_third_edition..pdf

    Apache: The Anatomy of a Web Server.........................................................1 The Apache Source ...........................................................................................

    ghost restore.bat

    ghost restore.bat ghost restore.bat ghost restore.bat ghost restore.bat

    Sql for mysql

    CHAPTER 1 Introduction to MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.2 Database, ...

    Utilities for Windows NT 源码

    Allow password changing for users who (can) never physically log on to a computer with the CTRL-ALT-DEL dialog, but use this computer for a PPP connection or log on through a Telnet connection. ...

    The Android Developer’s Cookbook: Building Applications with the Android SDK

    to-date to reflect the newest and most widely used Android SDKs, The Android Developer’s Cookbook is the essential resource for developers building apps for any Android device, from phones to tablets...

    tModLoader.Windows.v0.11.6.2.7z

    If that file launches tModLoader or you wish to permanently revery to un-modded Terraria, you need to use steam to "verify game integrity" which will restore the files back to the un-modded Terraria....

    数位板压力测试

    The user should be able to use and control the tablet in as natural and easy a manner as possible. The user's preferences should take precedence over application requests, where possible. Here are ...

    VF辅导:内存变量操作命令及文件操作命令

    VF辅导:内存变量操作命令及文件操作命令 来源:学生大 2007年11月01日 11:35  一.内存变量操作命令:  1.显示内存变量:  格式:display memory [to printer][to 文本文件名]或  list memory [to printer][to...

    ti dsp tms2802芯片资料

    1.1 Introduction to the CPU . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 1.1.1 Compatibility With Other TMS320 CPUs . . . . . . . . . ....

    微软内部资料-SQL性能优化2

    For a process to access 3 GB of address space, the executable image must have been linked with the /LARGEADDRESSAWARE flag or modified using Imagecfg.exe. It should be pointed out that SQL Server was ...

    Radmin自动登录器v3.0-多国语言绿色版-Release1-20150615

    本程序使用INI文件实现多种语言支持,每种语言信息用一个扩展名为lng的INI格式文件存放。语言文件可以使用Unicode或ANSI格式,一般建议使用Unicode格式。这种方式具有更多扩展性,用户可以非常简单方便地添加自己的...

    iPhone3,1_6.1.3_10B329_Restore.ipsw

    iPhone3,1_6.1.3_10B329_Restore.ipsw

    iPhone1,1_1.0_1A543a_Restore.ipsw

    这是第一代iPhone的iOS1.0固件 从苹果官网下载,可以直接通过刷机工具刷入设备中,也可以通过特定软件制作虚拟机

    JavaEE 5.0 Tutorial.pdf

    The Java EE 5Tutorial For Sun Java System Application Server 9.1 Contents Preface .........................................................................................................................

    ICS delphixe10源码版

    option to restore this directory tree or you will have problems because the files would not be in their proper subdirectories. Please note most of these directories are differently named to ICS V7 ...

    acpi控制笔记本风扇转速

    Fixed a problem with the AmlFilename parameter to the DefinitionBlock() operator. An incorrect output filename was produced when this parameter was a null string (""). Now, the original input filename...

    Radmin自动登录器v3.0

    本程序使用INI文件实现多种语言支持,每种语言信息用一个扩展名为lng的INI格式文件存放。语言文件可以使用Unicode或ANSI格式,一般建议使用Unicode格式。这种方式具有更多扩展性,用户可以非常简单方便地添加自己的...

Global site tag (gtag.js) - Google Analytics