Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013

    Unanswered: database restore

    hi everyone,

    i want to restore database in same server with another name, i already taken backup in d drive, and getting below error

    the backup set holds a backup of a database other than the existing database restore database is terminating abnormally(mssql server error:3152)

    do i stop the sql service before taking back up pls help me.


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The problem is that your restore is trying to put the copied MDF, NDF, and LDF files with the copied file pathnames. Windows can't have two files with exactly the same name.

    Check out the WITH MOVE clause of the Transact-SQL RESTORE command. It can help you fix this problem.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts