?
Solved

Backup Exec 10D & SQL 2000

Posted on 2006-11-08
5
Medium Priority
?
220 Views
Last Modified: 2013-12-01
When doing a flat file backup of our SQL server I noticed that all of the  *.mdb files are missing? I have B.E. set to backup the whole drive yet when trying to do a restore the files are note listed int the MSSQL \ DAtA directory. Any thoughts on this?
0
Comment
Question by:compdigit44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 56

Expert Comment

by:andyalder
ID: 17899008
SQL should be backed up using the SQL agent, you can't backup the raw .mdb files since SQL server has them open. If the SQL agent is installed Backup Exec queries master database to see where the mdb files are and automatically excludes them from the flat file backup. If you stop SQL service then BE won't be able to query SQL and will therefore not automatically exclude them.

See for example the bottom of http://support.veritas.com/docs/263784 "Failure to clear these files can cause data corruption." which is why it automatically excludes them normally. A SQL restore through the agent will of course recreate them.
0
 
LVL 4

Expert Comment

by:Nitrosys
ID: 17911050
If you dont have the SQL agent you could have SQL backup the DB to a file and then use Backup Exec to back up that file.
0
 
LVL 5

Expert Comment

by:shankshank
ID: 18039323
Yes.

What I do is at 9PM I run a SQLDUMP job that is scheduled in the enterprise manager. 9:30, those dumps are copied a network folder. 10:00 backupxec runs and backsup the network folder with all my sql dumps

0
 
LVL 4

Expert Comment

by:Nitrosys
ID: 18039358
When you look at the folder with the dump does it have the .mdb files and they are not making it to the BE backups or are they not there to begin with? If they are in the folder and they are selected to be backed up, are you getting any BE errors when the job runs?
0
 
LVL 56

Accepted Solution

by:
andyalder earned 1000 total points
ID: 18039501
You don't see the .mdb files in a backup whether it's Backup Exec or a SQL dump, these backup the data in the MDB files through an API, they don't backup the files themselves. I would suggest that compdigit44  has a good bckup but is simply looking for the .mdb file in the catalog rather than looking for the databases under the SQL part of the selection list tree.
0

Featured Post

7 Extremely Useful Linux Commands for Beginners

Just getting started with Linux? Here's a quick start guide that has 7 commands that we believe will come in handy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question