Several points of note for recovering a full data backup

Create a backup device

Use master

Go

EXEC sp_addumpdevice ' disk ', ' data123 ', ' D:\123.bak '

Backing up data

Backup database data1 to disk= ' D:\123.bak '

Backup Log

Backup LOG data1 to disk= ' D:\123.bak '

View Backup Status

Restore HEADERONLY from disk= ' D:\123.bak '

Restore full data and logs

Restore database data1 from disk= ' D:\123.bak ' with File=1,replace,norecovery

Restore log data1 from disk= ' D:\123.bak ' with File=2,replace,norecovery

Restore log data1 from disk= ' D:\123.bak ' with File=3,replace,orecovery

Overwrite backup (init means initialize without parameters for append backup)

Backup database data1 to disk= ' D:\123.bak ' with init

Restore full data and logs by point in time

Restore database data1 from disk= ' D:\123.bak ' with File=1,replace,norecovery

Restore log data1 from disk= ' D:\123.bak ' with file=2,recovery,stopat= ' 2015-03-10 20:30:35.100 '

Several points of note for recovering a full data backup