Re: Backup

Yes...if you are using nothing but the open file agent, you
need to manage it all through ArcServe.
It's generally less problematic and much cheaper to skip the
open file agents, use SQL Server native backups, then backup
the SQL Server backup files to tape.

-Sue

On Thu, 22 Feb 2007 05:24:12 -0800, Flores
<Flores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I'm not sure what you mean to a disk. I want the data to be back up on a
tape like the rest of the data in my network: using arcserve v11 incremental
with grandfather-father-son rotation. Also, I'm not backing up the .bak
files, I'm backing up the .mdf and ldf right from the \Data directory under
Microsoft SQL. Would that make a difference?

"Uri Dimant" wrote:

Flores

BACKUP DATABASE dbname TO DISK =
N'\\ServerB\shared_folder\dbname.BAK'






"Flores" <Flores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D4AE076-5C65-49CC-9AE4-6DFE6861001D@xxxxxxxxxxxxxxxx
I have a windows 2003 server(let call it server a) running arcserve v11
with
backup agent for SQL. I have another server (server b) running SQL. I
can
not get the SQL databases from server b backup up on to the tape I have on
server a. All I see on server a is the basic SQL databases that get
installed when the agent is installed. Can someone tell me why? Thank




.

Relevant Pages

  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Scheduled Backup for SQL Database
    ... Look in the SQL Server log too, ... Need smaller SQL2K backup files? ... >>Need smaller SQL2K backup files? ...
    (microsoft.public.sqlserver.server)
  • SQL/ MS 2003 server backups/restores
    ... I'm a bit confused on the backup necessary for my SQL server running on MS ... system state, OS etc, and another for my SQL databases. ...
    (microsoft.public.sqlserver.server)
  • Re: VSS event 6013
    ... I am experiencing a similar issue where VSS tries to access my SQL ... Server every time I perform a system state backup. ...
    (microsoft.public.windows.server.sbs)