Sunday, March 11, 2012

automatic dbase backup fails

Hi just wondering if anyone has any ideas what would cause an automatic
backup to fail when the manual backup works fine? There seems to be plenty
of disk space. Also there does not to be a log created showing any error
messages when the backup fails. The autobackup was setup in Enterprise
manager under Management/jobs. Also the SQL Server Agent is running. Thank
s.
--
Paul G
Software engineer.Is the backup being sent to a remote share or machine? If so make sure the
account SQL Server is running under has the proper rights to that share.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
> Hi just wondering if anyone has any ideas what would cause an automatic
> backup to fail when the manual backup works fine? There seems to be
> plenty
> of disk space. Also there does not to be a log created showing any error
> messages when the backup fails. The autobackup was setup in Enterprise
> manager under Management/jobs. Also the SQL Server Agent is running.
> Thanks.
> --
> Paul G
> Software engineer.|||the backup should be just going to the same machine as the database in the
directory c:\program files\microsoft sql server\BACKUP, thanks for the
information will check out the rights/permissions.
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> Is the backup being sent to a remote share or machine? If so make sure th
e
> account SQL Server is running under has the proper rights to that share.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:4E523A95-0F6E-403B-904B-B8F134A86055@.microsoft.com...
>
>|||Backing up to the same drive the database is on is a bad idea. If you loose
the drive you loose both the db and the backups. Have a look in the SQL
Error logs and in the job history and see if there is more info to go on.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...[vbcol=seagreen]
> the backup should be just going to the same machine as the database in the
> directory c:\program files\microsoft sql server\BACKUP, thanks for the
> information will check out the rights/permissions.
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>|||ok thanks for the additional information. We have a seperate backup of the
drive that occures daily but will probably back up to an external device in
the near future.
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> Backing up to the same drive the database is on is a bad idea. If you loo
se
> the drive you loose both the db and the backups. Have a look in the SQL
> Error logs and in the job history and see if there is more info to go on.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:E621A920-9E90-4401-B759-1806B6F03F8B@.microsoft.com...
>
>

No comments:

Post a Comment