Backup Exec and MDAC update

I have a client in a Windows 2000 SP4 network environment
that is using Backup Exec 9.0 with a remote agent for
Exchange and a remote server. They ran the Windows
Updates last Friday and now they are receiving errors on
their backup job when it tries to back up the server that
they updated. The event id in the event viewer is 34323
and reads as follows:
Update to catalog file Catalog index database failed.
Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]
Violation of PRIMARY KEY
constraint 'PK_CatMedia_68487DD7'. Cannot insert dupl
cat_RecordSet:Reopen[]
d:\be\tybee\4367r\becat\server\dll\catme
dia.cpp[753]
I also get the following event id 34338 in conjunction
with the above error:
Backup Exec Alert: Catalog Error
[Server:"servername"]ODBC access error. Possible lost
connection to database or unsuccessful access to catalog
index in the database.
I have submitted this to Veritas forum as well but if
anyone has any ideas, I would appreciate it. The Windows
Update apparently applied KB832483 which is an MDAC
update. I don't see where I can roll this back either.
Thanks. DeannaDeanna,
did you ever figure out a solution to this problem? i'm experiencing
the same thing in the same type of environment.
thank you,
Lenny.
Deanna wrote:
> *I have a client in a Windows 2000 SP4 network environment
> that is using Backup Exec 9.0 with a remote agent for
> Exchange and a remote server. They ran the Windows
> Updates last Friday and now they are receiving errors on
> their backup job when it tries to back up the server that
> they updated. The event id in the event viewer is 34323
> and reads as follows:
> Update to catalog file Catalog index database failed.
> Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]
> Violation of PRIMARY KEY
> constraint 'PK_CatMedia_68487DD7'. Cannot insert dupl
> cat_RecordSet:Reopen[]
> d:\be\tybee\4367r\becat\server\dll\catme
dia.cpp[753]
> I also get the following event id 34338 in conjunction
> with the above error:
> Backup Exec Alert: Catalog Error
> [Server:"servername"]ODBC access error. Possible lost
> connection to database or unsuccessful access to catalog
> index in the database.
> I have submitted this to Veritas forum as well but if
> anyone has any ideas, I would appreciate it. The Windows
> Update apparently applied KB832483 which is an MDAC
> update. I don't see where I can roll this back either.
> Thanks. Deanna *
lennyi
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message422513.html

Backup device

Hi all,
I tried to create the new backup device with UNC path on the remote server
\\remoteserver\share on the sql server. But, I got "can not verify the
path" message and I have no problem to access the share through the sql
server. I checked the share and file security on the share and file and they
are fine.
I can not verify why I can not create UNC backup device on this sql server.
(windows 2003 R2 SP2 and sql 2000)
Can anyone help?
Try using sp_addumpdevice directly. It might just be the GUI which try to "assist" you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John" <John@.discussions.microsoft.com> wrote in message
news:75486005-3FAB-499B-9C38-7C128149BFF9@.microsoft.com...
> Hi all,
> I tried to create the new backup device with UNC path on the remote server
> \\remoteserver\share on the sql server. But, I got "can not verify the
> path" message and I have no problem to access the share through the sql
> server. I checked the share and file security on the share and file and they
> are fine.
> I can not verify why I can not create UNC backup device on this sql server.
> (windows 2003 R2 SP2 and sql 2000)
> Can anyone help?
|||> I have no problem to access the share through the sql
> server.
How did you access the share through the SQL instance?
Linchi
"John" wrote:

> Hi all,
> I tried to create the new backup device with UNC path on the remote server
> \\remoteserver\share on the sql server. But, I got "can not verify the
> path" message and I have no problem to access the share through the sql
> server. I checked the share and file security on the share and file and they
> are fine.
> I can not verify why I can not create UNC backup device on this sql server.
> (windows 2003 R2 SP2 and sql 2000)
> Can anyone help?

Backup device

