Scheduling Subscription On Day 30 of a Month

I tried to setup a monthly subscription, to be run on Day 30 of a month.
After clicking the radio button for "Month", then click the radio button for
"On Calendar Days", then enter the day 30, and press OK. The subscription
will return the following error message:To create a schedule that runs on
multiple days, you must choose which days to use.
This message will not appear, if I enter any other day, up to and including
day 29.I have to deselect Month of Februrary, which does not have 30 days
"LBJOHN" wrote:
> I tried to setup a monthly subscription, to be run on Day 30 of a month.
> After clicking the radio button for "Month", then click the radio button for
> "On Calendar Days", then enter the day 30, and press OK. The subscription
> will return the following error message:To create a schedule that runs on
> multiple days, you must choose which days to use.
> This message will not appear, if I enter any other day, up to and including
> day 29.
>

Scheduling a DTS package

I am using Enterprise manager with an MSDE engine. I have created a DTS package that updates a table in one of the databases. If I right click and choose "Execute Package" it runs...No sweat. When I try to use the scheduler to run the job every hour, it always fails between 1 and 10 seconds into the job...It only returns the error "Failed During Step 1."

I'm wondering if this feature won't work with MSDE? Does anyone have any ideas?Under Management>Jobs, right click on the job in question, and select "Job History". There should be a checkbox that says "Show step details". Clicking that will expand the information. Check to see if there's more information in there.|||Probably a security issue. Wen you run the package interactively it uses the logged in user, when running from the job queue it uses the configured user account of the DTS Package.

Open your package, click Package->Properties->Logging|||Thanks for tips, the error is:

Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Error opening datafile: The system cannot find the path specified.

Step Error code: 80004005
Step Error Help File:DTSFFile.hlp
Step Error Help Context ID:0

I checked the path and it's correct, and it finds the file when I run it manually.|||Check the server to see if the file exists in the exact same filepath as on your machine. I believe that when you run a DTS package interactively, it resolves file names locally, but when executed from the server via SQLAgent it will resolve the filepaths from the server.|||i concurr
i suck at typing in filepaths so i always set the windows explorer to display the full path in the title bar and i just copy it from there.

Scheduled Database Backup for MS SQL Server 2000

I've been trying to make our server to schedully create a backup for our database. The problem is when I'm done with the scheduling and click 'OK', I again open "database">>all task>> back up, all the properties which I entered are all gone.You need to look under the management, sql server agent node and then look at jobs.

Schedule package menu grayed out in EM

