63,630 pts.
POSTED: Feb 16, 2009 1:55 PM (GMT)
[...] news by unknown « Gamers Arena ยป Virus Protection Software Affiliate Marketing Software - Faster [...]
SQL Server 2005 backup
how to take backup of live site
ASKED:
Feb 16, 2009 11:32 AM GMT
UPDATED:
February 16, 2009 10:13:17 PM GMT
RELATED QUESTIONS
- How do I backup sharepoint 2003 using backup exec 12
- outlook and windows server 2003
- what is a system state backup
- Can I backup to disk with BRMS?
- backup of tally server
- what backup utility are you likely to use when making a pre-upgrade backup in linux?
- Rman Backup
- Linux Backup
- Missing Backup Job Template
- What is the significance of incarnation and DBID in the RMAN backups
Answer Wiki:
Typically you set up the SQL server maintenance jobs to dump backups into the backup directory and then you use backup software to back up this backup directory. Otherwise you use software specifically designed to back up SQL like Tivoli Storage Manager tdpsql.
All backup software (including SQL Server backup software and backup agents like Tivoli, CommVault, etc) use the BACKUP DATABASE command to backup the database to either disk or tape. You can manually run the command as needed, or schedule it via a SQL Agent job, or use another scheduler. You can also use the maintenance plans to control the database backup.
All backup software (including SQL Server backup software and backup agents like Tivoli, CommVault, etc) use the BACKUP DATABASE command to backup the database to either disk or tape. You can manually run the command as needed, or schedule it via a SQL Agent job, or use another scheduler. You can also use the maintenance plans to control the database backup.
To see other answers submitted to the Answer Wiki View Answer History.
