473,788 Members | 2,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1485
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.n et

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

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

"Myth of Sisyphus)." <te********@hot mail.com> wrote in message
news:iq******** ***********@new s20.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.n et

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

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

"Myth of Sisyphus)." <te********@hot mail.com> wrote in message
news:iq******** ***********@new s20.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.co m> wrote in message
news:J5******** *********@newsr ead2.news.atl.e arthlink.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.n et

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

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

"Myth of Sisyphus)." <te********@hot mail.com> wrote in message
news:iq******** ***********@new s20.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********@hot mail.com> wrote in message
news:5y******** ***********@new s20.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.co m> wrote in message news:J5******** *********@newsr ead2.news.atl.e arthlink.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.n et

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

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

"Myth of Sisyphus)." <te********@hot mail.com> wrote in message
news:iq******** ***********@new s20.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
2822
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
2328
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 more sophisticated), and what situations might perturb it. Even a hint as to what would be considered normal scheduling might help. The root of our problem is that we observed a normally well-behaved web application suddenly limit itself to a...
0
2563
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 scheduling service at www.cronservice.co.uk has been rewritten from the ground up and is now better than ever. If you are looking for a way to schedule your ASP scripts and don't have access to cron or task scheduler then you need this service.
13
6061
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 seperately scheduled to run on a 28 day cycle with different start dates/times. My production SQL server is running SQL Server Enterprise Edition 8.00.760(SP3) on a 2 Processor(4 virtual) Microsoft
3
578
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
1807
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 appreciated Majed
1
1556
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 attend on a Friday. So, I need to have a web interface where each, say, can designate what Fridays they are not availabel in a given month, and waht particular friday would be their preference. Then, I attempt to schedule the one friday that they...
4
2848
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 vendor. I'd like to be able to create schedules and lock resources for things like collision detection (two events trying to use the same resource). I've seen some GANTT charting components but I don't think that's what I'm looking for. I'd...
0
1533
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 using Oracle 10g and OS is Windows XP.
2
26818
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 to show Round-Robin scheduling algorithm. disk scheduling:
0
9498
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,...
0
10373
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, 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...
0
10177
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 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...
0
9969
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6750
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5403
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...
0
5538
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3677
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2897
bsmnconsultancy
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...

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.