Database Overwritten: trouble

Showing posts with label trouble. Show all posts

Thursday, March 29, 2012

Database name

First let me apologize...I am using SSRS 2000 and I haven't worked in
it in 2 years so I'm having trouble with some very elementary stuff.
I need to get the database name in a footer. Any help would be
greatly appreciated!
ReneeUse a dataset with the following: select db_name()
Then in the footer put a textbox and an expression. The expression will use
First (there is only one record so this works).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"beener" <rmp_colo@.hotmail.com> wrote in message
news:1188319538.901307.242230@.50g2000hsm.googlegroups.com...
> First let me apologize...I am using SSRS 2000 and I haven't worked in
> it in 2 years so I'm having trouble with some very elementary stuff.
> I need to get the database name in a footer. Any help would be
> greatly appreciated!
> Renee
>

Sunday, March 25, 2012

Database Mirroring Monitor

Hi there!

I've some trouble with monitoring a database mirroring session. I am testing a lot configuration possiblities, and i use the database mirroring monitor to view the mirroring states.

But in some (most) of my configurations, i only get following informations in the database mirroring monitor:

Oldest unsend transaction, Unrestored Log, Current Restore rate and the Witness Adress. I am working in High safety mode with automatic failover.

Question 1: What are the reasons that all the other indicators (Unsend log, Current send rate, Mirror commit overhead) are not shown?

Question 2: In the moment, i am using certificates for the mirroring communication. I think, my client (who the database mirroring monitor is running) connects with the usual windows authentication to the server and only selects from sys.database_mirroring or something else. So there is no need to create inbound certificates on the partners for the client who is connecting with the mirroring monitor?

Torsten

1. The counters that you say you cannot see are ones that are specific to the principal. Make sure that your connection from the monitor to the principal is good.

2.OK, sounds a little strange. Looks like the certs are what is messing things up. So, the connection from the monitor into the partners should be SA to make everything run nicely. But if the conneciton cannot be SA, then the monitor can come in as a normal login and get the data as long as the login is a member of the DBM_Monitor security group in MSDB. Note: the job that updates the base table for monitoring must be running as well.

Thanks,

Mark

|||

Hi Mark,

1. The connection is good, all related users have logins on the principle, are member of the dbm_monitor group, and are in sysadmin group.

In my opinion its not a problem of the database mirroring monitor, because the main stored procedure doesn't even show the results:

sp_dbmmonitorresults 'EASYRIS_41', 0,1

--> EASYRIS_41 1 4 1 NULL NULL NULL NULL NULL NULL NULL NULL 2006-06-21 12:38:44.547 2006-06-21 12:38:44.547 2006-06-21 14:38:44.547

Furthermore i've recognized that the Database Mirroring Monitor Job is located on the MIRROR (thats because the mirror has been the principal when i set up the session). Should the job run on BOTH partners? Furthermore the job is runnning under 'sa'. sa is not member of dbm_monitor group, and i can not put him into the group.

What is the exact recommendation? Is there any documentation i've not seen?

Thanks and sorry for the extra work ;-)

Torsten

|||

yes, you must run the job on both servers. if the job is running under SA then that's fine.

The user that the monitor logs in as can be in the dbm_monitor group if you do not want it to be SA. If it is SA, then the monitor should be able to update the info anyway...

mark

Sunday, March 11, 2012

Database Maintenance Plans

