We use Arcserve for our backup software. Everynight, we get errors that
msllockdb.mdf, msllockdb_ldf, pwe.mdf, & pwe_log.ldf cannot be accessed
because they are being used by another process. Does anyone know what is
causing this and how to correct it?
--
Thanks!You are obviously not using the SQL Server plugin for Arcserver. It is
trying to copy the files directly and that is always a no no for SQL Server.
You need to invoke the SQL Server backup command thru Arcserves SQL Server
specific extensions.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Saucer Man" <saucerman@.nospam.com> wrote in message
news:4742f3fc$0$27025$cc2e38e6@.news.uslec.net...
> We use Arcserve for our backup software. Everynight, we get errors that
> msllockdb.mdf, msllockdb_ldf, pwe.mdf, & pwe_log.ldf cannot be accessed
> because they are being used by another process. Does anyone know what is
> causing this and how to correct it?
> --
> Thanks!
>|||Thanks. I will look into this.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O0dQXa4KIHA.1184@.TK2MSFTNGP04.phx.gbl...
> You are obviously not using the SQL Server plugin for Arcserver. It is
> trying to copy the files directly and that is always a no no for SQL
> Server. You need to invoke the SQL Server backup command thru Arcserves
> SQL Server specific extensions.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Saucer Man" <saucerman@.nospam.com> wrote in message
> news:4742f3fc$0$27025$cc2e38e6@.news.uslec.net...
>> We use Arcserve for our backup software. Everynight, we get errors that
>> msllockdb.mdf, msllockdb_ldf, pwe.mdf, & pwe_log.ldf cannot be accessed
>> because they are being used by another process. Does anyone know what is
>> causing this and how to correct it?
>> --
>> Thanks!
>
Showing posts with label arcserve. Show all posts
Showing posts with label arcserve. Show all posts
Tuesday, March 27, 2012
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
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
Subscribe to:
Posts (Atom)