469,909 Members | 1,800 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,909 developers. It's quick & easy.

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 1331
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ward Germonpé | last post: by
6 posts views Thread by Tony Proctor | last post: by
reply views Thread by steve | last post: by
3 posts views Thread by Alphonse Giambrone | last post: by
1 post views Thread by Majed | last post: by
1 post views Thread by Ike | last post: by
4 posts views Thread by Dinsdale | last post: by
Ritchie
2 posts views Thread by Ritchie | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.