Re: Backup

Flores (Flores@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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?

You are doing what? Alright, you can backup the MDF and LDF files, *if*
you have stopped SQL Server. But normally, you have SQL Server running,
those backups are useless, as they will not be transactionally consistent.

You should schedule backups of your database from SQL Server Agent, and
then you can copy the .bak files to disk with ARCSERVE.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SQLServer cant backup remotely (on Workgroups) unless Administrator?
    ... I removed SQLAgent from the equation by backing up directly from Query ... > SQL Server Agent must be started under stronger account, ... >>SQL backup across the network to an NT Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting Phone to stay on!
    ... Try backing up your system and doing a hard reset ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ...
    (microsoft.public.pocketpc.phone_edition)
  • Re: To recover corrupted database
    ... if you're using simple recovery mode then you can't have been backing up the ... transaction logs, so the full database backups will be the only useful ones ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • SQLVDI Error
    ... SBS 2003 R2 Standard, with SQL Server Express ... related to backing up as it seems to happen during that time period and does ...
    (microsoft.public.windows.server.sbs)
  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Which drive for logfile backups? ... Why are you using Enterprise edition of SQL Server if you only have Std ... drives with no Raid. ...
    (microsoft.public.sqlserver.programming)