T-SQL from SQL command prompt

Every database administrator or system administrator has to perform backup and recovery and almost all of them have performed backups and restores if not an entire recovery in their career.…