Restore Database Backup Using PL/SQL

On By kashifnizamIn Uncategorized

Use the following to restore database backup. This is useful when you’re restoring SharePoint content db on the same server.


RESTORE FILELISTONLY FROM DISK='e:\mssql\backup\creditline.bak'

>LogicalName
>--------------
>CreditLine
>CreditLine_log

RESTORE DATABASE MyTempCopy FROM DISK='e:\mssql\backup\creditline.bak'
WITH
   MOVE 'CreditLine' TO 'e:\mssql\MyTempCopy.mdf',
   MOVE 'CreditLine_log' TO 'e:\mssql\MyTempCopy_log.ldf'

One thought on “Restore Database Backup Using PL/SQL”

  1. Pingback: Migrating Project Server 2016 To Another Server – Kashif Nizam Qureshi

Leave a comment