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.

ASPPlayground.net Developer

Thanks Samuel!

You ALWAYS have the answer back quickly.