create database vinod
on primary
(
name = 'vinod',
filename = 'C:SQLtestvinod.mdf',
size = 10mb,
maxsize =  20mb
)
log on
(
name = 'Vinod_log',
filename = 'C:SQLtestVinod_log.ldf',
size = 6mb,
maxsize =  8mb
)
Backup database vinodto disk = 'C:SQLtestvinod_full.bak'
create table doniv
(
id int,
name varchar(20),
Qualification Varchar(25)
)
Backup database vinod to disk = 'C:SQLtestvinod_diff.bak' with differential
insert into doniv values (1,'Bindu','BE')
insert into ttttt values (1,'Vinod','BE')
Backup log vinod to disk = 'C:SQLtestvinod_Log.bak' insert into doniv values (1,'doniv','BE')
Backup log vinod to disk = 'C:SQLtestvinod_Tail.bak' with norecovery,no_truncate

restore database vinod from disk = 'C:SQLtestvinod_Log.bak'  with norecovery
restore database vinod from disk = 'C:SQLtestvinod_Tail.bak' with replace
backup database vinod to disk = 'C:SQLtestvinod_copyonly.bak' with Copy_only
backup log vinod to disk = 'C:SQLtestvinod_LOG_Cpyonly.bak' with copy_Only
select * from backupmediaset

backup database SLKTESTDB to disk = 'C:SQLTestORIGINAL.bak' mirror to disk = 'C:SQLTestMIRROR.bak' with format

Backup Checksum

Backup database Slktestdb to disk = 'C:SQLtestslktestdb_chksm.bak' with checksum
restore verifyonly from disk = 'C:SQLtestslktestdb_chksm.bak'

create login vinod with password = 'bindurani'
create login [praclab2doniv1] from windows