Restore Database Backup Using PL/SQL

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'


RESTORE DATABASE MyTempCopy FROM DISK='e:\mssql\backup\creditline.bak'
   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 Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s