Hello all, I seem to be having some trouble with maintenance plans which
are to backup all my user dbs.
The plan worked before, backing up all the user dbs daily. However,
recently, I have noticed the dbs are not getting backed up. The latest
backup was on Sept. 21, 2004. I have not made any major changes, so I
don't know why the plan stopped working all of a sudden.
If I go to SQL Server Agent > Jobs > Right click on my backup job > View
Job History > Turn on show step details
I see two steps repeated many times
Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
The last step to run was step 1 (Step 1).
Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000] (Error
22029). The step failed.
I have tried creating a new job and set the time to run within a few
minutes, but it does not run. I believe the reason for this is because
under 'Next Run Date' it says (Date and time are not available). I have
also tried simply right clicking the job and clicking Start Job. This
appears to do nothing.
I have looked up numerous MS Knowledge Base articles
(http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
various newsgroup postings, but none seem to really cure my problem.
One thing I have accomplished was backing up the dbs manually using
sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
my job properties > Steps > Edit and found the TSQL script:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
"d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
-BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
I modified the line to:
sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
"d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
-BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
and ran it in a command prompt. The backups were created without any
problems. So why can't I create backups using Enterprise Manager >
Database Maintenance Plans?
I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
Any help is greatly appreciated.
Thanks,
HarryHave you verified that the SQL Server Agent is running?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
Hello all, I seem to be having some trouble with maintenance plans which
are to backup all my user dbs.
The plan worked before, backing up all the user dbs daily. However,
recently, I have noticed the dbs are not getting backed up. The latest
backup was on Sept. 21, 2004. I have not made any major changes, so I
don't know why the plan stopped working all of a sudden.
If I go to SQL Server Agent > Jobs > Right click on my backup job > View
Job History > Turn on show step details
I see two steps repeated many times
Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
The last step to run was step 1 (Step 1).
Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000] (Error
22029). The step failed.
I have tried creating a new job and set the time to run within a few
minutes, but it does not run. I believe the reason for this is because
under 'Next Run Date' it says (Date and time are not available). I have
also tried simply right clicking the job and clicking Start Job. This
appears to do nothing.
I have looked up numerous MS Knowledge Base articles
(http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
various newsgroup postings, but none seem to really cure my problem.
One thing I have accomplished was backing up the dbs manually using
sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
my job properties > Steps > Edit and found the TSQL script:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
"d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
-BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
I modified the line to:
sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
"d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
-BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
and ran it in a command prompt. The backups were created without any
problems. So why can't I create backups using Enterprise Manager >
Database Maintenance Plans?
I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
Any help is greatly appreciated.
Thanks,
Harry|||Yes it is running
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Have you verified that the SQL Server Agent is running?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
> Hello all, I seem to be having some trouble with maintenance plans which
> are to backup all my user dbs.
> The plan worked before, backing up all the user dbs daily. However,
> recently, I have noticed the dbs are not getting backed up. The latest
> backup was on Sept. 21, 2004. I have not made any major changes, so I
> don't know why the plan stopped working all of a sudden.
> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
> Job History > Turn on show step details
> I see two steps repeated many times
> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
> The last step to run was step 1 (Step 1).
> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000] (Error
> 22029). The step failed.
> I have tried creating a new job and set the time to run within a few
> minutes, but it does not run. I believe the reason for this is because
> under 'Next Run Date' it says (Date and time are not available). I have
> also tried simply right clicking the job and clicking Start Job. This
> appears to do nothing.
> I have looked up numerous MS Knowledge Base articles
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
> various newsgroup postings, but none seem to really cure my problem.
> One thing I have accomplished was backing up the dbs manually using
> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
> my job properties > Steps > Edit and found the TSQL script:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
> I modified the line to:
> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
> and ran it in a command prompt. The backups were created without any
> problems. So why can't I create backups using Enterprise Manager >
> Database Maintenance Plans?
> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
> Any help is greatly appreciated.
> Thanks,
> Harry
>|||Do you have any entries in the SQL Server or SQL Agent error logs - or the
Windows event logs?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
Yes it is running
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Have you verified that the SQL Server Agent is running?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
> Hello all, I seem to be having some trouble with maintenance plans which
> are to backup all my user dbs.
> The plan worked before, backing up all the user dbs daily. However,
> recently, I have noticed the dbs are not getting backed up. The latest
> backup was on Sept. 21, 2004. I have not made any major changes, so I
> don't know why the plan stopped working all of a sudden.
> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
> Job History > Turn on show step details
> I see two steps repeated many times
> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
> The last step to run was step 1 (Step 1).
> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000] (Error
> 22029). The step failed.
> I have tried creating a new job and set the time to run within a few
> minutes, but it does not run. I believe the reason for this is because
> under 'Next Run Date' it says (Date and time are not available). I have
> also tried simply right clicking the job and clicking Start Job. This
> appears to do nothing.
> I have looked up numerous MS Knowledge Base articles
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
> various newsgroup postings, but none seem to really cure my problem.
> One thing I have accomplished was backing up the dbs manually using
> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
> my job properties > Steps > Edit and found the TSQL script:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
> I modified the line to:
> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
> and ran it in a command prompt. The backups were created without any
> problems. So why can't I create backups using Enterprise Manager >
> Database Maintenance Plans?
> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
> Any help is greatly appreciated.
> Thanks,
> Harry
>|||There doesn't seem to be any relevant information in the SQL Server log.
For the SQL Agent logs, isn't it what I originally posted? Or do I find
this somewhere else. Windows Event Log gives me:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
(The event ID is 208)
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Do you have any entries in the SQL Server or SQL Agent error logs - or the
> Windows event logs?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
> Yes it is running
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000] (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>|||Right click on SQL Server Agent in EM. Click on Display Error Log. I the
drop-down, select All Types. See if anything pops out.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
There doesn't seem to be any relevant information in the SQL Server log.
For the SQL Agent logs, isn't it what I originally posted? Or do I find
this somewhere else. Windows Event Log gives me:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
(The event ID is 208)
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Do you have any entries in the SQL Server or SQL Agent error logs - or the
> Windows event logs?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
> Yes it is running
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
(Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>|||Yes
There are 12 information messages and 1 warning. No errors.
Is there anything in particular you are looking for?
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Right click on SQL Server Agent in EM. Click on Display Error Log. I the
> drop-down, select All Types. See if anything pops out.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
> There doesn't seem to be any relevant information in the SQL Server log.
> For the SQL Agent logs, isn't it what I originally posted? Or do I find
> this somewhere else. Windows Event Log gives me:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
> (The event ID is 208)
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs > Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>|||What did the warning say?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
Yes
There are 12 information messages and 1 warning. No errors.
Is there anything in particular you are looking for?
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Right click on SQL Server Agent in EM. Click on Display Error Log. I the
> drop-down, select All Types. See if anything pops out.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
> There doesn't seem to be any relevant information in the SQL Server log.
> For the SQL Agent logs, isn't it what I originally posted? Or do I find
> this somewhere else. Windows Event Log gives me:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
> (The event ID is 208)
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>|||[396] An idle CPU condition has not been defined - OnIdle job schedules
will have no effect
On Fri, 8 Oct 2004, Tom Moreau wrote:
> What did the warning say?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
> Yes
> There are 12 information messages and 1 warning. No errors.
> Is there anything in particular you are looking for?
>
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Right click on SQL Server Agent in EM. Click on Display Error Log. I the
>> drop-down, select All Types. See if anything pops out.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
>> There doesn't seem to be any relevant information in the SQL Server log.
>> For the SQL Agent logs, isn't it what I originally posted? Or do I find
>> this somewhere else. Windows Event Log gives me:
>> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
>> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
>> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
>> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
>> (The event ID is 208)
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
> the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job > View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
> 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
>> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
> Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>>
>|||Can you run other - non-DBMaint - jobs through SQL Agent? I'm trying to
narrow down the scope of the problem.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081433390.1425@.pastpower.net...
[396] An idle CPU condition has not been defined - OnIdle job schedules
will have no effect
On Fri, 8 Oct 2004, Tom Moreau wrote:
> What did the warning say?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
> Yes
> There are 12 information messages and 1 warning. No errors.
> Is there anything in particular you are looking for?
>
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Right click on SQL Server Agent in EM. Click on Display Error Log. I
the
>> drop-down, select All Types. See if anything pops out.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
>> There doesn't seem to be any relevant information in the SQL Server log.
>> For the SQL Agent logs, isn't it what I originally posted? Or do I find
>> this somewhere else. Windows Event Log gives me:
>> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
>> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
>> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
>> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
>> (The event ID is 208)
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
> the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans
which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job >
View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
> 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
>> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I
have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
> Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>>
>|||Yes, I believe so.
I have other successfully completed jobs in SQL Server Agent > Jobs
Such as:
Start_Full on Palmas.PagesSearch.[15.6]
Desc: Scheduled full-text full population for full-text Catalog
PagesSearch in database Palmas. This job was created by the full-text
scheduling dialog or full-text index wizard..
SmartRisk Daily Content Expiry
Desc: Execute package: SmartRisk Daily Content Expiry
Which have completed successfully...
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Can you run other - non-DBMaint - jobs through SQL Agent? I'm trying to
> narrow down the scope of the problem.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081433390.1425@.pastpower.net...
> [396] An idle CPU condition has not been defined - OnIdle job schedules
> will have no effect
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> What did the warning say?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
>> Yes
>> There are 12 information messages and 1 warning. No errors.
>> Is there anything in particular you are looking for?
>>
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Right click on SQL Server Agent in EM. Click on Display Error Log. I
> the
>> drop-down, select All Types. See if anything pops out.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
>> There doesn't seem to be any relevant information in the SQL Server log.
>> For the SQL Agent logs, isn't it what I originally posted? Or do I find
>> this somewhere else. Windows Event Log gives me:
>> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
>> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked on:
>> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
>> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
>> (The event ID is 208)
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
>> the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans
> which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job >
> View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
>> 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
>> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is because
>> under 'Next Run Date' it says (Date and time are not available). I
> have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
>> Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>>
>>
>|||I get the feeling that somehow, the DLL's relating to DBmaint may be
corrupted. I know you've tried re-doing the job. How about a new, simple
DB maintenance plan - just Northwind, full backup? Does that work?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081503020.1425@.pastpower.net...
Yes, I believe so.
I have other successfully completed jobs in SQL Server Agent > Jobs
Such as:
Start_Full on Palmas.PagesSearch.[15.6]
Desc: Scheduled full-text full population for full-text Catalog
PagesSearch in database Palmas. This job was created by the full-text
scheduling dialog or full-text index wizard..
SmartRisk Daily Content Expiry
Desc: Execute package: SmartRisk Daily Content Expiry
Which have completed successfully...
On Fri, 8 Oct 2004, Tom Moreau wrote:
> Can you run other - non-DBMaint - jobs through SQL Agent? I'm trying to
> narrow down the scope of the problem.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081433390.1425@.pastpower.net...
> [396] An idle CPU condition has not been defined - OnIdle job schedules
> will have no effect
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> What did the warning say?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
>> Yes
>> There are 12 information messages and 1 warning. No errors.
>> Is there anything in particular you are looking for?
>>
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Right click on SQL Server Agent in EM. Click on Display Error Log. I
> the
>> drop-down, select All Types. See if anything pops out.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
>> There doesn't seem to be any relevant information in the SQL Server log.
>> For the SQL Agent logs, isn't it what I originally posted? Or do I find
>> this somewhere else. Windows Event Log gives me:
>> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
>> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked
on:
>> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
>> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
>> (The event ID is 208)
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
>> the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans
> which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The
latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job >
> View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
>> 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
>> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is
because
>> under 'Next Run Date' it says (Date and time are not available). I
> have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
>> Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>>
>>
>|||No, I tried that too before but with a different database.
I also tried it again now with Northwind.
It does not seem to execute. Under next run date it says dat and time are
not available. I also tried right clicking on the job and pressing start
job. Nothing seemed to happen...
On Fri, 8 Oct 2004, Tom Moreau wrote:
> I get the feeling that somehow, the DLL's relating to DBmaint may be
> corrupted. I know you've tried re-doing the job. How about a new, simple
> DB maintenance plan - just Northwind, full backup? Does that work?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081503020.1425@.pastpower.net...
> Yes, I believe so.
> I have other successfully completed jobs in SQL Server Agent > Jobs
> Such as:
> Start_Full on Palmas.PagesSearch.[15.6]
> Desc: Scheduled full-text full population for full-text Catalog
> PagesSearch in database Palmas. This job was created by the full-text
> scheduling dialog or full-text index wizard..
> SmartRisk Daily Content Expiry
> Desc: Execute package: SmartRisk Daily Content Expiry
> Which have completed successfully...
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Can you run other - non-DBMaint - jobs through SQL Agent? I'm trying to
>> narrow down the scope of the problem.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081433390.1425@.pastpower.net...
>> [396] An idle CPU condition has not been defined - OnIdle job schedules
>> will have no effect
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> What did the warning say?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
>> Yes
>> There are 12 information messages and 1 warning. No errors.
>> Is there anything in particular you are looking for?
>>
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Right click on SQL Server Agent in EM. Click on Display Error Log. I
>> the
>> drop-down, select All Types. See if anything pops out.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
>> There doesn't seem to be any relevant information in the SQL Server log.
>> For the SQL Agent logs, isn't it what I originally posted? Or do I find
>> this somewhere else. Windows Event Log gives me:
>> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
>> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked
> on:
>> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
>> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
>> (The event ID is 208)
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
>> the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans
>> which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The
> latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job >
>> View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
>> 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
>> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is
> because
>> under 'Next Run Date' it says (Date and time are not available). I
>> have
>> also tried simply right clicking the job and clicking Start Job. This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
>> Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>>
>>
>>
>|||I think you're gonna have to open a ticket with Product Support Services.
It sounds like something has been corrupted.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Harry Kim" <heri0n@.pastpower.net> wrote in message
news:Pine.LNX.4.60.0410081547010.1425@.pastpower.net...
No, I tried that too before but with a different database.
I also tried it again now with Northwind.
It does not seem to execute. Under next run date it says dat and time are
not available. I also tried right clicking on the job and pressing start
job. Nothing seemed to happen...
On Fri, 8 Oct 2004, Tom Moreau wrote:
> I get the feeling that somehow, the DLL's relating to DBmaint may be
> corrupted. I know you've tried re-doing the job. How about a new, simple
> DB maintenance plan - just Northwind, full backup? Does that work?
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
> "Harry Kim" <heri0n@.pastpower.net> wrote in message
> news:Pine.LNX.4.60.0410081503020.1425@.pastpower.net...
> Yes, I believe so.
> I have other successfully completed jobs in SQL Server Agent > Jobs
> Such as:
> Start_Full on Palmas.PagesSearch.[15.6]
> Desc: Scheduled full-text full population for full-text Catalog
> PagesSearch in database Palmas. This job was created by the full-text
> scheduling dialog or full-text index wizard..
> SmartRisk Daily Content Expiry
> Desc: Execute package: SmartRisk Daily Content Expiry
> Which have completed successfully...
> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Can you run other - non-DBMaint - jobs through SQL Agent? I'm trying to
>> narrow down the scope of the problem.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081433390.1425@.pastpower.net...
>> [396] An idle CPU condition has not been defined - OnIdle job schedules
>> will have no effect
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> What did the warning say?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081409270.1410@.pastpower.net...
>> Yes
>> There are 12 information messages and 1 warning. No errors.
>> Is there anything in particular you are looking for?
>>
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Right click on SQL Server Agent in EM. Click on Display Error Log. I
>> the
>> drop-down, select All Types. See if anything pops out.
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081307240.1373@.pastpower.net...
>> There doesn't seem to be any relevant information in the SQL Server
log.
>> For the SQL Agent logs, isn't it what I originally posted? Or do I
find
>> this somewhere else. Windows Event Log gives me:
>> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'user
>> dbs'' (0x9AC86DAEC2694A469BADFCFAD9063C53) - Status: Failed - Invoked
> on:
>> 2004-10-08 01:00:00 - Message: The job failed. The Job was invoked by
>> Schedule 30 (Schedule 1). The last step to run was step 1 (Step 1).
>> (The event ID is 208)
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Do you have any entries in the SQL Server or SQL Agent error logs - or
>> the
>> Windows event logs?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081204240.1323@.pastpower.net...
>> Yes it is running
>> On Fri, 8 Oct 2004, Tom Moreau wrote:
>> Have you verified that the SQL Server Agent is running?
>> --
>> Tom
>> ---
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>> "Harry Kim" <heri0n@.pastpower.net> wrote in message
>> news:Pine.LNX.4.60.0410081056070.1087@.pastpower.net...
>> Hello all, I seem to be having some trouble with maintenance plans
>> which
>> are to backup all my user dbs.
>> The plan worked before, backing up all the user dbs daily. However,
>> recently, I have noticed the dbs are not getting backed up. The
> latest
>> backup was on Sept. 21, 2004. I have not made any major changes, so
I
>> don't know why the plan stopped working all of a sudden.
>> If I go to SQL Server Agent > Jobs > Right click on my backup job >
>> View
>> Job History > Turn on show step details
>> I see two steps repeated many times
>> Step 0: The job failed. The Job was invoked by Schedule 30 (Schedule
>> 1).
>> The last step to run was step 1 (Step 1).
>> Step 1: Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000]
>> (Error
>> 22029). The step failed.
>> I have tried creating a new job and set the time to run within a few
>> minutes, but it does not run. I believe the reason for this is
> because
>> under 'Next Run Date' it says (Date and time are not available). I
>> have
>> also tried simply right clicking the job and clicking Start Job.
This
>> appears to do nothing.
>> I have looked up numerous MS Knowledge Base articles
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;288577) and
>> various newsgroup postings, but none seem to really cure my problem.
>> One thing I have accomplished was backing up the dbs manually using
>> sqlmaint in a command prompt. I went to SQL Server Agent > Jobs >
>> Opened
>> my job properties > Steps > Edit and found the TSQL script:
>> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>> 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> I modified the line to:
>> sqlmaint -PlanID 1D626322-E403-4065-A37C-EE5F8B9BC2E0 -To "hkim" -Rpt
>> "d:\mssqldata\MSSQL\LOG\user dbs4.txt" -DelTxtRpt 4DAYS -WriteHistory
>> -BkUpMedia DISK -BkUpDB "E:\sqlback" -DelBkUps 3DAYS -BkExt "BAK"'
>> and ran it in a command prompt. The backups were created without any
>> problems. So why can't I create backups using Enterprise Manager >
>> Database Maintenance Plans?
>> I am running MS-SQL 2000 (8.00.760) on Windows 2000 Server.
>> Any help is greatly appreciated.
>> Thanks,
>> Harry
>>
>>
>>
>>
>>
>

Thursday, March 29, 2012

Database name

Sunday, March 25, 2012

Database Mirroring Monitor

Sunday, March 11, 2012

Database Maintenance Plans

Database Maintenance Plans

Database Overwritten

Blog Archive

About Me