Hi all,
I tried to create the new backup device with UNC path on the remote server
\\remoteserver\share on the sql server. But, I got "can not verify the
path" message and I have no problem to access the share through the sql
server. I checked the share and file security on the share and file and they
are fine.
I can not verify why I can not create UNC backup device on this sql server.
(windows 2003 R2 SP2 and sql 2000)
Can anyone help?Try using sp_addumpdevice directly. It might just be the GUI which try to "assist" you.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John" <John@.discussions.microsoft.com> wrote in message
news:75486005-3FAB-499B-9C38-7C128149BFF9@.microsoft.com...
> Hi all,
> I tried to create the new backup device with UNC path on the remote server
> \\remoteserver\share on the sql server. But, I got "can not verify the
> path" message and I have no problem to access the share through the sql
> server. I checked the share and file security on the share and file and they
> are fine.
> I can not verify why I can not create UNC backup device on this sql server.
> (windows 2003 R2 SP2 and sql 2000)
> Can anyone help?|||> I have no problem to access the share through the sql
> server.
How did you access the share through the SQL instance?
Linchi
"John" wrote:
> Hi all,
> I tried to create the new backup device with UNC path on the remote server
> \\remoteserver\share on the sql server. But, I got "can not verify the
> path" message and I have no problem to access the share through the sql
> server. I checked the share and file security on the share and file and they
> are fine.
> I can not verify why I can not create UNC backup device on this sql server.
> (windows 2003 R2 SP2 and sql 2000)
> Can anyone help?sql

Backup check

Hello,
I want to create a stored procedure to
check if backups ended successfully at remote databases.
Which query can i run?
Many Thanks in Advance,
Galit.Gal
Assuming you are running your backups as jobs. The
information you need should be on sysjobhistory on the
msdb database. You can write a stored procedure to get the
information from there.
Regards
John

Backup a remote SQL Server to local computer?

Is there an easy way to backup a database on a remote SQL Server to a backup file on my local computer?I was thinking of that too. A straight up backup won't work, SQL needsa local device for that. You should be able to replicate the data to alocal database and back that up though. I tried and it didn't work.It's been a while and I haven't persued it so I'm sorry that I can'tprovide details. Take a look in Enterprise Manager, I think I tried theExport function. Of course any backup is only as good as its recoverycapabilities. Whatever you come up with, try it out *before* you need arecovery done :)
|||I think only a database backup tool will do what you want to do. If it is a company network this is what I have done remote into the server do the backup use Winzip to zip the file and email it to whoever needs it yourself included. When restoring use restore from device option in the backup wizard. Hope this helps.

Backup

Hi

I had problem with my backup file. I'm taking backup on remote machine a full backup in append mode just because my database size is small.Due to some reason the backup was incompleted that was shown when i'm looking the file. Now when i' try to backup on same file it gives an error messages. Is it possible to remove the incomplete mark on file.Even if i try overite the file its not allowed. Tell me why its so and how to use the same file without moving it.Howdy

No - rename the old file & use a new file . If the old file is corrupted, you run the risk of continually using a corrupted backup - not a good thing.

Cheers,

SG.

Backing up to different machine

I want to backup my databases on another remote machine, but ms sql doesnt seem to have that ability built in. Does anyone know to send the backup to a network mapped drive?

Background:

Currently, the backups are going to c:\backups located on the same machine, but I want the to go to machine backup in directories x:\backup

Any help would be appreciated.Try this,

BACKUP DATABASE [myDB] TO DISK = N'\\RemoteServerName\SharedDrive\myDB_Backup' WITH INIT , NOUNLOAD , NAME = 'myDB backup', NOSKIP , STATS = 10, NOFORMAT|||Thanks, ill give that a try.|||Any reason you want to backup directly to a network drive ? If possible, I would backup to a local device, then move it to another device... However, tape is my first choice.|||Would backing up to another machine in the network cause additional overheads to the network and indirectly effect the backup process?

