Restore Database Script

restore headeronly FROM disk = '\\192.168.0.10\Public\BACKUP\dbname.bak' with nounload

restore filelistonly FROM disk = '\\192.168.0.10\Public\BACKUP\dbname.bak' with file=1,nounload

RESTORE DATABASE dbname FROM disk = '\\192.168.0.10\Public\BACKUP\dbname.bak'
WITH FILE = 1,
Move 'primary_data' To 'H:\dbname\primary_data.mdf',
Move 'Data1_data' To 'H:\dbname\Data1_data.ndf',
Move 'balance_data' To 'H:\dbname\balance_data.ndf',
Move 'topups_data' To 'H:\dbname\topups_data.ndf',
Move 'sim_data' To 'H:\dbname\sim_data.ndf',
Move 'indx_data' To 'H:\dbname\indx_data.ndf',
Move 'dbname_indx_1' To 'H:\dbname\dbname_indx_1.ndf',
Move 'Data2_data' To 'H:\dbname\Data2_data.ndf',
Move 'dbname_indx_2' To 'H:\dbname\dbname_indx_2.ndf',
Move 'dbnamelog' To 'F:\dbname_Log\dbname_log.ldf',
RECOVERY, REWIND, NOUNLOAD

Excel Solution for Breaking Next Line

Objective: How to bring the sentence to the next line in the same cell of excel sheet

Solution:

Alt+Enter to bring the next line in excel