File And File-Group in MSSQL

To find backup details :-

Select top(3) first_lsn,last_lsn,backup_start_date,backup_finish_date,database_name,bf.physical_device_name,machine_name,@@SERVERNAME as dbservername From backupset BS 

Inner Join backupmediafamily  BF 

On Bs.media_set_id=bf.media_set_id Where database_name='Ls_Test'
Order By Bf.media_set_id Desc

use abcd
sp_helpfile
sp_helpdb 'ls_test'
create database SBIIND
USE SBIIND
SP_HELPFILE
sp_helpdb 'SBIIND'

ALTER DATABASE SBIIND ADD FILEGROUP PAYMENT
SELECT * FROM sys.sysfilegroups
ALTER DATABASE SBIIND ADD FILE (NAME='SBIIND_PAYMENT_NORTH',FILENAME='\\192.168.43.151\LS_Copy\SBIIND\SBIIND_PAYMENT_NORTH.NDF') TO FILEGROUP PAYMENT 
ALTER DATABASE SBIIND ADD FILE (NAME='SBI_BRANCH',FILENAME='\\192.168.43.151\LS_Copy\SBIIND\SBI_BRANCH.NDF')

sp_helpdb 'SBIIND'
CREATE TABLE ABC
( ID INT IDENTITY(1,1),
NAME VARCHAR(200) DEFAULT 'BANSH')
CREATE TABLE ABC_PAY
( ID INT IDENTITY(1,1),
NAME VARCHAR(200) DEFAULT 'BANSH') ON  PAYMENT
ALTER DATABASE SBIIND ADD FILE 
(NAME='SBIIND_PAYMENT_EAST1',FILENAME='\\192.168.43.151\LS_Copy\SBIIND\SBIIND_PAYMENT_EAST1.NDF')
TO FILEGROUP PAYMENT 
BACKUP DATABASE SBIIND TO DISK='\\192.168.43.151\LS_Copy\SBIIND_F1.bak'
BACKUP LOG SBIIND TO DISK='\\192.168.43.151\LS_Copy\SBIIND_F1.TRN'
RESTORE  FILELISTONLY FROM DISK='\\192.168.43.151\LS_Copy\SBIIND_F1.bak'
RESTORE  HEADERONLY FROM DISK='\\192.168.43.151\LS_Copy\SBIIND_F1.bak'
RESTORE DATABASE SBIIND FROM DISK='\\192.168.43.151\LS_Copy\SBIIND_F1.bak'
WHITH
MOVE '' TO '',
MOVE '' TO '',
MOVE '' TO '',
MOVE '' TO ''