I am running a SQL Server 2000 installation with several databases. Each
database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run, but
displays no error. There is no entry in the job history. The same thing
happens when I try to run the individual jobs from Enterprise Manager.
I've checked the database recovery model (full), the location of the backup
files (same as the other databases), and just about everything else I can
think of. The scheduled maintenance plan for every other database runs as
it should.
What am I missing?
Thanks
Iain 6 3170
"Iain Hosking" <ii************ *********@thesp amfreeweather.c om.au> wrote in
message news:40******** *************** @titanium.syd.n tt.net.au... I am running a SQL Server 2000 installation with several databases. Each database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run, but displays no error. There is no entry in the job history. The same thing happens when I try to run the individual jobs from Enterprise Manager.
I've checked the database recovery model (full), the location of the
backup files (same as the other databases), and just about everything else I can think of. The scheduled maintenance plan for every other database runs as it should.
What am I missing?
Is SQL Agent service running? This service is required
to be running for the above automation.
Additionally, I would disassociate the backups and the
maintenance plans by creating each as separate tasks,
the former being far more critical than the latter.
Pete Brown
Winluck P/L
Falls Creek
Australia
Hi,
A wild guess is you're looking at the job history via EM. You're
right clicking on the sql agent jobs and select view history. The
view history says job successful. But when you check the view step
details, you see that some of the job steps failed?? If that is the
case you'll need to query the system tables. A script to do that is
located at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30388.
Mountain Man
Thanks for the answer. Yes, SQL Server Agent is running. Every other
database is being backed up according to the plan.
I was hoping there was just one thing I missed with this database, but as I
say, I've checked the obvious (data recovery model, backup file names).
Do you advocate setting up a manual backup plan rather than using
Microsoft's Maintenance Plan wizard? The attraction of the wizard was that
it timestamped the files, and was basically quick to set up (there are 13
databases so far). I attended a 1-week DBA course and this seemed to be the
approved procedure. It's worked fine up to this point.
Cheers
Iain
"mountain man" <hobbit@souther n_seaweed.com.o p> wrote in message
news:iG******** *********@news-server.bigpond. net.au... "Iain Hosking" <ii************ *********@thesp amfreeweather.c om.au> wrote
in message news:40******** *************** @titanium.syd.n tt.net.au... I am running a SQL Server 2000 installation with several databases. Each database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run, but displays no error. There is no entry in the job history. The same thing happens when I try to run the individual jobs from Enterprise Manager.
I've checked the database recovery model (full), the location of the backup files (same as the other databases), and just about everything else I
can think of. The scheduled maintenance plan for every other database runs
as it should.
What am I missing?
Is SQL Agent service running? This service is required to be running for the above automation.
Additionally, I would disassociate the backups and the maintenance plans by creating each as separate tasks, the former being far more critical than the latter.
Pete Brown Winluck P/L Falls Creek Australia
Iain Hosking (ii************ *********@thesp amfreeweather.c om.au) writes: I am running a SQL Server 2000 installation with several databases. Each database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run, but displays no error. There is no entry in the job history. The same thing happens when I try to run the individual jobs from Enterprise Manager.
I've checked the database recovery model (full), the location of the backup files (same as the other databases), and just about everything else I can think of. The scheduled maintenance plan for every other database runs as it should.
Well, these may be really stupid suggestions, but check that the job
is enabled, and that the schedule is enabled.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Iain Hosking" <ii************ *********@thesp amfreeweather.c om.au> wrote in
message news:40******** *************** @titanium.syd.n tt.net.au...
....[trim]... Do you advocate setting up a manual backup plan rather than using Microsoft's Maintenance Plan wizard?
Generally yes, for a number of reasons:
1) Although the maintenance tasks can be very important
the backup is super-critical and should have IMO a dedicated
separate task in the production task queue.
2) Generally the schedules for maintenance and backups
are different cycles and thus they need to separately scheduled.
OTOH the maintenance wizard is fine for most production
sites in their early phases of operations ---- prior to any
full automation. (ie: large task queue)
Good luck,
Pete Brown
Falls Creek
Australia
"mountain man" <hobbit@souther n_seaweed.com.o p> wrote in message news:iG******** *********@news-server.bigpond. net.au... "Iain Hosking" <ii************ *********@thesp amfreeweather.c om.au> wrote in message news:40******** *************** @titanium.syd.n tt.net.au... I am running a SQL Server 2000 installation with several databases.
Each database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run, but displays no error. There is no entry in the job history. The same
thing happens when I try to run the individual jobs from Enterprise Manager.
I've checked the database recovery model (full), the location of the backup files (same as the other databases), and just about everything else I can think of. The scheduled maintenance plan for every other database
runs as it should.
What am I missing?
Is SQL Agent service running? This service is required to be running for the above automation.
Additionally, I would disassociate the backups and the maintenance plans by creating each as separate tasks, the former being far more critical than the latter.
Pete Brown Winluck P/L Falls Creek Australia
What user is SQL Server running under?
What user is SQL Agent running under?
Who is the owner of the database?
Are all of the above the same?
If not, check the other databases for this information and change this
one to match.
If so, does the user have permissions at the location of the backup
files?
On Tue, 3 Feb 2004 00:42:59 +1100, "Iain Hosking"
<ii************ *********@thesp amfreeweather.c om.au> wrote: I am running a SQL Server 2000 installation with several databases. Each database and log is backed-up using a maintenance plan.
The scheduled maintance plan for the latest database does not run, but displays no error. There is no entry in the job history. The same thing happens when I try to run the individual jobs from Enterprise Manager.
I've checked the database recovery model (full), the location of the backup files (same as the other databases), and just about everything else I can think of. The scheduled maintenance plan for every other database runs as it should.
What am I missing?
Thanks
Iain
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: TiredOfSpam |
last post by:
I have an ActiveX Script task in a DTS package which executes fine
within DTS.
However, if I run it as a sheduled job, it fails with a 'path not
found error'. I've cut the code down to the approriate problem and
posted it here, it just makes a simple text file with a name derived
from the current date and time and puts 'Hello World' in the file
although in reality I go on to make an xml file. (make sure your path
exists before you execute...
|
by: Dave |
last post by:
I need to create an executible that will run on a nightly basis.
The executible is a simple command line statement like:
OSQL -Usa -PmyPasword -n -Q "BACKUP DATABASE msdb TO DISK =
'c:\msdb.dat_bak'"
Is it possible to use C# to create an executible that will run this command
line statement on a scheduled basis?
|
by: Najm |
last post by:
Hi All,
I am facing this issue very frist time. I add a logical device as
following:
USE master
GO
EXEC sp_addumpdevice 'disk', 'AdvWorksData',
|
by: teddysnips |
last post by:
My client has a number of jobs that are run overnight. We've set them
up to email me when they're completed. Every morning I get in to a
bunch of emails like this:
<quote>
JOB RUN: 'Tech Pubs Email Notification' was run on 18/03/2006 at
00:00:00
DURATION: 0 hours, 0 minutes, 0 seconds
STATUS: Succeeded
|
by: Andrew Poulos |
last post by:
The stuff I've built recently works (in the sense that it does what I'm
expecting it to do without any errors or warnings) in IE and FF but
fails silently in Safari. I don't have a Mac to test on. I write some
stuff and send it to the client who tests and reports back.
I don't do any browser sniffing, I test for a feature for I try to use it...
Are there any known oddities about scripting for Safari that might
possibly help me out.
| |
by: Massimiliano Campagnoli |
last post by:
I am trying to backup sample database to network drive J:\ which maps
to a SAMBA share.
The first time the backup is successfull but the the next time fails.
I've to delete J:\sample.0 if I want to backup again.
Here is the log:
NET USE J: \\LINUXSERVER\BACKUPDB2
The command completed successfully.
|
by: Myster Edd |
last post by:
I have a strange problem that I think deals with security on SQL 2005.
I have a scheduled task that runs on a Windows 2000 machine. It calls
a vb script which creates a connection to SQL Server.
We migrated a database from SQL 2000 to 2005 which is on a different
box. I changed the connection in the vb script to use the new sql
server. The original connection to SQL 2000 used the 'sa' account
coded into the connection string , which...
|
by: Magnus.Moraberg |
last post by:
Hi,
I'm working on a Windows 2000 machine which hosts a SQL 2005 Express
Database.
This database is backed up using the following method -
http://www.sqldbatips.com/showarticle.asp?ID=27
As part of this method, I have a Task which is scheduled to run once a
|
by: ranjitw |
last post by:
I am running backup to .mdb file on a Windows 2003 server .
My issue is that when the program completed it still is in a "running" state when I highlight the icon for the scheduled task I have to manually stop the task in order for the next scheduled backup to run.
Is there a command line switch that I can use to force quit the program after it is completed or even if the job does not complete.
Thanks for your help in advance
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |