I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
CraigIf the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notification.
"Craig HB" wrote:
> I want to setup an alert to let me know when backups fail (they mainly fail
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craig
Showing posts with label disk. Show all posts
Showing posts with label disk. Show all posts
Sunday, March 25, 2012
Alerts for failed backups
I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
Craig
If the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notification.
"Craig HB" wrote:
> I want to setup an alert to let me know when backups fail (they mainly fail
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craig
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
Craig
If the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notification.
"Craig HB" wrote:
> I want to setup an alert to let me know when backups fail (they mainly fail
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craig
Alerts for failed backups
I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
CraigIf the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notificatio
n.
"Craig HB" wrote:
> I want to setup an alert to let me know when backups fail (they mainly fai
l
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craigsql
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
CraigIf the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notificatio
n.
"Craig HB" wrote:
> I want to setup an alert to let me know when backups fail (they mainly fai
l
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craigsql
Thursday, March 22, 2012
alert for low disk space
What's the best way to setup a SQL alert for low disk space? Say, less than
10GB free?
Thanks, AndreCheck this out
http://www.databasejournal.com/scripts/article.php/1470811
HTH
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>What's the best way to setup a SQL alert for low disk
space? Say, less than
>10GB free?
>Thanks, Andre
>
>.
>|||Perfect - thanks!
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:019801c35c85$cb976bd0$a001280a@.phx.gbl...
> Check this out
> http://www.databasejournal.com/scripts/article.php/1470811
> HTH
> Ray Higdon MCSE, MCDBA, CCNA
> >--Original Message--
> >What's the best way to setup a SQL alert for low disk
> space? Say, less than
> >10GB free?
> >
> >Thanks, Andre
> >
> >
> >.
> >
10GB free?
Thanks, AndreCheck this out
http://www.databasejournal.com/scripts/article.php/1470811
HTH
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>What's the best way to setup a SQL alert for low disk
space? Say, less than
>10GB free?
>Thanks, Andre
>
>.
>|||Perfect - thanks!
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:019801c35c85$cb976bd0$a001280a@.phx.gbl...
> Check this out
> http://www.databasejournal.com/scripts/article.php/1470811
> HTH
> Ray Higdon MCSE, MCDBA, CCNA
> >--Original Message--
> >What's the best way to setup a SQL alert for low disk
> space? Say, less than
> >10GB free?
> >
> >Thanks, Andre
> >
> >
> >.
> >
Friday, February 24, 2012
agent entries in registry missing after restore
Hi,
We had to back-up and restore a server due to an error
during installation regarding disk partitioning.
The server is completely restored where rights to files
have been restred and all files are in the same location
(MS Back-up). Everything seems to be working fine, except
for MS SQL server.
No MS SQL servers are available to log-on to.
Event messages 322, 19011, 208, 203, 17177 etc. appear
sample of event 322:
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: (4)
Event ID: 322
Date: 1/22/2004
Time: 12:50:14 PM
User: N/A
Computer: BLUE
Description:
The description for Event ID ( 322 ) in Source (
SQLSERVERAGENT ) cannot be found. The local computer may
not have the necessary registry information or message DLL
files to display messages from a remote computer. The
following information is part of the event: 19002,
MSSQLSERVER.
---
So the question is: he registry seems to be restored
properly, but somehow SQL server entries are not found. I
did not take a copy of the registry. Prior to deleting it.
Am I suffering a rights problem or a registry restore
problem?
Any ideas are very much appreciated!
Thanks,
SamYou can try to rebuild the registry entries, if this is the problem. When
you start the SQL Server Setup, you will find a
Rebuild Registry Option in the Advanced Setup Options.
Cheers,
Herbert
"Sam Jaarsma" <sam@.grupoamengual.com.nospam> schrieb im Newsbeitrag
news:2bb101c3e191$e3a27c10$a001280a@.phx.gbl...
We had to back-up and restore a server due to an error
during installation regarding disk partitioning.
The server is completely restored where rights to files
have been restred and all files are in the same location
(MS Back-up). Everything seems to be working fine, except
for MS SQL server.
No MS SQL servers are available to log-on to.
Event messages 322, 19011, 208, 203, 17177 etc. appear
sample of event 322:
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: (4)
Event ID: 322
Date: 1/22/2004
Time: 12:50:14 PM
User: N/A
Computer: BLUE
Description:
The description for Event ID ( 322 ) in Source (
SQLSERVERAGENT ) cannot be found. The local computer may
not have the necessary registry information or message DLL
files to display messages from a remote computer. The
following information is part of the event: 19002,
MSSQLSERVER.
---
So the question is: he registry seems to be restored
properly, but somehow SQL server entries are not found. I
did not take a copy of the registry. Prior to deleting it.
Am I suffering a rights problem or a registry restore
problem?
Any ideas are very much appreciated!
Thanks,
SamYou can try to rebuild the registry entries, if this is the problem. When
you start the SQL Server Setup, you will find a
Rebuild Registry Option in the Advanced Setup Options.
Cheers,
Herbert
"Sam Jaarsma" <sam@.grupoamengual.com.nospam> schrieb im Newsbeitrag
news:2bb101c3e191$e3a27c10$a001280a@.phx.gbl...
quote:
> Hi,
> We had to back-up and restore a server due to an error
> during installation regarding disk partitioning.
> The server is completely restored where rights to files
> have been restred and all files are in the same location
> (MS Back-up). Everything seems to be working fine, except
> for MS SQL server.
> No MS SQL servers are available to log-on to.
> Event messages 322, 19011, 208, 203, 17177 etc. appear
> sample of event 322:
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: (4)
> Event ID: 322
> Date: 1/22/2004
> Time: 12:50:14 PM
> User: N/A
> Computer: BLUE
> Description:
> The description for Event ID ( 322 ) in Source (
> SQLSERVERAGENT ) cannot be found. The local computer may
> not have the necessary registry information or message DLL
> files to display messages from a remote computer. The
> following information is part of the event: 19002,
> MSSQLSERVER.
> ---
> So the question is: he registry seems to be restored
> properly, but somehow SQL server entries are not found. I
> did not take a copy of the registry. Prior to deleting it.
> Am I suffering a rights problem or a registry restore
> problem?
> Any ideas are very much appreciated!
> Thanks,
> Sam
>
agent entries in registry missing after restore
Hi,
We had to back-up and restore a server due to an error
during installation regarding disk partitioning.
The server is completely restored where rights to files
have been restred and all files are in the same location
(MS Back-up). Everything seems to be working fine, except
for MS SQL server.
No MS SQL servers are available to log-on to.
Event messages 322, 19011, 208, 203, 17177 etc. appear
sample of event 322:
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: (4)
Event ID: 322
Date: 1/22/2004
Time: 12:50:14 PM
User: N/A
Computer: BLUE
Description:
The description for Event ID ( 322 ) in Source (
SQLSERVERAGENT ) cannot be found. The local computer may
not have the necessary registry information or message DLL
files to display messages from a remote computer. The
following information is part of the event: 19002,
MSSQLSERVER.
---
So the question is: he registry seems to be restored
properly, but somehow SQL server entries are not found. I
did not take a copy of the registry. Prior to deleting it.
Am I suffering a rights problem or a registry restore
problem?
Any ideas are very much appreciated!
Thanks,
SamYou can try to rebuild the registry entries, if this is the problem. When
you start the SQL Server Setup, you will find a
Rebuild Registry Option in the Advanced Setup Options.
Cheers,
Herbert
"Sam Jaarsma" <sam@.grupoamengual.com.nospam> schrieb im Newsbeitrag
news:2bb101c3e191$e3a27c10$a001280a@.phx.gbl...
> Hi,
> We had to back-up and restore a server due to an error
> during installation regarding disk partitioning.
> The server is completely restored where rights to files
> have been restred and all files are in the same location
> (MS Back-up). Everything seems to be working fine, except
> for MS SQL server.
> No MS SQL servers are available to log-on to.
> Event messages 322, 19011, 208, 203, 17177 etc. appear
> sample of event 322:
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: (4)
> Event ID: 322
> Date: 1/22/2004
> Time: 12:50:14 PM
> User: N/A
> Computer: BLUE
> Description:
> The description for Event ID ( 322 ) in Source (
> SQLSERVERAGENT ) cannot be found. The local computer may
> not have the necessary registry information or message DLL
> files to display messages from a remote computer. The
> following information is part of the event: 19002,
> MSSQLSERVER.
> ---
> So the question is: he registry seems to be restored
> properly, but somehow SQL server entries are not found. I
> did not take a copy of the registry. Prior to deleting it.
> Am I suffering a rights problem or a registry restore
> problem?
> Any ideas are very much appreciated!
> Thanks,
> Sam
>
We had to back-up and restore a server due to an error
during installation regarding disk partitioning.
The server is completely restored where rights to files
have been restred and all files are in the same location
(MS Back-up). Everything seems to be working fine, except
for MS SQL server.
No MS SQL servers are available to log-on to.
Event messages 322, 19011, 208, 203, 17177 etc. appear
sample of event 322:
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: (4)
Event ID: 322
Date: 1/22/2004
Time: 12:50:14 PM
User: N/A
Computer: BLUE
Description:
The description for Event ID ( 322 ) in Source (
SQLSERVERAGENT ) cannot be found. The local computer may
not have the necessary registry information or message DLL
files to display messages from a remote computer. The
following information is part of the event: 19002,
MSSQLSERVER.
---
So the question is: he registry seems to be restored
properly, but somehow SQL server entries are not found. I
did not take a copy of the registry. Prior to deleting it.
Am I suffering a rights problem or a registry restore
problem?
Any ideas are very much appreciated!
Thanks,
SamYou can try to rebuild the registry entries, if this is the problem. When
you start the SQL Server Setup, you will find a
Rebuild Registry Option in the Advanced Setup Options.
Cheers,
Herbert
"Sam Jaarsma" <sam@.grupoamengual.com.nospam> schrieb im Newsbeitrag
news:2bb101c3e191$e3a27c10$a001280a@.phx.gbl...
> Hi,
> We had to back-up and restore a server due to an error
> during installation regarding disk partitioning.
> The server is completely restored where rights to files
> have been restred and all files are in the same location
> (MS Back-up). Everything seems to be working fine, except
> for MS SQL server.
> No MS SQL servers are available to log-on to.
> Event messages 322, 19011, 208, 203, 17177 etc. appear
> sample of event 322:
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: (4)
> Event ID: 322
> Date: 1/22/2004
> Time: 12:50:14 PM
> User: N/A
> Computer: BLUE
> Description:
> The description for Event ID ( 322 ) in Source (
> SQLSERVERAGENT ) cannot be found. The local computer may
> not have the necessary registry information or message DLL
> files to display messages from a remote computer. The
> following information is part of the event: 19002,
> MSSQLSERVER.
> ---
> So the question is: he registry seems to be restored
> properly, but somehow SQL server entries are not found. I
> did not take a copy of the registry. Prior to deleting it.
> Am I suffering a rights problem or a registry restore
> problem?
> Any ideas are very much appreciated!
> Thanks,
> Sam
>
Subscribe to:
Posts (Atom)