Sunday, February 12, 2012

Backup

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? ThankFlores
BACKUP DATABASE dbname TO DISK =
N'\\ServerB\shared_folder\dbname.BAK'
"Flores" <Flores@.discussions.microsoft.com> wrote in message
news:2D4AE076-5C65-49CC-9AE4-6DFE6861001D@.microsoft.com...
>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|||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@.discussions.microsoft.com> wrote in message
> news:2D4AE076-5C65-49CC-9AE4-6DFE6861001D@.microsoft.com...
>
>|||Flores (Flores@.discussions.microsoft.com) 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@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>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 incrementa
l
>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:
>|||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@.discussions.microsoft.com> wrote:
>
>|||Lines: 1
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.8.112.204
Xref: leafnode.mcse.ms microsoft.public.sqlserver.security:2633
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@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>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 wit
h
>.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 nee
d
>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:
>|||I am having a similar prboem but do not believe it has to do witht he SP2.
My problem started on 3/21/7 and I had not done an updage of anything since
3/3/7... My guess is that it has something to do with the security updates
provided in another patch to Exchange. I am not sure whyt he delay for me.
--
"Flores" wrote:

> I have a windows 2003 server(let call it server a) running arcserve v11 wi
th
> backup agent for SQL. I have another server (server b) running SQL. I ca
n
> 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

No comments:

Post a Comment