Database Backup

backup database database_name
 to disk = 'path_and_file_name'

database_name - the name of the database that you want to back up
path_and_file_name - the path and file name to which you want to make the backup.

Example:

backup database msDataLab
to disk = 'c:\datalab\backup\msDatalab.BAK'

List of Backups

select NAME,USER_NAME,BACKUP_START_DATE,BACKUP_FINISH_DATE,DATABASE_NAME,SERVER_NAME,MACHINE_NAME
 from msdb..backupset 
 where type = 'D' 
 and database_name = 'DataLab' 
 order by BACKUP_FINISH_DATE desc

Get File Names from Backup

restore filelistonly
  from disk = N'C:\DataLab\Backup\MyBKP.bak' 
  with file = 1 ,
  nounload

Database Restore

restore database database_name
  from disk = 'path_and_file_name'

database_name the name of the database that you want to restore.
path_and_file_name - the path and file name of the backup file from which you want to restore the database.

Example:

restore database msDataLab
  from disk = 'c:\datalab\backup\msDatalab.BAK'

Warning! This command usually creates database and log files (.MDF and .LDF in SQL Server's default database folder, for example C:\MSSQL7\DATA.

Database Restore by Moving the Database to Other Location

restore database database_name
  from disk = 'path_and_file_name' 
  with move 
    'database_name' to 'path_and_MDF_file_name',
  move 'database_log_name' to 'path_and_LDF_file_name'

database_name - the name of the database that you wish to restore, as specified in the backup file.
 path_and_file_name - the path and file name of the backup file from which you wish to restore the database.
 path_and_MDF_file_name - the path and file name of the database file (.mdf).
 path_and_LDF_file_name - the path and file name of the database log file (.ldf).
 
 Example:

restore database msDataLab
  from disk= 'c:\datalab\backup\msDataLab.BAK'
  with move
     'msDataLab' TO 'f:\test\msDataLab.MDF',
     move 'msDataLab_log' to 'f:\test\msDataLab_log.LDF'