MS SQL Server 7 - Scheduled Backups

Results 1 to 2 of 2

Thread: MS SQL Server 7 - Scheduled Backups

  1. #1
    Join Date
    Dec 1969

    Default MS SQL Server 7 - Scheduled Backups

    We are trying to create scheduled backups of our various SQL databases, but SQL Server does not back up according to the schedule. We have tried creating a schedule both in the Backup utility and in the Maintenance Plan, but neither works (ie at the allotted time the database is not backed up). The only way to back up the data is to create a backup manually for *each* database, every day (not satisfactory). Does anyone have a solution to our problem? Thanks very much.

  2. #2
    Garth Guest

    Default RE: MS SQL Server 7 - Scheduled Backups

    Verify that the login associated with the SQL Server Agent Service has rights to the directory in which the files are located. <BR><BR>1. Control Panel<BR>2. Services<BR>3. Double-click on SQLSERVERAGENT<BR><BR>Garth<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts