Welcome to the forum!

There are many threads that talk about this - search for BACKUP FUNDS and you will find dozens.

I just did that and copy/pasted this post from another thread...

This thread has some great info:

http://www.vbforums.com/showthread.p...t=backup+funds

Basically, this is the T-SQL BACKUP command syntax:

Code:
BACKUP DATABASE Funds 
   TO DISK = 'c:\Funds_copy.bak'
The above thread talks about putting that into a STORED PROCEDURE and have the destination be a variable.

You can also setup regular backup's through ENTERPRISE MANAGER under the DATABASE MAINTENANCE PLAN wizard.

The perfect thing about a BACKUP is that it can be done with users in the database and it properly handles taking the DATA and LOG portions in a fashion that allows proper RESTORE