• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

backup option for SQL Server 2005 database

What tools and/or means are available to backup a live database files (mdf and ldf file)?
0
nkhimani
Asked:
nkhimani
2 Solutions
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now