Re: SQL 7.0 SP4 Backup files not present?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Micael (anonymous_at_discussions.microsoft.com)
Date: 04/13/04


Date: Tue, 13 Apr 2004 05:36:03 -0700

If i check the log files it all OK.
Please see log file from last backup.

[24] Database scalaDB: Database Backup...
    Destination: [E:\SQLBackup\DEMODB\DEMO_db_200404130200.BAK]

    ** Execution Time: 0 hrs, 0 mins, 34 secs **

End of maintenance plan 'DB Maintenance Plan USER DB' on Tue Apr 13 02:01:11 2004

SQLMAINT.EXE Process Exit Code: 0 (Success)

The prolem is that the file is not present... Most of the DB's backup files are OK, only 2 is missing every night.
These DB's are the largest 300MB and 1,8GB as a backup file. If i do backup manually to disk it works fine but not always.

The backup is to a disk set (RAID-5) on the same server as the SQL Server



Relevant Pages

  • Re: Recovering using the log file
    ... Stop that SQL Server, delete the mdf, ndf and ldf files. ... Then restore the db backup and that log backups. ... > They were in full recovery. ... > full backups and log files that I have. ...
    (microsoft.public.sqlserver.server)
  • Re: SBS W2k Losing Disk Space For No Apparent Reason
    ... backup against the Exchange First Storage Group then ... checked the log files - success, ... Obviously the media issue is my main concern at present, ... >first step is to get your backup file correct. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Log Files
    ... The backup Server is being replaced tommorow mornign with a new ... I have tried to move the log files to a bigger drive so then I can run ... move-StorageGroupPath -Identity ?exchsrvr\Second Storage Group? ... On the Active node or the Passive node, ...
    (microsoft.public.exchange.admin)
  • Re: copy log files to the RSG
    ... Susan Conkey [MVP] ... full online backup on the production DB, after the backup completed, i ... noticed that all the log files i copied to the RSG (to roll the RSG ...
    (microsoft.public.exchange.admin)
  • Re: Exchange 2007 Log
    ... should prevent truncation of the log files after a backup. ... also be scheduled to not overlap with your backup activity. ... "there is an online maintenance overlap for database - First Storage ...
    (microsoft.public.exchange.admin)