Wednesday, July 14, 2010

While Restoring SQL database - Error 3154

When we try to restore backup file to new database if we get error 3154.

For that instead of restoring backup database to New database. Directly Restore backup file with New Database Name.
Posted by at

4 comments:

  1. AlexSeptember 29, 2011 at 4:03 PM

    For such issue there is mdf recovery. It can work out trouble with corrupted or lost sql databases. The software works under any Windows OS. It uses effective methods of restoring files from any SQL Server versions.

    ReplyDelete
  2. Thanjai Vasan (தஞ்சை.வாசன்)September 30, 2011 at 9:21 AM

    Hi Alex,

    Thanks for your Comment and tips.

    Next time let use it and check.

    ReplyDelete
  3. Mark WilliumMarch 21, 2012 at 11:45 PM

    Cause: SQL server generates an error 3154 when it founds restoring database is already exist on the database.

    Solution: You can solve this error by two methods
    1. Use 'Replace With' while using restore command.
    2. Delete the older database that is exisiting and restore the database with restore command.

    Thanks,
    Mark Willium
    SQL server database recovery specialist

    ReplyDelete
  4. Thanjai Vasan (தஞ்சை.வாசன்)March 22, 2012 at 8:39 AM

    Hi Mark,

    Thank you for your comment & explain.

    ReplyDelete

Subscribe to: Post Comments (Atom)