Alerts not firing off jobs.

sql2k
sp3
Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
checked to fire off a job when it occurs. I then generate a deadlock, but the
job never gets fired off. Some important fun facts:
1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
2; I've tried running different jobs manually. They both work.Is the alert itself firing? Make sure that the EventLog
service and SQL Agent are running. Check the Event log to
make sure that it is not full. Check if the event is writing
to the Application log. There is also a topic in books
online with more information on troubleshooting alerts.
Check the topic: Troubleshooting Alerts
-Sue
On Thu, 13 Apr 2006 15:36:02 -0700, ChrisR
<ChrisR@.discussions.microsoft.com> wrote:
>sql2k
>sp3
>Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
>checked to fire off a job when it occurs. I then generate a deadlock, but the
>job never gets fired off. Some important fun facts:
>1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
>2; I've tried running different jobs manually. They both work.
>

alert for dropped database

Hello all,
SQL2K SP3a
I would like to be notified when a user drops a database in my sql server.
Is there any way to build such an alert?
Thanks, sqlgirlThere are several ways...most of them would involve some sort of batch
process that runs occasionally and compares the names of databases to the
previous run list...
Another way might be to run SQL Trace, loading data to a database table, and
place a trigger on the table to read the sql and notify it the command is a
drop database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:421cbc5b$0$43503$39cecf19@.news.twtelecom.net...
> Hello all,
> SQL2K SP3a
> I would like to be notified when a user drops a database in my sql server.
> Is there any way to build such an alert?
> Thanks, sqlgirl
>
>sql

alert for dropped database

Hello all,
SQL2K SP3a
I would like to be notified when a user drops a database in my sql server.
Is there any way to build such an alert?
Thanks, sqlgirl
There are several ways...most of them would involve some sort of batch
process that runs occasionally and compares the names of databases to the
previous run list...
Another way might be to run SQL Trace, loading data to a database table, and
place a trigger on the table to read the sql and notify it the command is a
drop database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:421cbc5b$0$43503$39cecf19@.news.twtelecom.net. ..
> Hello all,
> SQL2K SP3a
> I would like to be notified when a user drops a database in my sql server.
> Is there any way to build such an alert?
> Thanks, sqlgirl
>
>

alert for dropped database

Hello all,
SQL2K SP3a
I would like to be notified when a user drops a database in my sql server.
Is there any way to build such an alert?
Thanks, sqlgirlThere are several ways...most of them would involve some sort of batch
process that runs occasionally and compares the names of databases to the
previous run list...
Another way might be to run SQL Trace, loading data to a database table, and
place a trigger on the table to read the sql and notify it the command is a
drop database...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:421cbc5b$0$43503$39cecf19@.news.twtelecom.net...
> Hello all,
> SQL2K SP3a
> I would like to be notified when a user drops a database in my sql server.
> Is there any way to build such an alert?
> Thanks, sqlgirl
>
>

alert for database drop

Hello All,
SQL2K SP3a
I would like to create an alert when a database is dropped from my sql
servers. is it possible?
Thanks,
sqlgirl
sqlgirl (nice nickname!)
If you can create a trigger on sysobjects - then yes. Any object drop would
result in deleting corresponding entry from sysobjects table. Please let me
know if it helps.
Leon Shargorodsky
"Biva" wrote:

