maint plan job hangs

I have a maint plan that backups up the t-logs of all the user databases,
while executing, the job runs nice and fast, but at the very end, when all
the backups are complete and you expect to see the job status to change from
'Executing' to 'Not Running', it doesn't.
the report is missing the last portion also, which should be :
"End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
SQLMAINT.EXE Process Exit Code: 0 (Success)"
Anybody know why ?
Is there a way to set a more verbose output ?
"Johnny" <Johnny@.Knoxville.com> wrote in message
news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
> I have a maint plan that backups up the t-logs of all the user databases,
> while executing, the job runs nice and fast, but at the very end, when all
> the backups are complete and you expect to see the job status to change
from
> 'Executing' to 'Not Running', it doesn't.
Do you have it setup to email upon completion?
Is Email working?
This is the most common cause I've seen.

> the report is missing the last portion also, which should be :
> "End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
> SQLMAINT.EXE Process Exit Code: 0 (Success)"
> Anybody know why ?
> Is there a way to set a more verbose output ?
>
>
|||no e-mail setup
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:kChfd.329041$bp1.38790@.twister.nyroc.rr.com.. .[vbcol=seagreen]
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
databases,[vbcol=seagreen]
all
> from
> Do you have it setup to email upon completion?
> Is Email working?
> This is the most common cause I've seen.
>
>

maint plan job hangs

I have a maint plan that backups up the t-logs of all the user databases,
while executing, the job runs nice and fast, but at the very end, when all
the backups are complete and you expect to see the job status to change from
'Executing' to 'Not Running', it doesn't.
the report is missing the last portion also, which should be :
"End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
SQLMAINT.EXE Process Exit Code: 0 (Success)"
Anybody know why ?
Is there a way to set a more verbose output ?"Johnny" <Johnny@.Knoxville.com> wrote in message
news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
> I have a maint plan that backups up the t-logs of all the user databases,
> while executing, the job runs nice and fast, but at the very end, when all
> the backups are complete and you expect to see the job status to change
from
> 'Executing' to 'Not Running', it doesn't.
Do you have it setup to email upon completion?
Is Email working?
This is the most common cause I've seen.
> the report is missing the last portion also, which should be :
> "End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
> SQLMAINT.EXE Process Exit Code: 0 (Success)"
> Anybody know why ?
> Is there a way to set a more verbose output ?
>
>|||no e-mail setup
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:kChfd.329041$bp1.38790@.twister.nyroc.rr.com...
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
> > I have a maint plan that backups up the t-logs of all the user
databases,
> > while executing, the job runs nice and fast, but at the very end, when
all
> > the backups are complete and you expect to see the job status to change
> from
> > 'Executing' to 'Not Running', it doesn't.
> Do you have it setup to email upon completion?
> Is Email working?
> This is the most common cause I've seen.
>
> >
> > the report is missing the last portion also, which should be :
> > "End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
> > SQLMAINT.EXE Process Exit Code: 0 (Success)"
> >
> > Anybody know why ?
> > Is there a way to set a more verbose output ?
> >
> >
> >
>

maint plan job hangs

I have a maint plan that backups up the t-logs of all the user databases,
while executing, the job runs nice and fast, but at the very end, when all
the backups are complete and you expect to see the job status to change from
'Executing' to 'Not Running', it doesn't.
the report is missing the last portion also, which should be :
"End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
SQLMAINT.EXE Process Exit Code: 0 (Success)"
Anybody know why ?
Is there a way to set a more verbose output ?"Johnny" <Johnny@.Knoxville.com> wrote in message
news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
> I have a maint plan that backups up the t-logs of all the user databases,
> while executing, the job runs nice and fast, but at the very end, when all
> the backups are complete and you expect to see the job status to change
from
> 'Executing' to 'Not Running', it doesn't.
Do you have it setup to email upon completion?
Is Email working?
This is the most common cause I've seen.

> the report is missing the last portion also, which should be :
> "End of maintenance plan 'All_General' on 10/24/2004 3:00:30 PM
> SQLMAINT.EXE Process Exit Code: 0 (Success)"
> Anybody know why ?
> Is there a way to set a more verbose output ?
>
>|||no e-mail setup
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:kChfd.329041$bp1.38790@.twister.nyroc.rr.com...
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:OBdqNwruEHA.3976@.TK2MSFTNGP09.phx.gbl...
databases,[vbcol=seagreen]
all[vbcol=seagreen]
> from
> Do you have it setup to email upon completion?
> Is Email working?
> This is the most common cause I've seen.
>
>

Machine hangs after SQL QA query

I tried to delete some records from a table that has 10 million records
(delete <table> where xxx= 'yyy'). This does not have any matching index. So
it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
machine hanged.
Then today, I stopped the query, and waited for hours...
When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
and huge memory (both). I believe its still rolling back the 'delete'
transactions.
Is there any way to clean up the resource, and start using the machine in a
normal way? (Im also in the process of increasing the memory to atleast 2GB).
Pl. note that I may not be able to open the EM or QA due to the underlying
heavy load/recovery process(?)...
Thanks a lot
Philipus
Message posted via http://www.droptable.com
Additional Info:
This host has AntiVirus enabled. But I dont think the MDB etc. are excluded
from scanning. But I dont think the QA query mentioned would have anything to
do with AV scan! Does it? What kind of configuration does the AV needs so it
both does its work properly, but at the same time does not hinder my SQL
server work?
-philipus
Philipus wrote:
>I tried to delete some records from a table that has 10 million records
>(delete <table> where xxx= 'yyy'). This does not have any matching index. So
>it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
>machine hanged.
>Then today, I stopped the query, and waited for hours...
>When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
>and huge memory (both). I believe its still rolling back the 'delete'
>transactions.
>Is there any way to clean up the resource, and start using the machine in a
>normal way? (Im also in the process of increasing the memory to atleast 2GB).
>Pl. note that I may not be able to open the EM or QA due to the underlying
>heavy load/recovery process(?)...
>Thanks a lot
>Philipus
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200507/1
|||Can you open the SQL Server error log from the windows explorer? If the
database is still recovering you will see messages related to that in the
error log. I think you should just let the database recover.
Do you happen to have a backup that is good enough to replace the current
database?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Philipus via droptable.com" <forum@.droptable.com> wrote in message
news:51A7C2ADFB58F@.droptable.com...
I tried to delete some records from a table that has 10 million records
(delete <table> where xxx= 'yyy'). This does not have any matching index. So
it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
machine hanged.
Then today, I stopped the query, and waited for hours...
When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
and huge memory (both). I believe its still rolling back the 'delete'
transactions.
Is there any way to clean up the resource, and start using the machine in a
normal way? (Im also in the process of increasing the memory to atleast
2GB).
Pl. note that I may not be able to open the EM or QA due to the underlying
heavy load/recovery process(?)...
Thanks a lot
Philipus
Message posted via http://www.droptable.com
|||Since I was not able to do anything in the machine, I just left it for
another day, and it came up after clearing the rollback. Now its normal. The
error log has a huge list of ' roll back...recovering...'
Thanks reddy!
philipus
Narayana Vyas Kondreddi wrote:
>Can you open the SQL Server error log from the windows explorer? If the
>database is still recovering you will see messages related to that in the
>error log. I think you should just let the database recover.
>Do you happen to have a backup that is good enough to replace the current
>database?
>I tried to delete some records from a table that has 10 million records
>(delete <table> where xxx= 'yyy'). This does not have any matching index. So
>it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
>machine hanged.
>Then today, I stopped the query, and waited for hours...
>When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
>and huge memory (both). I believe its still rolling back the 'delete'
>transactions.
>Is there any way to clean up the resource, and start using the machine in a
>normal way? (Im also in the process of increasing the memory to atleast
>2GB).
>Pl. note that I may not be able to open the EM or QA due to the underlying
>heavy load/recovery process(?)...
>Thanks a lot
>Philipus
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200507/1

Machine hangs after SQL QA query

I tried to delete some records from a table that has 10 million records
(delete <table> where xxx= 'yyy'). This does not have any matching index. So
it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
machine hanged.
Then today, I stopped the query, and waited for hours...
When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
and huge memory (both). I believe its still rolling back the 'delete'
transactions.
Is there any way to clean up the resource, and start using the machine in a
normal way? (Im also in the process of increasing the memory to atleast 2GB).
Pl. note that I may not be able to open the EM or QA due to the underlying
heavy load/recovery process(?)...
Thanks a lot
Philipus
--
Message posted via http://www.sqlmonster.comAdditional Info:
This host has AntiVirus enabled. But I dont think the MDB etc. are excluded
from scanning. But I dont think the QA query mentioned would have anything to
do with AV scan! Does it? What kind of configuration does the AV needs so it
both does its work properly, but at the same time does not hinder my SQL
server work?
-philipus
Philipus wrote:
>I tried to delete some records from a table that has 10 million records
>(delete <table> where xxx= 'yyy'). This does not have any matching index. So
>it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
>machine hanged.
>Then today, I stopped the query, and waited for hours...
>When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
>and huge memory (both). I believe its still rolling back the 'delete'
>transactions.
>Is there any way to clean up the resource, and start using the machine in a
>normal way? (Im also in the process of increasing the memory to atleast 2GB).
>Pl. note that I may not be able to open the EM or QA due to the underlying
>heavy load/recovery process(?)...
>Thanks a lot
>Philipus
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200507/1|||Can you open the SQL Server error log from the windows explorer? If the
database is still recovering you will see messages related to that in the
error log. I think you should just let the database recover.
Do you happen to have a backup that is good enough to replace the current
database?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Philipus via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:51A7C2ADFB58F@.SQLMonster.com...
I tried to delete some records from a table that has 10 million records
(delete <table> where xxx= 'yyy'). This does not have any matching index. So
it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
machine hanged.
Then today, I stopped the query, and waited for hours...
When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
and huge memory (both). I believe its still rolling back the 'delete'
transactions.
Is there any way to clean up the resource, and start using the machine in a
normal way? (Im also in the process of increasing the memory to atleast
2GB).
Pl. note that I may not be able to open the EM or QA due to the underlying
heavy load/recovery process(?)...
Thanks a lot
Philipus
Message posted via http://www.sqlmonster.com|||Since I was not able to do anything in the machine, I just left it for
another day, and it came up after clearing the rollback. Now its normal. The
error log has a huge list of ' roll back...recovering...'
Thanks reddy!
philipus
Narayana Vyas Kondreddi wrote:
>Can you open the SQL Server error log from the windows explorer? If the
>database is still recovering you will see messages related to that in the
>error log. I think you should just let the database recover.
>Do you happen to have a backup that is good enough to replace the current
>database?
>I tried to delete some records from a table that has 10 million records
>(delete <table> where xxx= 'yyy'). This does not have any matching index. So
>it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
>machine hanged.
>Then today, I stopped the query, and waited for hours...
>When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
>and huge memory (both). I believe its still rolling back the 'delete'
>transactions.
>Is there any way to clean up the resource, and start using the machine in a
>normal way? (Im also in the process of increasing the memory to atleast
>2GB).
>Pl. note that I may not be able to open the EM or QA due to the underlying
>heavy load/recovery process(?)...
>Thanks a lot
>Philipus
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200507/1

Machine hangs after SQL QA query

I tried to delete some records from a table that has 10 million records
(delete <table> where xxx= 'yyy'). This does not have any matching index. So
it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
machine hanged.
Then today, I stopped the query, and waited for hours...
When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
and huge memory (both). I believe its still rolling back the 'delete'
transactions.
Is there any way to clean up the resource, and start using the machine in a
normal way? (Im also in the process of increasing the memory to atleast 2GB)
.
Pl. note that I may not be able to open the EM or QA due to the underlying
heavy load/recovery process(?)...
Thanks a lot
Philipus
Message posted via http://www.droptable.comAdditional Info:
This host has AntiVirus enabled. But I dont think the MDB etc. are excluded
from scanning. But I dont think the QA query mentioned would have anything t
o
do with AV scan! Does it? What kind of configuration does the AV needs so i
t
both does its work properly, but at the same time does not hinder my SQL
server work?
-philipus
Philipus wrote:
>I tried to delete some records from a table that has 10 million records
>(delete <table> where xxx= 'yyy'). This does not have any matching index. S
o
>it used up all the memory (500 MB) ,and the swap(virtual mem), and the whol
e
>machine hanged.
>Then today, I stopped the query, and waited for hours...
>When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CP
U
>and huge memory (both). I believe its still rolling back the 'delete'
>transactions.
>Is there any way to clean up the resource, and start using the machine in a
>normal way? (Im also in the process of increasing the memory to atleast 2GB
).
>Pl. note that I may not be able to open the EM or QA due to the underlying
>heavy load/recovery process(?)...
>Thanks a lot
>Philipus
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200507/1|||Can you open the SQL Server error log from the windows explorer? If the
database is still recovering you will see messages related to that in the
error log. I think you should just let the database recover.
Do you happen to have a backup that is good enough to replace the current
database?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Philipus via droptable.com" <forum@.droptable.com> wrote in message
news:51A7C2ADFB58F@.droptable.com...
I tried to delete some records from a table that has 10 million records
(delete <table> where xxx= 'yyy'). This does not have any matching index. So
it used up all the memory (500 MB) ,and the swap(virtual mem), and the whole
machine hanged.
Then today, I stopped the query, and waited for hours...
When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CPU
and huge memory (both). I believe its still rolling back the 'delete'
transactions.
Is there any way to clean up the resource, and start using the machine in a
normal way? (Im also in the process of increasing the memory to atleast
2GB).
Pl. note that I may not be able to open the EM or QA due to the underlying
heavy load/recovery process(?)...
Thanks a lot
Philipus
Message posted via http://www.droptable.com|||Since I was not able to do anything in the machine, I just left it for
another day, and it came up after clearing the rollback. Now its normal. The
error log has a huge list of ' roll back...recovering...'
Thanks reddy!
philipus
Narayana Vyas Kondreddi wrote:
>Can you open the SQL Server error log from the windows explorer? If the
>database is still recovering you will see messages related to that in the
>error log. I think you should just let the database recover.
>Do you happen to have a backup that is good enough to replace the current
>database?
>I tried to delete some records from a table that has 10 million records
>(delete <table> where xxx= 'yyy'). This does not have any matching index. S
o
>it used up all the memory (500 MB) ,and the swap(virtual mem), and the whol
e
>machine hanged.
>Then today, I stopped the query, and waited for hours...
>When I rebooted, it took hours to come up, and the sqlsrvr runs with 50% CP
U
>and huge memory (both). I believe its still rolling back the 'delete'
>transactions.
>Is there any way to clean up the resource, and start using the machine in a
>normal way? (Im also in the process of increasing the memory to atleast
>2GB).
>Pl. note that I may not be able to open the EM or QA due to the underlying
>heavy load/recovery process(?)...
>Thanks a lot
>Philipus
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200507/1