Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts

Friday, March 30, 2012

Maintenance Plan Failed SQL2005

I am trying to create a simple Maintenance Plan using the Wizard to
backup my databases. When I click finish everything works fine apart
from the last step, "Saving Maintenance Plan". The report I get is
this
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Success)
- Adding tasks to the maintenance plan (Success)
- Adding scheduling options (Success)
- Adding reporting options (Success)
- Saving maintenance plan "MaintenancePlan" (Error)
Messages
Saving maintenance plan failed.
ADDITIONAL INFORMATION:
Class not registered
Class not registered
I have a standard installation of SQL2005 Enterprise and have made sure
SSIS is installed and running. Any ideas on what Class is not
registered and how to fix this would be greatly appreciated.Although I haven't fixed the problem or found out which class it is
looking for I have found that this is only happening on 1 workstation.

Maintenance Plan Failed SQL2005

I am trying to create a simple Maintenance Plan using the Wizard to
backup my databases. When I click finish everything works fine apart
from the last step, "Saving Maintenance Plan". The report I get is
this
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Success)
- Adding tasks to the maintenance plan (Success)
- Adding scheduling options (Success)
- Adding reporting options (Success)
- Saving maintenance plan "MaintenancePlan" (Error)
Messages
Saving maintenance plan failed.
ADDITIONAL INFORMATION:
Class not registered

Class not registered
I have a standard installation of SQL2005 Enterprise and have made sure
SSIS is installed and running. Any ideas on what Class is not
registered and how to fix this would be greatly appreciated.
Although I haven't fixed the problem or found out which class it is
looking for I have found that this is only happening on 1 workstation.

Maintenance Plan Failed SQL2005

I am trying to create a simple Maintenance Plan using the Wizard to
backup my databases. When I click finish everything works fine apart
from the last step, "Saving Maintenance Plan". The report I get is
this
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Success)
- Adding tasks to the maintenance plan (Success)
- Adding scheduling options (Success)
- Adding reporting options (Success)
- Saving maintenance plan "MaintenancePlan" (Error)
Messages
Saving maintenance plan failed.
--
ADDITIONAL INFORMATION:
Class not registered
--
Class not registered
I have a standard installation of SQL2005 Enterprise and have made sure
SSIS is installed and running. Any ideas on what Class is not
registered and how to fix this would be greatly appreciated.Although I haven't fixed the problem or found out which class it is
looking for I have found that this is only happening on 1 workstation.

Wednesday, March 21, 2012

Maintenance cleanup task not deleting files

Running SQL2005 STD.

I have a maintenance cleanup task that is not actually deleting the files that it should be.

Here's the most recently task generated T-SQL statement:

EXECUTE master.dbo.xp_delete_file 0,N'F:\Program Files\Microsoft SQL Server\MSSQL\BACKUP',N'bak',N'12/05/2006 10:42:08'

The problem is that the files aren't actually being deleted when the job runs. However, if I create a new job with the statement as a single step or run it manually from a query window then the files are deleted as expected.

Is there anything I should be looking for? The job runs as 'sa' and I connect to the database engine using 'sa'... any ideas?

Thanks!Hi Davve,

Do you get an error message saying the the job has failed or does it appear to run successfully?

If its the latter is it possibly you can run sql profiler and run the job so we can help you further.

Pace
|||

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. We use issues reported by customers to prioritize future work including service packs.

What is the version number of SQL Server Management Studio you are running? You can check in the About... dialog shown by clicking the "Help | About..." menu item in SSMS.

Thanks,
Steve

|||It turns out that after a routine reboot of the server, the following time the job ran it deleted the files. Thanks for the replies.

Maintenance cleanup task not deleting files

Running SQL2005 STD.

I have a maintenance cleanup task that is not actually deleting the files that it should be.

Here's the most recently task generated T-SQL statement:

EXECUTE master.dbo.xp_delete_file 0,N'F:\Program Files\Microsoft SQL Server\MSSQL\BACKUP',N'bak',N'12/05/2006 10:42:08'

The problem is that the files aren't actually being deleted when the job runs. However, if I create a new job with the statement as a single step or run it manually from a query window then the files are deleted as expected.

Is there anything I should be looking for? The job runs as 'sa' and I connect to the database engine using 'sa'... any ideas?

Thanks!Hi Davve,

Do you get an error message saying the the job has failed or does it appear to run successfully?

If its the latter is it possibly you can run sql profiler and run the job so we can help you further.

Pace
|||

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. We use issues reported by customers to prioritize future work including service packs.

What is the version number of SQL Server Management Studio you are running? You can check in the About... dialog shown by clicking the "Help | About..." menu item in SSMS.

Thanks,
Steve

|||It turns out that after a routine reboot of the server, the following time the job ran it deleted the files. Thanks for the replies.sql

Monday, February 20, 2012

mac sql2005 express

I recognize that this question borders on blasphemy but I am curious as to whether there is a version of sql2005 express for the mac platform. Would like to keep a compatible local instance of 2005 on my mac notebook.

many thanks,
dj

Hi,
actually no. :-) But you can sure run a Virtualisation running SQL Server in whatever sandbox your virtualisation software is supporting. The requirements of each edition can found here:
http://www.microsoft.com/sql/editions/default.mspx
HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

LSASS.EXE high CPU usage

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.
Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>
|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:

> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>

LSASS.EXE high CPU usage

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> > I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
> serious
> > problem.
> >
> > Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
> usage
> > to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
> The
> > consequence of course being that the server goes to a constant 100% CPU
> > usage, causing services to be denied or be unacceptably slow. During
> normal
> > operation (when LSASS is behaving), the server spec is more than enough to
> > cope with it's workload, and runs at around 20% CPU usage.
> >
> > There were issues with LSASS.EXE in Win2k, but none that I know of or can
> > find in Win2k3. This is not a SASSER type worm virus, it's genuine
> LSASS.EXE.
> > I'm not even sure if this is the cause of the problem or a symptom of
> > something else.
> >
> > Please suggest something, this is a critical production server and this
> has
> > now become a serious issue.
> >
> > Thanks.
> >
> >
>
>

LSASS.EXE high CPU usage

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a seriou
s
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE
.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:

> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> ________________________________________
__________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>