Re: Backup

The open file backup agents backup the databases while they
are open using their own code and their own software. You
manage the backups and restores through their software.
When you do native backups, you use the BACKUP command in
SQL Server. SQL Server will backup the database to a file on
disk or tape. This can be done while the databases are in
use. SQL Server can restore those files to restore a
database using the RESTORE command.
The directory with the .bak files may very likely be SQL
Server native backup files. If it's a backup file, you can
view the details by executing
RESTORE HEADERONLY
FROM DISK = 'C:\PathToDirectory\SomeFilename.bak'
- with whatever is the necessary path to the file.
That won't restore the database, it will just return some
information about what's in the bak file.
If you restore a database, the log and data files will be
restored to the same location that the backed up database
had for file locations. You can view those locations for a
backup file by executing
RESTORE FILELISTONLY
FROM DISK = 'C:\PathToDirectory\SomeFilename.bak'
- with whatever is the necessary path to the file.

There is a lot of information about backup and restore in
SQL Server Books Online.

-Sue

On Tue, 27 Feb 2007 08:13:16 -0800, Flores
<Flores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I've done the SQL backups through the agent for years and from what I
understand, the agent is suppose to backup the databases while they're open.
But for the last few days I've been backing up a directory named backup with
.bak files in it. This directory is under the SQL directory. Is this
directory a result of the SQL native backup you're talking about? If I need
to do a database restore, will I restore it to the backup directory? if so
how does the database get to the SQL\Data directory? Sorry for all these
questions but I do not know much about SQL. Thanks

"Sue Hoegemeier" wrote:

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

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • 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: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)