I tried to schedule a local package under Enterprise Manager\DTS\Local
package by right click local packages. However the Schedule package menu
grayed out. I used the domain login, which is SQL Server system
administrator role. This account is also in the administrators group of SQL
Server machine, and has log in as service and batch privilege. Moreover SQL
agent service is under this account.
Since SQL Server machine box itself does not install Enterprise Manager, I
add SQL Server registration from client machine, which login with above
domain account. Looks like I have all the privileges. I cannot figure out
why Schedule package menu is still grayed out. Please help. Thanks,
Charts
Hi Charts,
Thanks for your post.
From your descriptiosn, I understood Schedule Package menu is grayed out in
your SEM. If I have misunderstood your concern, please feel free to point
it out.
Based on my knowledge, please make sure SQL Agent is correctly started.
Would you please paste the SQL Server logs here? I understand the
information may be sensitive to you, my direct email address is
v-mingqc@.online.microsoft.com (make sure to remove 'online.' before you
click SEND as it's only for SPAM), you may send the file to me directly and
I will keep secure.
If you register this SQL Server in another machine, does "Schedule
Package..." menu also disabled?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Mike,
I made sure SQL agent started and running. There are so many logs in event
viewer for SQLAgent$InstanceName, most of them are not relevant. SQL Server
machine itself does not have SEM, so I used other machines to register for
SQL Server. I have two other questions. 1) Am I able to install SEM in the
server machine without affecting the SQL Server activities? 2) How do I use
dtsrun utility to schedule a package? Can you give me an example for syntax
using pseudo SQL name? Thanks a lot for your help.
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your post.
> From your descriptiosn, I understood Schedule Package menu is grayed out in
> your SEM. If I have misunderstood your concern, please feel free to point
> it out.
> Based on my knowledge, please make sure SQL Agent is correctly started.
> Would you please paste the SQL Server logs here? I understand the
> information may be sensitive to you, my direct email address is
> v-mingqc@.online.microsoft.com (make sure to remove 'online.' before you
> click SEND as it's only for SPAM), you may send the file to me directly and
> I will keep secure.
> If you register this SQL Server in another machine, does "Schedule
> Package..." menu also disabled?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
Thanks for your prompt update.
For your questions[vbcol=seagreen]
Yes, SQL Server Enterprise Manager is the component of SQL Server Client
Tools, registering SQL Server instance with SEM won't affect SQL Server
activities.
Please register the SQL Server in a new machine and see whether it will
reproduce this issue on that new machine.
[vbcol=seagreen]
an[vbcol=seagreen]
Here is a simple example: C:\> dtsrun /s <server name> /e /N <DTS package
name>
If you want to schedule it, create a job and let it execute the command in
a regular time.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Mike,
It’s very helpful. For question 1) it’s not the issue registering SQL
Server instance. I don’t have SQL enterprise manager installed in the server
machine, and I wanted to install this tool without affecting server. I guess
I need to put SQL Server 2000 installation CD in and start install process.
Can you give me some instruction for safe installation since this is existing
server?
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your prompt update.
> For your questions
> Yes, SQL Server Enterprise Manager is the component of SQL Server Client
> Tools, registering SQL Server instance with SEM won't affect SQL Server
> activities.
> Please register the SQL Server in a new machine and see whether it will
> reproduce this issue on that new machine.
> an
> Here is a simple example: C:\> dtsrun /s <server name> /e /N <DTS package
> name>
> If you want to schedule it, create a job and let it execute the command in
> a regular time.
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/tec...rview/40010469
> Others: https://partner.microsoft.com/US/tec...pportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
Thanks for your update.
Based on my knowledge, if you install SQL Server in the machine, SQL Server
Client Tools will also be installed, so I am not very sure your scenario.
Would you please help me explain it clearly? More detailed descriptions, I
believe, will make us closer to the resolution.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Never mind Mike,
I found EM component in the server component installation. Thanks for your
help.
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your update.
> Based on my knowledge, if you install SQL Server in the machine, SQL Server
> Client Tools will also be installed, so I am not very sure your scenario.
> Would you please help me explain it clearly? More detailed descriptions, I
> believe, will make us closer to the resolution.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
That's OK and let's go back to see why Schedule package menu grayed out.
If you register this SQL Server in another machine, does "Schedule
Package..." menu also disabled?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Schedule Backup issue using Enterprise Manager

I have set up EM to back up several databases on a machine running Win2k
Advanced Server and SQL Server 2000 SP2. On each db, I right click and
created a backup task and set a reoccurring scheduled time for daily back
ups. What's weird and someone frustrating is that the tasks ALWAYS append
existing data which makes the backups unnecessarily large and the scheduled
time never sticks. I'll go in a click Overwrite Existing Data and set the
back up time each day and it never says these changes. I've even tried to
remove the task(s) and create new ones from scratch and it won't let me
remove the old ones. Each day, it appends the existing data and the
scheduled time is never there (even though the auto backups do occur...not
sure why).
So...each and every day, I have to go and manually backup each db. Not a
huge deal but a bit frustrating since EM should do this for me. Any ideas?
Is this a known issue?
TIA!
-SIf you use Enterprise Manager and the Backup Database task
by right clicking on a database, this will create a job
named something like YourDatabase backup
The job will have a T-SQL step that will execute the T-SQL
backup statement that was generated when you scheduled the
task. If you need to make changes, you need to modify the
job rather than trying to go back in through the task part
of Enterprise Manager.
You can modify the schedule from the schedule tab of the
job.
If the job was initially created to append, the backup
command in the job step with include WITH NOINIT. You can
change this to WITH INIT if you want to overwrite the
backups. You can find more information on the BACKUP
DATABASE statement that is generated and it's options in
books online under backup.
-Sue
On Thu, 13 Jan 2005 09:41:29 -0500, "D. Shane Fowlkes"
<shanefowlkes@.h-o-t-m-a-i-l.com> wrote:
>I have set up EM to back up several databases on a machine running Win2k
>Advanced Server and SQL Server 2000 SP2. On each db, I right click and
>created a backup task and set a reoccurring scheduled time for daily back
>ups. What's weird and someone frustrating is that the tasks ALWAYS append
>existing data which makes the backups unnecessarily large and the scheduled
>time never sticks. I'll go in a click Overwrite Existing Data and set the
>back up time each day and it never says these changes. I've even tried to
>remove the task(s) and create new ones from scratch and it won't let me
>remove the old ones. Each day, it appends the existing data and the
>scheduled time is never there (even though the auto backups do occur...not
>sure why).
>So...each and every day, I have to go and manually backup each db. Not a
>huge deal but a bit frustrating since EM should do this for me. Any ideas?
>Is this a known issue?
>TIA!
>-S
>