If backup to a remote computer can't work, maybe you can consider replication, it is another way of backup!|||Having another server as a failover would be a nice situation. Anytime you push backups across a network you increase your chances for failure.|||ok, i guess I should spell this out a little better. The program I am running now does not support replication. Any attempt to do so would violate the license agreement and cuse the software to fail. Because of this, I find myself only able to backup on the existing sql machine. I would like these backups to go to my archive machine on the network for safety. If at all possible, I would like the local and remote backups to be created at the same time.|||Why not create a stored procedure to run after the backup has completed to copy to remote machine . That will do the task|||Thats the problem I am having. The stored procedure is not problem, but I cant get sql to recognize the other drive on the other machine on the network. the command given above in this forum doesnt seem to work for me.

I have the backups currently going to c:\ on the local machine and have mapped a shared drive that is designated e:\ that points to the other machine, but when ever I try to backup to that location, it fails.|||i believe using xp_cmdchell will solve the problem... do you have administrative rights over the shared folder.|||yes i do, and I will look into that, thanks

Backing up to a remote server

I am just getting started with MS SQL and am having to learn from scratch. I have a DB running with an ISP which I need to back up to one of my local machines. I have installed MS SQL Server 2005 and also MS SQL Server Management Studio Express. Using this, I have opened a new DB on the local machine and then accessed the DB on the remote server. If I then right click on the remote DB file and select Tasks\Backup, I see the backup options screen. The problem is that the destination for the backup is automatically set to a folder on the remote server and I cannot figure out how to change this so that I can download to the local machine. If I click on the 'Add' button to create a new backup path, it will only offer me a view of the remote machine, not the local file structure.

The solution is probably pretty simple, but after several hours of experimentation and searching for solutions, I still can't come up with the answer. Can anyone offer some guidance please (in idiot language - I'm new to this).

When you are looking at the remote database you want to backup, is there a Remove button right below the Add button? If so, click the Remove button.

Then on the local server you'll need to Share out your backup folder. So if your backup folder is J:\sqlbackups, you'll need to share that folder with at least Change permissions at the share level, and Write permisisons at the NTFS folder level.

Once you have done that go back to your backup screen, and click Add, when the window pops up, instead of browsing for a location, type in the share location you just created, i.e. \\mylocalserver\sqlbackups

You also have the option of not sharing out your local backup folder and just typing in \\mylocalserver\j$\sqlbackups, but that is not usually a recommended way of doing it.

When you are backing up a remote database, it needs to be directed where it should be backed up to on your local server via a network share. Otherwise it only understands the file structure on the server it is running on, because it is on a separate physical server from where you are trying to create the backup.

Backing up to a Remote machine in EM

I need to backup my databases to a remote server. The
problem is Enterprise manager will not recognize a UNC
address. Is there a way I can permanently change this
without just using trace flags.
I am running sql server 2000 with sp3a.
Any suggestions
Make mapped network drive on your machine. For what trace flags are you
talking?
Bojidar Alexandrov
"Kelly" <mavericc@.wepsoft.com> wrote in message
news:830101c431ea$54a0a920$a301280a@.phx.gbl...
> I need to backup my databases to a remote server. The
> problem is Enterprise manager will not recognize a UNC
> address. Is there a way I can permanently change this
> without just using trace flags.
> I am running sql server 2000 with sp3a.
> Any suggestions
|||Mapped drives are not recognized by Enterprise manager either.
I was refering to traceflag 1807.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Have the ID that SQL agent is running under map the drive letter then try
and connect to it.
Jeff Duncan
MCDBA, MCSE+I
"Kelly P" <mavericc@.wepsoft.com> wrote in message
news:%23pCT%23dgMEHA.1468@.TK2MSFTNGP12.phx.gbl...
>
> Mapped drives are not recognized by Enterprise manager either.
> I was refering to traceflag 1807.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!