473,406 Members | 2,619 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Scheduling a script

I wish to run this script daily. Can this be scheduled?
backup log shipmateDB with truncate_only
G
Jul 27 '05 #1
4 1458
Hi

Look at SQL Server Agent in BOL. It can schedule jobs and run code.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Myth of Sisyphus)." <te********@hotmail.com> wrote in message
news:iq*******************@news20.bellglobal.com.. .
I wish to run this script daily. Can this be scheduled?
backup log shipmateDB with truncate_only
G

Jul 27 '05 #2

"Mike Epprecht (SQL MVP)" <mi**@epprecht.net> wrote in message
news:42**********@news.bluewin.ch...
Hi

Look at SQL Server Agent in BOL. It can schedule jobs and run code.

Can I add though that this script is probably not a good idea.

Either run the database in simple mode or perform actual log backups.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Myth of Sisyphus)." <te********@hotmail.com> wrote in message
news:iq*******************@news20.bellglobal.com.. .
I wish to run this script daily. Can this be scheduled?
backup log shipmateDB with truncate_only
G


Jul 27 '05 #3
Hi Greg,

I do have a log file backup scheduled along with my regular backup.
However, I do get sporatic log file full messages. I then have to run the
script through the query analyzer that appears to solve the problem untill
the next time.

regards

gilbert
"Greg D. Moore (Strider)" <mo****************@greenms.com> wrote in message
news:J5*****************@newsread2.news.atl.earthl ink.net...

"Mike Epprecht (SQL MVP)" <mi**@epprecht.net> wrote in message
news:42**********@news.bluewin.ch...
Hi

Look at SQL Server Agent in BOL. It can schedule jobs and run code.


Can I add though that this script is probably not a good idea.

Either run the database in simple mode or perform actual log backups.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Myth of Sisyphus)." <te********@hotmail.com> wrote in message
news:iq*******************@news20.bellglobal.com.. .
I wish to run this script daily. Can this be scheduled?
backup log shipmateDB with truncate_only
G



Jul 28 '05 #4

"Myth of Sisyphus)." <te********@hotmail.com> wrote in message
news:5y*******************@news20.bellglobal.com.. .
Hi Greg,

I do have a log file backup scheduled along with my regular backup.
However, I do get sporatic log file full messages. I then have to run the
script through the query analyzer that appears to solve the problem untill the next time.
But then you've completely invalidated your log backup chain.

I think you need to revisit your disaster recovery scenario since once
you've done the truncate, you can no longer recover anything past the last
transaction back up or full backup.

You're either better of doing transaction log backups more often to avoid
filling up your log, making your log larger, or finding out what's filling
them up.


regards

gilbert
"Greg D. Moore (Strider)" <mo****************@greenms.com> wrote in message news:J5*****************@newsread2.news.atl.earthl ink.net...

"Mike Epprecht (SQL MVP)" <mi**@epprecht.net> wrote in message
news:42**********@news.bluewin.ch...
Hi

Look at SQL Server Agent in BOL. It can schedule jobs and run code.


Can I add though that this script is probably not a good idea.

Either run the database in simple mode or perform actual log backups.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Myth of Sisyphus)." <te********@hotmail.com> wrote in message
news:iq*******************@news20.bellglobal.com.. .
>I wish to run this script daily. Can this be scheduled?
>
>
> backup log shipmateDB with truncate_only
>
>
> G
>
>



Jul 28 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ward Germonpé | last post by:
Hi, Is it possible to schedule a php script so that it runs every 5 minutes ? I'm using W2K. thx Ward
6
by: Tony Proctor | last post by:
Hi everyone We're experiencing some serious anomalies with the scheduling of ASP threads. I'd be interested to hear if anyone knows what algorithm is used (e.g. simple round-robin, or something...
0
by: steve | last post by:
I've seen questions about scheduling ASP scripts posted in this group many times so hopefully this will be useful information to a few people. I just wanted to let you all know that our script...
13
by: Mike | last post by:
Normally scheduling a job is a very elementary operation but for some hidden reason I've been unable to schedule a job which runs on a 28 day cycle, even though I have at least 16 other jobs...
3
by: Alphonse Giambrone | last post by:
Can anyone point me toward a good example of an asp.net scheduling app? Preferrably in vb.net. TIA -- Alphonse Giambrone Email: a-giam at customdatasolutions dot us
1
by: Majed | last post by:
hi I'm planing to make scheduling app and need your advice on the best way to do that,and how to save the tasks to be executed and retrive their data at the right time. your input will be highly...
1
by: Ike | last post by:
Well, before I try to tackle this, just thought I would ask around if anyone is aware of something that might not do the following: I have 5 guys to schedule a lunch, each month, for them to...
4
by: Dinsdale | last post by:
I'm looking at adding scheduling features to an application and I wanted to ask the community about any experience with scheduling components, either open source like from code project or from a...
0
by: fatimahaque | last post by:
While scheduling a shell script from a scheduler the following error is generated: No such file or directory. The full path of the shell script is given in the job action field yet the error. I am...
2
Ritchie
by: Ritchie | last post by:
Please can anyone help me with d programs in C for CPU scheduling: WAP to show FCFS scheduling algorithm. WAP to show SJF scheduling algorithm. WAP to show Priority scheduling algorithm. WAP...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
Oralloy
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,...
0
jinu1996
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.