The backup and restore component of Microsoft SQL Server 2005 provides an essential safeguard to help protect critical data stored in SQL Server databases.
See all Backing Up and Restoring How-to Topics
A little example:
USE master
GO
RESTORE FILELISTONLY
FROM DISK = 'C:\SQL_DATA\BACKUP\MyDataBase_backup.bak';
RESTORE DATABASE MyDataBase
FROM DISK = 'C:\SQL_DATA\BACKUP\MyDataBase_backup.bak'
WITH RECOVERY,
MOVE 'MyDataBase_Data' TO 'C:\SQL_DATA\MyDataBase.mdf',
MOVE 'MyDataBase_Log' TO 'C:\SQL_DATA\MyDataBase.ldf';
GO