backup option for SQL Server 2005 database

What tools and/or means are available to backup a live database files (mdf and ldf file)?
nkhimaniAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should not try to backup the "live" .mdf/ldf files directly.
instead, use the BACKUP DATABASE and BACKUP LOG   t-sql statements to backup the database up to a dump file:


#How to: Create a Full Database Backup (Transact-SQL)
msdn.microsoft.com/en-us/library/ms191304.aspx

# BACKUP (Transact-SQL)
msdn.microsoft.com/en-us/library/ms186865.aspx

0
 
si_shamilCommented:
Here is a good how-to of backing up SQL database using SQL 2005 designer

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.