Schedule Backup issue using Enterprise Manager

I have set up EM to back up several databases on a machine running Win2k
Advanced Server and SQL Server 2000 SP2. On each db, I right click and
created a backup task and set a reoccurring scheduled time for daily back
ups. What's weird and someone frustrating is that the tasks ALWAYS append
existing data which makes the backups unnecessarily large and the scheduled
time never sticks. I'll go in a click Overwrite Existing Data and set the
back up time each day and it never says these changes. I've even tried to
remove the task(s) and create new ones from scratch and it won't let me
remove the old ones. Each day, it appends the existing data and the
scheduled time is never there (even though the auto backups do occur...not
sure why).
So...each and every day, I have to go and manually backup each db. Not a
huge deal but a bit frustrating since EM should do this for me. Any ideas?
Is this a known issue?
TIA!
-S
If you use Enterprise Manager and the Backup Database task
by right clicking on a database, this will create a job
named something like YourDatabase backup
The job will have a T-SQL step that will execute the T-SQL
backup statement that was generated when you scheduled the
task. If you need to make changes, you need to modify the
job rather than trying to go back in through the task part
of Enterprise Manager.
You can modify the schedule from the schedule tab of the
job.
If the job was initially created to append, the backup
command in the job step with include WITH NOINIT. You can
change this to WITH INIT if you want to overwrite the
backups. You can find more information on the BACKUP
DATABASE statement that is generated and it's options in
books online under backup.
-Sue
On Thu, 13 Jan 2005 09:41:29 -0500, "D. Shane Fowlkes"
<shanefowlkes@.h-o-t-m-a-i-l.com> wrote:

>I have set up EM to back up several databases on a machine running Win2k
>Advanced Server and SQL Server 2000 SP2. On each db, I right click and
>created a backup task and set a reoccurring scheduled time for daily back
>ups. What's weird and someone frustrating is that the tasks ALWAYS append
>existing data which makes the backups unnecessarily large and the scheduled
>time never sticks. I'll go in a click Overwrite Existing Data and set the
>back up time each day and it never says these changes. I've even tried to
>remove the task(s) and create new ones from scratch and it won't let me
>remove the old ones. Each day, it appends the existing data and the
>scheduled time is never there (even though the auto backups do occur...not
>sure why).
>So...each and every day, I have to go and manually backup each db. Not a
>huge deal but a bit frustrating since EM should do this for me. Any ideas?
>Is this a known issue?
>TIA!
>-S
>

Schedule Backup issue using Enterprise Manager

I have set up EM to back up several databases on a machine running Win2k
Advanced Server and SQL Server 2000 SP2. On each db, I right click and
created a backup task and set a reoccurring scheduled time for daily back
ups. What's weird and someone frustrating is that the tasks ALWAYS append
existing data which makes the backups unnecessarily large and the scheduled
time never sticks. I'll go in a click Overwrite Existing Data and set the
back up time each day and it never says these changes. I've even tried to
remove the task(s) and create new ones from scratch and it won't let me
remove the old ones. Each day, it appends the existing data and the
scheduled time is never there (even though the auto backups do occur...not
sure why).
So...each and every day, I have to go and manually backup each db. Not a
huge deal but a bit frustrating since EM should do this for me. Any ideas?
Is this a known issue?
TIA!
-SIf you use Enterprise Manager and the Backup Database task
by right clicking on a database, this will create a job
named something like YourDatabase backup
The job will have a T-SQL step that will execute the T-SQL
backup statement that was generated when you scheduled the
task. If you need to make changes, you need to modify the
job rather than trying to go back in through the task part
of Enterprise Manager.
You can modify the schedule from the schedule tab of the
job.
If the job was initially created to append, the backup
command in the job step with include WITH NOINIT. You can
change this to WITH INIT if you want to overwrite the
backups. You can find more information on the BACKUP
DATABASE statement that is generated and it's options in
books online under backup.
-Sue
On Thu, 13 Jan 2005 09:41:29 -0500, "D. Shane Fowlkes"
<shanefowlkes@.h-o-t-m-a-i-l.com> wrote:

