Home » Topic » Error While Restoring SQL Database From .bak File

Error While Restoring SQL Database From .bak File

Lincoln Burrows ~ Modified: May 27th, 2016 ~ ~ 1 Minute Reading

Home › Forums › Error While Restoring SQL Database From .bak File

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • May 31, 2016 at 12:48 pm #2132 Score: 0
    Barry Alllen
    Moderator
    25 pts
    RESTORE DATABASE [DBName] FROM DISK = N'C:\DRM\SQL_SERVER_BACKUP\XXX.bak' 
MOVE N'DRM_GOLD_PS3' TO N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\DRM_GOLD_PS3.mdf', 
MOVE N'DRM_GOLD_PS3_log' TO N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\DRM_GOLD_PS3_log.LDF', 
NOUNLOAD, STATS =1
    June 2, 2016 at 10:06 am #2135 Score: 0
    Stephen West
    Moderator
    4 pts

    Simple CMD–>Restore database DBname from disk=’Path where is the .bak file’ with NO_Recovery.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.