Hi,
You can take backup to your database through sql server. Later you can restore it.
For Backup:
BACKUP DATABASE myDB
TO DISK='C:\myDB.bak'
WITH DESCRIPTION='Database Backup',
INIT,
PASSWORD='myPwd'
For Restore :
RESTORE DATABASE myDB
FROM DISK='C:\myDB.bak'
WITH PASSWORD='myPwd'