`

还原出错: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.

    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 ...

    Hack the Stack Using Snort and Ethereal to Master the 8 Layers of an Insecure Netork

    It guides readers step-by-step through the "stack" -- the seven layers of a network. Each chapter focuses on one layer of the stack along with the attacks, vulnerabilities, and exploits that can be ...

    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 ...

    The Object-Oriented Thought Process (3rd Edition)

    By designing with objects rather than treating the code and data as separate entities, OOP allows objects to fully utilize other objects’ services as well as inherit their functionality. OOP ...

    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 ...

    雷达技术知识

    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 ...

    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 ...

    Hadoop权威掼.pdf

    Hadoop: The Definitive Guide provides you with the key for unlocking the wealth this data holds. Hadoop is ideal for storing and processing massive amounts of data, but until now, information on this...

    HOW TO IMPROVE YOUR BUSINESS LETTERS

    The importance of good business writing skills cannot be underestimated. Here are some tips: 1. Remember the old public speaking adage: "Tell them what you're going to say, say it, then tell them what...

    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 ...

    Python Essential Reference

    If writing the byte-compiled code to a file is not possible, Python suffers from the limitations of other scripting languages: the executable is the source and cannot be hidden from the user, at ...

Global site tag (gtag.js) - Google Analytics