> Hello All,
> SQL2K SP3a
> I would like to create an alert when a database is dropped from my sql
> servers. is it possible?
> Thanks,
> sqlgirl
>
>
|||I don't think you can create a trigger on system tables. However, you could
have a job scheduled that runs every minute or every five minutes that
checks count(*) from sysdatabases and logs it. If this count is ever
*lower* than the last time the job ran, a database has been removed... send
an alert. If you shadow copy the database names from sysdatabases on each
run (maybe in two separate tables), you could even determine which
database(s) got dropped.
http://www.aspfaq.com/
(Reverse address to reply.)
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:664C0636-67CC-4551-B5B0-8BBCD51F5686@.microsoft.com...
> sqlgirl (nice nickname!)
> If you can create a trigger on sysobjects - then yes. Any object drop
would
> result in deleting corresponding entry from sysobjects table. Please let
me[vbcol=seagreen]
> know if it helps.
> Leon Shargorodsky
> "Biva" wrote:
|||Hi
Biva, wait for SQL Server 2005 and you will be able to define a trigger on
drop database.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uSQpFPdGFHA.3092@.tk2msftngp13.phx.gbl...
> I don't think you can create a trigger on system tables. However, you
could
> have a job scheduled that runs every minute or every five minutes that
> checks count(*) from sysdatabases and logs it. If this count is ever
> *lower* than the last time the job ran, a database has been removed...
send
> an alert. If you shadow copy the database names from sysdatabases on each
> run (maybe in two separate tables), you could even determine which
> database(s) got dropped.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
> message news:664C0636-67CC-4551-B5B0-8BBCD51F5686@.microsoft.com...
> would
> me
>
|||> Biva, wait for SQL Server 2005 and you will be able to define a trigger on
> drop database.
Actually, I think you will need to use event notifications, but yes you will
be able to get it done with less work than my proposal (assuming you are
willing to wait for SQL Server 2005 to go RTM :-)).
DDL triggers only cover events that can be in a transaction, and I don't
think CREATE/DROP DATABASE fall under that category.

alert for database drop

Hello All,
SQL2K SP3a
I would like to create an alert when a database is dropped from my sql
servers. is it possible?
Thanks,
sqlgirlsqlgirl (nice nickname!)
If you can create a trigger on sysobjects - then yes. Any object drop would
result in deleting corresponding entry from sysobjects table. Please let me
know if it helps.
Leon Shargorodsky
"Biva" wrote:
> Hello All,
> SQL2K SP3a
> I would like to create an alert when a database is dropped from my sql
> servers. is it possible?
> Thanks,
> sqlgirl
>
>|||I don't think you can create a trigger on system tables. However, you could
have a job scheduled that runs every minute or every five minutes that
checks count(*) from sysdatabases and logs it. If this count is ever
*lower* than the last time the job ran, a database has been removed... send
an alert. If you shadow copy the database names from sysdatabases on each
run (maybe in two separate tables), you could even determine which
database(s) got dropped.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:664C0636-67CC-4551-B5B0-8BBCD51F5686@.microsoft.com...
> sqlgirl (nice nickname!)
> If you can create a trigger on sysobjects - then yes. Any object drop
would
> result in deleting corresponding entry from sysobjects table. Please let
me
> know if it helps.
> Leon Shargorodsky
> "Biva" wrote:
> > Hello All,
> > SQL2K SP3a
> >
> > I would like to create an alert when a database is dropped from my sql
> > servers. is it possible?
> >
> > Thanks,
> > sqlgirl
> >
> >
> >|||Hi
Biva, wait for SQL Server 2005 and you will be able to define a trigger on
drop database.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uSQpFPdGFHA.3092@.tk2msftngp13.phx.gbl...
> I don't think you can create a trigger on system tables. However, you
could
> have a job scheduled that runs every minute or every five minutes that
> checks count(*) from sysdatabases and logs it. If this count is ever
> *lower* than the last time the job ran, a database has been removed...
send
> an alert. If you shadow copy the database names from sysdatabases on each
> run (maybe in two separate tables), you could even determine which
> database(s) got dropped.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
> message news:664C0636-67CC-4551-B5B0-8BBCD51F5686@.microsoft.com...
> > sqlgirl (nice nickname!)
> >
> > If you can create a trigger on sysobjects - then yes. Any object drop
> would
> > result in deleting corresponding entry from sysobjects table. Please let
> me
> > know if it helps.
> >
> > Leon Shargorodsky
> >
> > "Biva" wrote:
> >
> > > Hello All,
> > > SQL2K SP3a
> > >
> > > I would like to create an alert when a database is dropped from my sql
> > > servers. is it possible?
> > >
> > > Thanks,
> > > sqlgirl
> > >
> > >
> > >
>|||> Biva, wait for SQL Server 2005 and you will be able to define a trigger on
> drop database.
Actually, I think you will need to use event notifications, but yes you will
be able to get it done with less work than my proposal (assuming you are
willing to wait for SQL Server 2005 to go RTM :-)).
DDL triggers only cover events that can be in a transaction, and I don't
think CREATE/DROP DATABASE fall under that category.

