|
Home > Archive > MS SQL Server > March 2006 > Automatic Backups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi:
Somebody knows how I can program a stored procedure for automatic backup to
disk in SQL Server 2005 checking the transaction log?
Thanks in advance
Ale :)
| |
|
| In SQL Server Management Studio, Go to Management, Maintenance Plans, right
click the node and select New. Choose the "Back Up Database Task" option from
the toolbox. Configure the backup wizard as needed.
--
AndyP,
Sr. Database Administrator,
MCDBA 2003
"Ale" wrote:
> Hi:
> Somebody knows how I can program a stored procedure for automatic backup to
> disk in SQL Server 2005 checking the transaction log?
> Thanks in advance
> Ale :)
| |
|
| ok, I checked this but I have one doubt: how can I check my log? if I want
that my backup init when my log is at 80 %, how can I send an automatic form
the backup process to work? it exists a manner for programming this in SQL
Server 2005? (like a cron in UNIX)
Thanks again
Ale
"AndyP" wrote:
[color=darkred]
> In SQL Server Management Studio, Go to Management, Maintenance Plans, right
> click the node and select New. Choose the "Back Up Database Task" option from
> the toolbox. Configure the backup wizard as needed.
>
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
>
> "Ale" wrote:
>
| |
| Tibor Karaszi 2006-03-23, 7:26 am |
| You can create an Agent Performance Condition Alert that triggers on log full percent and trigger
your job that does a backup of the log. If prefer to just schedule my backups regularly, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Ale" <Ale@discussions.microsoft.com> wrote in message
news:02D8FBBD-0BB8-4514-B2D9- 051E39DA18B0@microso
ft.com...[color=darkred]
> ok, I checked this but I have one doubt: how can I check my log? if I want
> that my backup init when my log is at 80 %, how can I send an automatic form
> the backup process to work? it exists a manner for programming this in SQL
> Server 2005? (like a cron in UNIX)
> Thanks again
> Ale
>
> "AndyP" wrote:
>
| |
|
| Ok, I'll try it!
This Agent triggers when the condition is completed?
Thanks!
Ale :)
"Tibor Karaszi" wrote:
> You can create an Agent Performance Condition Alert that triggers on log full percent and trigger
> your job that does a backup of the log. If prefer to just schedule my backups regularly, though.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Ale" <Ale@discussions.microsoft.com> wrote in message
> news:02D8FBBD-0BB8-4514-B2D9- 051E39DA18B0@microso
ft.com...
>
>
>
| |
| Tibor Karaszi 2006-03-23, 8:24 pm |
| > This Agent triggers when the condition is completed?
When the condition is true, yes. For instance, you can for the counter "Percent log full" specify a
value "raises above" and 80. When that perf mon counter is > 80, the alert is fired.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Ale" <Ale@discussions.microsoft.com> wrote in message
news:E8BD8E4E-C95C-4A01-903F- C91848F8BD52@microso
ft.com...[color=darkred]
> Ok, I'll try it!
> This Agent triggers when the condition is completed?
> Thanks!
> Ale :)
>
> "Tibor Karaszi" wrote:
>
| |
|
|
|
|
|