Backup / Server Hanging

We have a backup we run every day at 6:30am. Most days it
works fine, but every so often it will hang. We have
monitoring software that shows the backup is running by
the fact that I/O is occurring, but the backup won't
finish sometimes. As well, when it hangs the whole server
is hung. You can't even connect as Administrator to the
console. Any places to start looking?Hi,
By anychance 2 backup process(Overlap) on same database will be fired
simulteneously. This can be a cause
fo this type of an issue.
Check if you have any scheduled task / Maintenance plan to backup which will
run in parellel some times.
Thanks
Hari
MCDBA
"Allan" <agrimshaw@.agricoreunited.com> wrote in message
news:1fa5001c45877$3bac5a00$a301280a@.phx.gbl...
> We have a backup we run every day at 6:30am. Most days it
> works fine, but every so often it will hang. We have
> monitoring software that shows the backup is running by
> the fact that I/O is occurring, but the backup won't
> finish sometimes. As well, when it hangs the whole server
> is hung. You can't even connect as Administrator to the
> console. Any places to start looking?|||Check your server log, any error there?
--
Eric Li
SQL DBA
MCDBA
Allan wrote:
> We have a backup we run every day at 6:30am. Most days it
> works fine, but every so often it will hang. We have
> monitoring software that shows the backup is running by
> the fact that I/O is occurring, but the backup won't
> finish sometimes. As well, when it hangs the whole server
> is hung. You can't even connect as Administrator to the
> console. Any places to start looking?|||No messages anywhere. An error would be nice even.
Because the entire server freezes, nothing gets written to any logs.
The event log is clean, the SQL server log is clean, etc.
"Eric.Li" wrote:
> Check your server log, any error there?
> --
> Eric Li
> SQL DBA
> MCDBA
> Allan wrote:
> > We have a backup we run every day at 6:30am. Most days it
> > works fine, but every so often it will hang. We have
> > monitoring software that shows the backup is running by
> > the fact that I/O is occurring, but the backup won't
> > finish sometimes. As well, when it hangs the whole server
> > is hung. You can't even connect as Administrator to the
> > console. Any places to start looking?|||I am guessing you are backing up the database.
Have you checked the SQL logs and the Event Viewer for any information?
Are you running the job from Query Analyzer or is it a SQL Agent job?
-Ben
Allan wrote:
> We have a backup we run every day at 6:30am. Most days it
> works fine, but every so often it will hang. We have
> monitoring software that shows the backup is running by
> the fact that I/O is occurring, but the backup won't
> finish sometimes. As well, when it hangs the whole server
> is hung. You can't even connect as Administrator to the
> console. Any places to start looking?|||We have been running it via SQL Agent and it has been hanging.
We also tried running it manually via an isql window in software
called DBArtisan, and the output we got was:
BACKUP DATABASE [FDM] TO DISK = N'e:\MSSQL\BACKUP\FDMAM' WITH INIT ,
NOUNLOAD , NAME = N'FDM AM backup', SKIP , STATS = 10, NOFORMAT
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 461584 pages for database 'FDM', file 'FDM_Data' on file 1.
100 percent backed up.
Processed 2 pages for database 'FDM', file 'FDM_Log' on file 1.
BACKUP DATABASE successfully processed 461586 pages in 260.431 seconds (14.519 MB/sec).
But we did received a message:
13:05:24.286 DBMS AU-FRX-SQL -- Unknown Database Error
Of note:
DBCC commands have all come back clean.
Ben wrote:
> I am guessing you are backing up the database.
> Have you checked the SQL logs and the Event Viewer for any information?
> Are you running the job from Query Analyzer or is it a SQL Agent job?
> -Ben
> Allan wrote:
> > We have a backup we run every day at 6:30am. Most days it
> > works fine, but every so often it will hang. We have
> > monitoring software that shows the backup is running by
> > the fact that I/O is occurring, but the backup won't
> > finish sometimes. As well, when it hangs the whole server
> > is hung. You can't even connect as Administrator to the
> > console. Any places to start looking?