How to back-up a SQL Database

Pardon my newbie question as I' m new to SQL databases.

I have used the Snitz forums in the past with the database on our server and I FTP that database to my local computer as a backup.

I' m considering using this forums software but don' t understand how to backup a SQL database. Can it be done using FTP just like other files or do I need an " Enterprise Manager" of some sort to perform the operation?

Sorry if this post sounds trivial but to a newbie I' m looking for needed information.

Thanks for your time!

Backing up a SQL server database is different from backing up an Access db. And you don' t need SQL Enterprise Manager to do it (you can use our db installer to perform backup).

Use the following T-SQL statements to perform backup:

1. Create a device:

exec sp_addumpdevice 'DISK' , 'TESTBAK' , 'F:\SQLBak\asppgd.bak'

1. 'DISK' : back up the database to your disk. You can also use 'TAPE' to back up to a tape drive.
   
2. 'TESTBAK' : the name of the backup, and it' s the name you will use in the backup statment later.
   
3. 'F:\SQLBak\asppgd.bak' : The physical path to the disk volume you are backing up to.

2. Backup

BACKUP DATABASE [asppgdDatabase]
TO TESTBAK
WITH
DESCRIPTION = 'My First BaK' ,
STATS

Backup operation should complete in less than 1 min, depending on the size of your database. These are the basic T-SQL statements for backing up a SQL server database.

For more information, please refer to SQL Server Books Online. You can also find useful info here.

Thanks Samuel!

You ALWAYS have the answer back quickly.