Home > Archive > MS SQL Server > May 2005 > Which back up is best and why ?









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]

 

Author Which back up is best and why ?
H

2005-05-23, 3:23 am

If you have a veritas back up agent running on your SQL Server box, is there
any point in scheduling the back up of individual databases ?

I understand the benefits of backing up the server.
Aleksandar Grbic

2005-05-23, 3:23 am

use sql agent and backup database command to "scheduling the back up of
individual databases"

"H" wrote:

> If you have a veritas back up agent running on your SQL Server box, is there
> any point in scheduling the back up of individual databases ?
>
> I understand the benefits of backing up the server.

H

2005-05-23, 7:23 am

Why back up database as well as the SQL agent, surely the SQL Agent is enough ?

H

"Aleksandar Grbic" wrote:
[color=darkred]
> use sql agent and backup database command to "scheduling the back up of
> individual databases"
>
> "H" wrote:
>
Aleksandar Grbic

2005-05-23, 9:23 am

you can backup individual databases with tsql
use sql agent to schedule backup
later, you can use veritas (etc.) to backup bak files...

"H" wrote:
[color=darkred]
> Why back up database as well as the SQL agent, surely the SQL Agent is enough ?
>
> H
>
> "Aleksandar Grbic" wrote:
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com