You should regularly backup your database by doing a dump of your database. When you do a dump of your data, you save the data into a backup file. In addition to the backup file, a log table on the database automatically records every transaction that involves or affects the database. You cannot turn the logging feature off, but you can set up the database so that it will truncate the log file. This prevents the log file from filling up. (For instructions on how to set up the log file to be truncated, see your Sybase System Administrator documentation.)
Before you back up your database, you need to run DBCC, if you have not already done so.
When you back up your SQL database, you do these tasks:
• | Back up your SQL transaction log. This database log automatically records every transaction that involves or affects the database. You need to back up this log before you dump your database. |
• | Back up your SQL database. You back up your database by creating a dump of your database. This dump is a backup file that you can load (with the transactions logs) if you need to restore your database. |
Be sure that when you back up your transaction log or database you do not overwrite previous transaction or database backup files.
© 1998-2017 Sirsi Corporation