alert for database drop

Hello All,
SQL2K SP3a
I would like to create an alert when a database is dropped from my sql
servers. is it possible?
Thanks,
sqlgirlsqlgirl (nice nickname!)
If you can create a trigger on sysobjects - then yes. Any object drop would
result in deleting corresponding entry from sysobjects table. Please let me
know if it helps.
Leon Shargorodsky
"Biva" wrote:

> Hello All,
> SQL2K SP3a
> I would like to create an alert when a database is dropped from my sql
> servers. is it possible?
> Thanks,
> sqlgirl
>
>|||I don't think you can create a trigger on system tables. However, you could
have a job scheduled that runs every minute or every five minutes that
checks count(*) from sysdatabases and logs it. If this count is ever
*lower* than the last time the job ran, a database has been removed... send
an alert. If you shadow copy the database names from sysdatabases on each
run (maybe in two separate tables), you could even determine which
database(s) got dropped.
http://www.aspfaq.com/
(Reverse address to reply.)
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:664C0636-67CC-4551-B5B0-8BBCD51F5686@.microsoft.com...
> sqlgirl (nice nickname!)
> If you can create a trigger on sysobjects - then yes. Any object drop
would
> result in deleting corresponding entry from sysobjects table. Please let
me[vbcol=seagreen]
> know if it helps.
> Leon Shargorodsky
> "Biva" wrote:
>|||Hi
Biva, wait for SQL Server 2005 and you will be able to define a trigger on
drop database.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uSQpFPdGFHA.3092@.tk2msftngp13.phx.gbl...
> I don't think you can create a trigger on system tables. However, you
could
> have a job scheduled that runs every minute or every five minutes that
> checks count(*) from sysdatabases and logs it. If this count is ever
> *lower* than the last time the job ran, a database has been removed...
send
> an alert. If you shadow copy the database names from sysdatabases on each
> run (maybe in two separate tables), you could even determine which
> database(s) got dropped.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
> message news:664C0636-67CC-4551-B5B0-8BBCD51F5686@.microsoft.com...
> would
> me
>|||> Biva, wait for SQL Server 2005 and you will be able to define a trigger on
> drop database.
Actually, I think you will need to use event notifications, but yes you will
be able to get it done with less work than my proposal (assuming you are
willing to wait for SQL Server 2005 to go RTM :-)).
DDL triggers only cover events that can be in a transaction, and I don't
think CREATE/DROP DATABASE fall under that category.

AgentMail Problem (SQL2K)

Hi,
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when try to
connect to profile. When I close outlook, they can access profile. This is
strange behavior that I had never seen elsewhere.
Any help would be greatly appreciated.
Leila
I believe this behavior can depend on your version of Outlook (I prefer Outlook 2000, I've seen the
strange behavior with later versions). It might also be related to whether all users use the same
Windows account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL
> Mail and Agent Mail can use the file of mail profile to send email. But on one of client's
> computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail fail
> when try to connect to profile. When I close outlook, they can access profile. This is strange
> behavior that I had never seen elsewhere.
> Any help would be greatly appreciated.
> Leila
>
|||> It might also be related to whether all users use the same Windows
> account.
If this is the case, then closing the outlook must not solve the problem I
think
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>I believe this behavior can depend on your version of Outlook (I prefer
>Outlook 2000, I've seen the strange behavior with later versions). It might
>also be related to whether all users use the same Windows account.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>
|||I think that some versions of MAPI (Outlook) doesn't like several Windows accounts using mail at the
same time. Say that Agent and SQL Server uses the same service account. They might not conflict, but
if you are logged in interactively using some other account, you might be in for some problems.
Anyhow, I recommend Outlook 2000. Or actually, I don't recommend SQL Mail at all
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), since it causes so many of these problems...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OLQuVxOjHHA.2552@.TK2MSFTNGP06.phx.gbl...
> If this is the case, then closing the outlook must not solve the problem I think
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>

