SQL Server Backup
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Thu, 13 May 2004 19:09:52 -0700
We would like to keep only 1 copy of database backup as we
run out of disk space.
However, if we choose "Remove Files Older than 1 Day" in
the Database Maintenance Plan, it will remove the previous
day backup even though last night backup is not successful.
Is there any suggestion ?
Relevant Pages
- Re: ReportIoError when performing backup - what can be done?
... > On 2 previous occasions, and the last weekend, the transaction log on the ... > perform a full database backup after each change of recovery mode. ... did you shrink the transaction log after truncate? ...
(microsoft.public.sqlserver.server) - Re: SQL 2005 Shrink issue
... I'm running a full database backup nightly, and my recover mode is full as ... well in SQL. ... I'm using Symantec Backup exec 11D to do the backup's. ... Logs grow until you make a database backup. ...
(microsoft.public.sqlserver.tools) - Re: General Question - May Be Silly.
... You need to use a database backup first (i.e. using SQL ... Server tools maybe) to a hard disk on the server. ... WSS FAQ at http://wss.collutions.com ...
(microsoft.public.sharepoint.windowsservices) - Re: Detaching and Attaching a Databases
... redo and undo phases and you will need to run another FULL backup before you can start the log backups. ... to continue restore the transaction log files made on SQL2008? ... I made a full database backup. ... I made transaction log backups every hour. ...
(microsoft.public.sqlserver.server) - Re: SQL restore table / rollback / undo table drop without backups?
... If you never did a database backup, then your chances are very slim, because you don't have anything to "hang" your current log backup on. ... If you ever did a database backup, then you can perform a log backup now, then restore your database backup and all subsequent log backups, but stop before this accident. ...
(microsoft.public.sqlserver.programming) |
|