>I have set up EM to back up several databases on a machine running Win2k
>Advanced Server and SQL Server 2000 SP2. On each db, I right click and
>created a backup task and set a reoccurring scheduled time for daily back
>ups. What's weird and someone frustrating is that the tasks ALWAYS append
>existing data which makes the backups unnecessarily large and the scheduled
>time never sticks. I'll go in a click Overwrite Existing Data and set the
>back up time each day and it never says these changes. I've even tried to
>remove the task(s) and create new ones from scratch and it won't let me
>remove the old ones. Each day, it appends the existing data and the
>scheduled time is never there (even though the auto backups do occur...not
>sure why).
>So...each and every day, I have to go and manually backup each db. Not a
>huge deal but a bit frustrating since EM should do this for me. Any ideas?
>Is this a known issue?
>TIA!
>-S
>

Schedule a Stored Procedure to run overnight

What I want to do is to create a Web Interface to allow a User to click a
link and execute a Stored Procedure, I think this would be straight forward.
What I also want to do is to allow the user to select a check box to have
that stored procedure run over night or even schedule the Stored procedures
to run at differnet times.
through E-SQL I would just set up an Agent to do the job, the User won't
have that privelage they will have to go through a web page.
I am not even sure what approach to take? Is there a way to setup an agent
to run via stored procedures so through my code I can just call a system
stored procedure that will create the agent and schedule the job?
Thanks
SteveCreate a queue Table to hold the requests by users for Jobs to run, and a SQ
L
Agent Job to run every tem minutes, or whatever, to read the records out of
that table, and execute them if the current system datetime has passed the
datetime as stored in the queue table.. Then delete the queue table record
(or, - better, flag it as completed, when the job has run successfully.
"Steve K" wrote:

> What I want to do is to create a Web Interface to allow a User to click a
> link and execute a Stored Procedure, I think this would be straight forwar
d.
> What I also want to do is to allow the user to select a check box to have
> that stored procedure run over night or even schedule the Stored procedure
s
> to run at differnet times.
> through E-SQL I would just set up an Agent to do the job, the User won't
> have that privelage they will have to go through a web page.
> I am not even sure what approach to take? Is there a way to setup an agent
> to run via stored procedures so through my code I can just call a system
> stored procedure that will create the agent and schedule the job?
> Thanks
> Steve|||See sp_add_job, sp_add_jobstep, sp_add_jobschedule, etc. in BOL.
AMB
"Steve K" wrote:

> What I want to do is to create a Web Interface to allow a User to click a
> link and execute a Stored Procedure, I think this would be straight forwar
d.
> What I also want to do is to allow the user to select a check box to have
> that stored procedure run over night or even schedule the Stored procedure
s
> to run at differnet times.
> through E-SQL I would just set up an Agent to do the job, the User won't
> have that privelage they will have to go through a web page.
> I am not even sure what approach to take? Is there a way to setup an agent
> to run via stored procedures so through my code I can just call a system
> stored procedure that will create the agent and schedule the job?
> Thanks
> Steve|||a Queue table is not a bad idea, but I would have to write the name of a
Stored Procedure in a field and then have the agent read that name and
execute the named procedure - I am not sure how to do that but I like the
thought I will look into it.
"CBretana" wrote:
> Create a queue Table to hold the requests by users for Jobs to run, and a
SQL
> Agent Job to run every tem minutes, or whatever, to read the records out o
f
> that table, and execute them if the current system datetime has passed the
> datetime as stored in the queue table.. Then delete the queue table record
> (or, - better, flag it as completed, when the job has run successfully.
> "Steve K" wrote:
>|||Thanks I will look up these sp's and see how to use them
"Alejandro Mesa" wrote:
> See sp_add_job, sp_add_jobstep, sp_add_jobschedule, etc. in BOL.
>
> AMB
> "Steve K" wrote:
>|||Steve,
After some research, Alej's idea is much simpler. (use sp_add_job)
I discovered you can even add the job with a flag set (@.delete_level =
3) that will cause the job to execute once and then delete iteself, which wa
s
the main reason I would have rolled-my-own system to do what you are trying
to do...
"Steve K" wrote:

> What I want to do is to create a Web Interface to allow a User to click a
> link and execute a Stored Procedure, I think this would be straight forwar
d.
> What I also want to do is to allow the user to select a check box to have
> that stored procedure run over night or even schedule the Stored procedure
s
> to run at differnet times.
> through E-SQL I would just set up an Agent to do the job, the User won't
> have that privelage they will have to go through a web page.
> I am not even sure what approach to take? Is there a way to setup an agent
> to run via stored procedures so through my code I can just call a system
> stored procedure that will create the agent and schedule the job?
> Thanks
> Steve|||I think there is a disconnect here. The solution that Charly is recommending
involves writing a record into a queue table and then having a scheduled job
execute the stored proc using the queue value to determine the data on which
to
act. The job would have the stored proc that should be executed hard coded i
nto
its list of steps.
You aren't asking to execute any stored proc in the system like right?
Thomas
"Steve K" <SteveK@.discussions.microsoft.com> wrote in message
news:0C18A082-88DF-4924-B65B-B4AB13EAEF55@.microsoft.com...
>a Queue table is not a bad idea, but I would have to write the name of a
> Stored Procedure in a field and then have the agent read that name and
> execute the named procedure - I am not sure how to do that but I like the
> thought I will look into it.
> "CBretana" wrote:
>|||sounds good that's the direction I am going to run.
Thanks
Steve
"CBretana" wrote:
> Steve,
> After some research, Alej's idea is much simpler. (use sp_add_job)
> I discovered you can even add the job with a flag set (@.delete_level =
> 3) that will cause the job to execute once and then delete iteself, which
was
> the main reason I would have rolled-my-own system to do what you are tryin
g
> to do...
> "Steve K" wrote:
>|||No, I would have a seperate table that contains a list of avalable stored
procedured users can run on demand from this table I would probably just
throw a grid on the screen with an execute link and allow the user to select
execute, the difficult part here is if the user wants to schedule that job t
o
run overnight then I would need some way to know which Sp they selected and
what time to run it.
does that make sense?
"Thomas Coleman" wrote:

> I think there is a disconnect here. The solution that Charly is recommendi
ng
> involves writing a record into a queue table and then having a scheduled j
ob
> execute the stored proc using the queue value to determine the data on whi
ch to
> act. The job would have the stored proc that should be executed hard coded
into
> its list of steps.
> You aren't asking to execute any stored proc in the system like right?
>
> Thomas
>
> "Steve K" <SteveK@.discussions.microsoft.com> wrote in message
> news:0C18A082-88DF-4924-B65B-B4AB13EAEF55@.microsoft.com...
>
>|||Do I understand what you are planning on doing? Yes, I think so. Do I unders
tand
why you are doing it? No, but that may not be important ;->
I'm generally inclined to abstract that functionality provided to users away
from the means by which it is implemented. Thus, I wouldn't have users selec
ting
stored procedures per se and it may be the case that you are not either. Sin
ce
I'm presuming that the set of functionality provided to the user is finite,
I'd
be inclined to either make multiple queues and multiple jobs for each stored
proc or perhaps a single queue and multiple jobs for each stored proc. Users
would be presented with a list of actions to perform such that behind the sc
enes
would be a mapping of actions to stored procedures. If the user asked for a
scheduled action, the system would map that request to a post into the
appropriate queue table. That queue table would store the time and day that
the
stored procedure should be executed and the scheduled job would be set to po
ll
continuously (say every minute or every five minutes) to determine if there
is
work to do.
However, since I don't know the specifics of the problem you are attempting
to
solve, I may be completely off the mark.
Thomas
"Steve K" <SteveK@.discussions.microsoft.com> wrote in message
news:B4674B29-52CA-4320-9408-6C47600FEBB7@.microsoft.com...
> No, I would have a seperate table that contains a list of avalable stored
> procedured users can run on demand from this table I would probably just
> throw a grid on the screen with an execute link and allow the user to sele
ct
> execute, the difficult part here is if the user wants to schedule that job
to
> run overnight then I would need some way to know which Sp they selected an
d
> what time to run it.
> does that make sense?
> "Thomas Coleman" wrote:
>

schedule a backup?

I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
"To schedule a backup, click schedule".
I don't see a "schedule" button anywhere.
I created a schedule under the agent (I didn't create a job, just a
schedule) but I still don't see an option to schedule the backup.
Any ideas?
ThxHello,
For database backup use maintenance plan from SQL Server management studio.
Connect to SQL Server from management studio, expand and choose the
management option,
Maintenance plans.. right click and choose maintenance plan Wizard. This
will help you to do the step by step process to define a backup procedure
and schedule it.
Thanks
Hari
"Tmack" <Terry.McKenna@.gmail.com> wrote in message
news:1173916162.338108.140150@.n59g2000hsh.googlegroups.com...
> I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
> "To schedule a backup, click schedule".
> I don't see a "schedule" button anywhere.
> I created a schedule under the agent (I didn't create a job, just a
> schedule) but I still don't see an option to schedule the backup.
> Any ideas?
> Thx
>|||On Mar 14, 10:09 pm, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> For database backup use maintenance plan from SQL Server management studio.
> Connect to SQL Server from management studio, expand and choose the
> management option,
> Maintenance plans.. right click and choose maintenance plan Wizard. This
> will help you to do the step by step process to define a backup procedure
> and schedule it.
> Thanks
> Hari
> "Tmack" <Terry.McKe...@.gmail.com> wrote in message
> news:1173916162.338108.140150@.n59g2000hsh.googlegroups.com...
>
> > I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
> > "To schedule a backup, click schedule".
> > I don't see a "schedule" button anywhere.
> > I created a schedule under the agent (I didn't create a job, just a
> > schedule) but I still don't see an option to schedule the backup.
> > Any ideas?
> > Thx- Hide quoted text -
> - Show quoted text -
Thanks, this is what I needed.

schedule a backup?

I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
"To schedule a backup, click schedule".
I don't see a "schedule" button anywhere.
I created a schedule under the agent (I didn't create a job, just a
schedule) but I still don't see an option to schedule the backup.
Any ideas?
Thx
Hello,
For database backup use maintenance plan from SQL Server management studio.
Connect to SQL Server from management studio, expand and choose the
management option,
Maintenance plans.. right click and choose maintenance plan Wizard. This
will help you to do the step by step process to define a backup procedure
and schedule it.
Thanks
Hari
"Tmack" <Terry.McKenna@.gmail.com> wrote in message
news:1173916162.338108.140150@.n59g2000hsh.googlegr oups.com...
> I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
> "To schedule a backup, click schedule".
> I don't see a "schedule" button anywhere.
> I created a schedule under the agent (I didn't create a job, just a
> schedule) but I still don't see an option to schedule the backup.
> Any ideas?
> Thx
>
|||On Mar 14, 10:09 pm, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> For database backup use maintenance plan from SQL Server management studio.
> Connect to SQL Server from management studio, expand and choose the
> management option,
> Maintenance plans.. right click and choose maintenance plan Wizard. This
> will help you to do the step by step process to define a backup procedure
> and schedule it.
> Thanks
> Hari
> "Tmack" <Terry.McKe...@.gmail.com> wrote in message
> news:1173916162.338108.140150@.n59g2000hsh.googlegr oups.com...
>
>
>
>
> - Show quoted text -
Thanks, this is what I needed.

schedule a backup?

I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
"To schedule a backup, click schedule".
I don't see a "schedule" button anywhere.
I created a schedule under the agent (I didn't create a job, just a
schedule) but I still don't see an option to schedule the backup.
Any ideas?
ThxHello,
For database backup use maintenance plan from SQL Server management studio.
Connect to SQL Server from management studio, expand and choose the
management option,
Maintenance plans.. right click and choose maintenance plan Wizard. This
will help you to do the step by step process to define a backup procedure
and schedule it.
Thanks
Hari
"Tmack" <Terry.McKenna@.gmail.com> wrote in message
news:1173916162.338108.140150@.n59g2000hsh.googlegroups.com...
> I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
> "To schedule a backup, click schedule".
> I don't see a "schedule" button anywhere.
> I created a schedule under the agent (I didn't create a job, just a
> schedule) but I still don't see an option to schedule the backup.
> Any ideas?
> Thx
>|||On Mar 14, 10:09 pm, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> For database backup use maintenance plan from SQL Server management studio
.
> Connect to SQL Server from management studio, expand and choose the
> management option,
> Maintenance plans.. right click and choose maintenance plan Wizard. This
> will help you to do the step by step process to define a backup procedure
> and schedule it.
> Thanks
> Hari
> "Tmack" <Terry.McKe...@.gmail.com> wrote in message
> news:1173916162.338108.140150@.n59g2000hsh.googlegroups.com...
>
>
>
>
>
>
> - Show quoted text -
Thanks, this is what I needed.