AgentMail Problem (SQL2K)

Hi,
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when try to
connect to profile. When I close outlook, they can access profile. This is
strange behavior that I had never seen elsewhere.
Any help would be greatly appreciated.
LeilaI believe this behavior can depend on your version of Outlook (I prefer Outl
ook 2000, I've seen the
strange behavior with later versions). It might also be related to whether a
ll users use the same
Windows account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...[v
bcol=seagreen]
> Hi,
> I use Microsoft outlook as MAPI client. On my own computer, when the outlo
ok is open, both SQL
> Mail and Agent Mail can use the file of mail profile to send email. But on
one of client's
> computer, when outlook is open, it locks the file of profile and both SQL
Mail and Agent Mail fail
> when try to connect to profile. When I close outlook, they can access prof
ile. This is strange
> behavior that I had never seen elsewhere.
> Any help would be greatly appreciated.
> Leila
>[/vbcol]|||> It might also be related to whether all users use the same Windows
> account.
If this is the case, then closing the outlook must not solve the problem I
think
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>I believe this behavior can depend on your version of Outlook (I prefer
>Outlook 2000, I've seen the strange behavior with later versions). It might
>also be related to whether all users use the same Windows account.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>|||I think that some versions of MAPI (Outlook) doesn't like several Windows ac
counts using mail at the
same time. Say that Agent and SQL Server uses the same service account. They
might not conflict, but
if you are logged in interactively using some other account, you might be in
for some problems.
Anyhow, I recommend Outlook 2000. Or actually, I don't recommend SQL Mail at
all
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), since it causes so many
of these problems...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OLQuVxOjHHA.2552@.TK2MSFTNGP06.phx.gbl...[v
bcol=seagreen]
> If this is the case, then closing the outlook must not solve the problem I
think
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>[/vbcol]

AgentMail Problem (SQL2K)

Hi,
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when try to
connect to profile. When I close outlook, they can access profile. This is
strange behavior that I had never seen elsewhere.
Any help would be greatly appreciated.
LeilaI believe this behavior can depend on your version of Outlook (I prefer Outlook 2000, I've seen the
strange behavior with later versions). It might also be related to whether all users use the same
Windows account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL
> Mail and Agent Mail can use the file of mail profile to send email. But on one of client's
> computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail fail
> when try to connect to profile. When I close outlook, they can access profile. This is strange
> behavior that I had never seen elsewhere.
> Any help would be greatly appreciated.
> Leila
>|||> It might also be related to whether all users use the same Windows
> account.
If this is the case, then closing the outlook must not solve the problem I
think
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>I believe this behavior can depend on your version of Outlook (I prefer
>Outlook 2000, I've seen the strange behavior with later versions). It might
>also be related to whether all users use the same Windows account.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I use Microsoft outlook as MAPI client. On my own computer, when the
>> outlook is open, both SQL Mail and Agent Mail can use the file of mail
>> profile to send email. But on one of client's computer, when outlook is
>> open, it locks the file of profile and both SQL Mail and Agent Mail fail
>> when try to connect to profile. When I close outlook, they can access
>> profile. This is strange behavior that I had never seen elsewhere.
>> Any help would be greatly appreciated.
>> Leila
>|||I think that some versions of MAPI (Outlook) doesn't like several Windows accounts using mail at the
same time. Say that Agent and SQL Server uses the same service account. They might not conflict, but
if you are logged in interactively using some other account, you might be in for some problems.
Anyhow, I recommend Outlook 2000. Or actually, I don't recommend SQL Mail at all
(http://www.karaszi.com/SQLServer/info_no_mapi.asp), since it causes so many of these problems...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OLQuVxOjHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> It might also be related to whether all users use the same Windows account.
> If this is the case, then closing the outlook must not solve the problem I think
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%234lZSjNjHHA.680@.TK2MSFTNGP06.phx.gbl...
>>I believe this behavior can depend on your version of Outlook (I prefer Outlook 2000, I've seen
>>the strange behavior with later versions). It might also be related to whether all users use the
>>same Windows account.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message news:uMzUEcNjHHA.4872@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL
>> Mail and Agent Mail can use the file of mail profile to send email. But on one of client's
>> computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail
>> fail when try to connect to profile. When I close outlook, they can access profile. This is
>> strange behavior that I had never seen elsewhere.
>> Any help would be greatly appreciated.
>> Leila
>>
>

After Recovery...

Is it required/best practice to run any job/commands after restoring the SQL
database server? SQL2K.
Thank you for the answers.
Austin
Hi,
You can execute a DBCC CHECKDB('dbname') to confirm the database is in good
shape. As well as you can schedule
a UPDATE STATISTICS weekly once or daily (depends on the data size).
Thanks
Hari
SQL Server MVP
"JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
> Is it required/best practice to run any job/commands after restoring the
> SQL
> database server? SQL2K.
> Thank you for the answers.
> Austin
>
>
|||Thank you,
Austin
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239dgfUPrFHA.1172@.TK2MSFTNGP11.phx.gbl...
> Hi,
> You can execute a DBCC CHECKDB('dbname') to confirm the database is in
good
> shape. As well as you can schedule
> a UPDATE STATISTICS weekly once or daily (depends on the data size).
> Thanks
> Hari
> SQL Server MVP
>
> "JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
> news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
>

After Recovery...

Is it required/best practice to run any job/commands after restoring the SQL
database server? SQL2K.
Thank you for the answers.
AustinHi,
You can execute a DBCC CHECKDB('dbname') to confirm the database is in good
shape. As well as you can schedule
a UPDATE STATISTICS weekly once or daily (depends on the data size).
Thanks
Hari
SQL Server MVP
"JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
> Is it required/best practice to run any job/commands after restoring the
> SQL
> database server? SQL2K.
> Thank you for the answers.
> Austin
>
>|||Thank you,
Austin
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239dgfUPrFHA.1172@.TK2MSFTNGP11.phx.gbl...
> Hi,
> You can execute a DBCC CHECKDB('dbname') to confirm the database is in
good
> shape. As well as you can schedule
> a UPDATE STATISTICS weekly once or daily (depends on the data size).
> Thanks
> Hari
> SQL Server MVP
>
> "JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
> news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
>

After Recovery...

Is it required/best practice to run any job/commands after restoring the SQL
database server? SQL2K.
Thank you for the answers.
AustinHi,
You can execute a DBCC CHECKDB('dbname') to confirm the database is in good
shape. As well as you can schedule
a UPDATE STATISTICS weekly once or daily (depends on the data size).
Thanks
Hari
SQL Server MVP
"JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
> Is it required/best practice to run any job/commands after restoring the
> SQL
> database server? SQL2K.
> Thank you for the answers.
> Austin
>
>|||Thank you,
Austin
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239dgfUPrFHA.1172@.TK2MSFTNGP11.phx.gbl...
> Hi,
> You can execute a DBCC CHECKDB('dbname') to confirm the database is in
good
> shape. As well as you can schedule
> a UPDATE STATISTICS weekly once or daily (depends on the data size).
> Thanks
> Hari
> SQL Server MVP
>
> "JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
> news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
> > Is it required/best practice to run any job/commands after restoring the
> > SQL
> > database server? SQL2K.
> >
> > Thank you for the answers.
> >
> > Austin
> >
> >
> >
> >
>