–Read the Backup file—-

exec master.dbo.xp_restore_filelistonly

  @filename =
‘Server nameDrive$restoreDatabaseName_Format.LSB or BAK’

—Restore the Database

exec master.dbo.xp_restore_database @database=‘DataabseName_NewDatabase’

, @filename =
‘Server nameDrive$restoreDatabaseName_Format.LSB or BAK’

, @with =
‘move “Logical Filename” to “LocationDataFileName.mdf”‘

, @with =
‘move “Logical Filename” to “LocationLogFile.ldf”‘

, @with =
‘recovery’

If you have more than one Datafile, move them the same way as this does for mdf (Datafile) file.

exec master.dbo.xp_restore_database @database=‘DataabseName_NewDatabase’

, @filename =
‘Server nameDrive$restoreDatabaseName_Format.LSB or BAK’

, @with =
‘move “Logical Filename” to “LocationDataFileName.mdf”‘

, @with =
‘move “Logical Filename” to “LocationDataFileName.ndf”‘

, @with =
‘move “Logical Filename” to “LocationLogFile.ldf”‘

, @with =
‘recovery’