backup advise
Hi
We usae Sql2000.
I'm setting up backups jobs and need advise.
When I run a backup of a database, does it automatically clean out the
transaction log ? For a complete backup ? for a differential backup ?
When would it be best to run a shrinkdatabase command ? Why would I want
to run the shrinkdatabase ?
Thnaks
David Greenberg
.
Relevant Pages
- Re: Still dont understand log backups
... The transaction log, whether or not it is one or many files, is a serial, ... until the end of the physical log file is reached. ... backup is executed, the active "virtual" logs are backed up, but the ... Using BULK LOGGED, does the online log file contain EVERY transaction for all time -- given that I don't truncate it manually? ...
(microsoft.public.sqlserver.server) - Re: Very large LDF
... If a database is backed up using the 'Complete Backup' option via ... You will have to backup the transaction log seperately. ... Check the Recovery model you are using for that database. ...
(microsoft.public.sqlserver.security) - Re: Transaction Log Size
... Backup database does not empty the transaction log files. ... How to Shrink the SQL Server 7.0 Transaction Log ...
(microsoft.public.sqlserver.server) - Re: Log Shipping: question about secondary dB mode?
... Regular transaction log backups will allow the committed and backed up portion of the log file to be reused for new transactions. ... And last to recover the db you restore the last log file using the WITH RECOVERY option and you should be all set. ... all the backup and restore jobs are proceeding without errors. ...
(microsoft.public.sqlserver.tools) - Re: Large Transaction Log Backup after Database Backup
... script and see for yourself that the database backup doesn't truncate the ... ALTER DATABASE steve SET RECOVERY FULL ... But my understanding was that the transaction log was> truncated after a full database backup. ...
(microsoft.public.sqlserver.server) |
|
