howto for backing up a SQL Server database ? 2

[Guest_imported]

What is the best way to backup a SQL Server database.
Do i just quiesce the database and copy the database file
somewhere?

 

[rajeevnandanmishra]

Hi there,
Backing up the database file is of not a good use.
how you are going to do the backup is depends upon the individual requirements.
What we do is to take Daily Full Database Dump (i.e. data + transaction logs). And taking hourly (only in working hours) backup of transaction log.
This ensures that whenever we have a failure we can retreive the data back to atleast last hourly backup.

 

[tlbroadbent]

Development of a backup strategy is critical. The strategy chosen will vary from site to site and from database to database. For example, transaction backups for an OLTP DB will certainly be more frequent than for a DB that is only updated a few times per day. You would be wise to review backup topics in SQL BOL. I also recommend the following links for discussion of backup strategies.

http://www.swynk.com/friends/sjones/BackupStrategy.asp

http://www.swynk.com/friends/smirnov/backupsapp.asp

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9629

http://gethelp.devx.com/techtips/thesqlpro/10min/10min1100/10min1100.asp

http://gethelp.devx.com/techtips/thesqlpro/10min/10min1000-1.asp

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin