dbTalk Databases Forums  

SQL 2000 Optimize Maint Step locks up server

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools SQL 2000 Optimize Maint Step locks up server

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL 2000 Optimize Maint Step locks up server in the microsoft.public.sqlserver.tools forum.



Reply
Page 1 of 6 1 2 3 4 5 6 >
 
Thread Tools Display Modes
  #1  
Old   
TMurnion
 
Posts: n/a

Default SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:36 PM





We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart

Any assistance is greatly appreciated.
Tony



Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM





TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #3  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #4  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #5  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #6  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #7  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #8  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #9  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #10  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-23-2008 , 05:45 PM


TMurnion (tmurnion (AT) azworld (DOT) com) writes:
Quote:
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart
Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply
Page 1 of 6 1 2 3 4 5 6 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top