Scheduled Task

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I backup every night. I have two batch files one to
stop the service at the end of the day prior to the backup strating and
another one to strat the service once the backup finishes. If I keep the
server logged off with the scheduled task still run.
 
Aloha George,

I'm not clear what your question is. Are you asking if the server that hosts
the database is logged off will the scheduled tasks still run? I would guess
not, but I'd need more information about what kind of server it is, what
kind of database it is and how you've set up your scheduled tasks.

Depending upon the type of database I would generally recommend a backup
solution that doesn't require the database to be shut down during backups.
There can be all kinds of log file issues and other such that you may have
to address if you're doing off-line backups.

-Ben-
Ben M. Schorr - MVP
http://www.rolandschorr.com
Microsoft OneNote FAQ: http://www.factplace.com/onenote.html
 
Hi,

Normaly, when the scheduled task is configured well, I think it will work
if the server is just logged off (not shutdown). However, I think database
has its own backup plans. I'm not sure why you do it manually. Let us know
your concerns in detail that we can provide the correct information.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
 
Basically the according to the vendor in order to back up their databse we
have to shutdown the service that is running. I normall have two batch files
to accomplish this task that run through a scheduled task and just want to
verify that the a scheduled task will run when the server is logged off.
 
I don't know what he's running but our version of Sybase SQLAnywhere
recommends exactly this process for backup - schedule a batch file to shut
down the service, copy the database files to a different location, then
start up the service again and back up the copies instead of the database
files. I can back up just about any other database file in-use with the
appropriate backup engine but these won't.

--
Richard G. Harper [MVP Shell/User] (e-mail address removed)
* PLEASE post all messages and replies in the newsgroups
* for the benefit of all. Private mail is usually not replied to.
* My website, such as it is ... http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm
 
Hi George,

I understand your requirment.

I think you can configure the scheduled task run under system account:

User name:NT Authority\System

Password is blank.

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
 
I'm using a net start "service name" and net stop "service name" in two batch
files. However when I log back onto the server the program isn't minimized.
is there a way to start the service/program minimized.
 
Hi George,

I'm not sure what do you mean of "minimized". Do you mean, you want to run
the batch file in background?


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
 
What I mean the Databse runs as a service and I want to minimize the program
when the service restarts.
 
Hi George,

I'm sorry but my understanding is you want to minimize the database program
automaticaly when it starts. If so, I'm afraid there are no such method to
achieve your purpose unless the program has a switch which we can call it
in Batch file that minimize the Window.

Thanks.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
 
Back
Top