`

还原出错:the backup set holds a backup of a database other than the existing,

 
阅读更多
mssql server 2005还原出错:the backup set holds a backup of a database other than the existing,error:3154

特别是,导入外面的数据时,可能mdf或ldf的路径与本机的不一样,导致用界面操作无法导入。此时建议用命令导入:

restore database Test
from disk = 'C:\share\20120111TestDB.bak'
with replace,
move 'Test' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf',
move 'Test_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test_log.ldf'

分享到:
评论

相关推荐

    SSD7 选择题。Multiple-Choice

    (b) the name of the table, the names of the table's attributes, the data types of the table's attributes, the formats of the table's attributes, and the maximum number of rows that the table can have...

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

    In our example, if one transaction (T1) holds an exclusive lock at the table level, and another transaction (T2) holds an exclusive lock at the row level, each of the transactions believe they have ...

    Create a package Vehicles (a sub-directory under the working directory) that holds the

    Define an abstract class Vehicle in the file Vehicle.java, add data members that can ...The class Motor holds extra information for price of the vehicle. Define necessary methods in the class Motor.

    新视野大学英语第二册教学4PPT课件.pptx

    * routine conference: 例句:The company holds a routine conference every Monday morning. 2. DEPARTURE * 例句:I saw Simon shortly before his departure for Russia. * 例句:His parents will depart ...

    JVM内核架构--JVM规范

    hold the state of each method (java method, not a native method) invocations for the thread such as the local variables, method arguments, return values, intermediate results. Each entry in the Java ...

    EhLib 9.1.038 for D7-XE-10.2

    The EhLib set contains components and classes for various versions of the Delphi programming language and to increase the capacity of the user’s database database software to interact with users. ...

    We.are.Big.Data.The.Future.of.the.Information.Society.946239182

    Sander Klous holds a PhD in High Energy Physics and contributed to the discovery of the Higgs boson at CERN (Nobel prize 2013). Klous works at KPMG and is professor in Big Data at the University of ...

    Google C++ Style Guide(Google C++编程规范)高清PDF

    On the other hand, you must include the header file for Foo if your class subclasses Foo or has a data member of type Foo. Sometimes it makes sense to have pointer (or better, scoped_ptr) members ...

    JSP Simple Examples

    One of the strong features of java is that it is follows a OOPs concept, and one of the feature of OOP in java is that, we can assign a subclass object or variable to the variable of the superclass ...

    数据库系统原理英文课件:ch16 Concurrency Control.ppt

    Chapter 16 of "Database System Concepts," 5th Edition, by Silberschatz, Korth, and Sudarshan delves into the crucial topic of Concurrency Control in database systems. This chapter explores various ...

    计算机组成与结构体系英文课件:Chapter5 Basic Processing Unit

    Chapter 5 of the "Basic Processing Unit" in the Computer Composition and Structure System delves into the core elements and functioning of a computer's central processing unit (CPU). The CPU, also ...

    雷达技术知识

    glance the water surface at angles of incidence greater than 53 degrees, a LiDAR pulse is 2 more often lost to refraction (Figure 2) (Jenkins, 1957). In broken water surface conditions the water ...

    The.Security.Consultants.Handbook.

    A compendium of essential information for the modern security entrepreneur and practitioner The modern security practitioner has shifted from a predominantly protective site and assets manager to a ...

    HugeInteger大整数计数器作业

    isNotEqualTo, isGreaterThan, isLessThan, isGreaterThanOrEqualTo and isLessThanOrEqualTo — each of these is a “predicate” function that simply returns true if the relationship holds between the two...

    The Cognitive Dynamics of Computer Science

    science holds true for Germany, France, Holland, Denmark, and the rest of the European countries as well. I have no experience with Japan, China, or India directly, but there is no reason to believe ...

    Pro PowerShell for Amazon Web Services DevOps for the AWS Cloud

    He holds a BS in Computer Engineering from NYU Poly, an MBA from Rutgers Business Schools, and is a member of American Mensa. Brian is an advocate for Cloud Computing on the AWS platform and ...

    AUTOSAR_EXP_ARAComAPI.pdf

    Therefore this document shall serve as an entry point not only for the developer of software components for the Adaptive Platform, who will use the ara::com API to interact with other application or ...

    NTFS Documentation

    The Master File Table, which is a database of file records for every file and directory on the volume. ##### NTFS Files: $MFTMirr (1) A mirror of the $MFT, used for redundancy and recovery purposes. ...

Global site tag (gtag.js) - Google Analytics