Solved

SQL 2005 .mdf files not on backup tape

Posted on 2007-11-29
6
1,033 Views
Last Modified: 2013-12-01
I had a hard disk crash and had to do a complete system recovery.  All seemed well until SQL 2005 wouldn't start.  It said the file \program files\microsoft sql\MSSQL.1\MSSQL\data\master.dbf was missing.  Not only was that missing, but the database I've got months in developing is also missing.  It doesn't seem to be on any of my backup tapes either.  Why wouldn't 10d backup my SQL .dbf files?  I am so screwed :(
0
Comment
Question by:tvmccorm
[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
6 Comments
 
LVL 16

Expert Comment

by:SQL_SERVER_DBA
ID: 20377129
do a search for master.mdf
0
 
LVL 23

Accepted Solution

by:
Rahul Misra earned 250 total points
ID: 20377195
The .mdf , .ldf etc cannot be backed up
BE is designed to skip them and other database files/
You cannot backup the SQL databases without the SQL AGENT license
The only way to do that would be to backup the database files as FLAT FILES i.e by detaching or dismounting the databases and then backing up the respective .mdf,ldf etc.
If you cannot detach the databases for any reason then you WILL need a SQL  AGENT LICENSE.
Once the License KEy is added to the 11D installation (TOOL>LICENSE KEYS AND INSTALLATIONS) you will see the LOGICAL SQL DATABASE structure and you will be able to backup the SQL databases (the .mdf and .ldf etc will still be skipped as they cannot be backed up with any agent whatsoever as long as the databases are attached)
Once you are  backing up the SQL databases it will backup all the information including the transaction logs

Backup Exec 11d Best Practices Guide: Agent for Microsoft SQL Server
Document ID: 285757
http://support.veritas.com/docs/285757
0
 
LVL 23

Expert Comment

by:Rahul Misra
ID: 20377203
Also for BE 10.1.5629  you need HF 6 to add support for SQL 2005
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 23

Expert Comment

by:Rahul Misra
ID: 20377222
Backup Exec for Windows Servers now supports the protection of Microsoft SQL 2005 (Yukon) Servers.
http://support.veritas.com/docs/276497

Available updates for Backup Exec 10d 5629 for Windows Servers
http://support.veritas.com/docs/280278 
0
 
LVL 5

Assisted Solution

by:cgordon81
cgordon81 earned 250 total points
ID: 20401469
ditto on iamthecreator's comment.

You need to be backing up SQL with the SQL agent if you want backup exec to manage this.  You can't just backup a database file in this manner and expect it to work.  You should be using the SQL tools to create a .bkf (flat file) backup and back that up with backup exec if you don't want to buy the SQL agent.  
0
 

Author Closing Comment

by:tvmccorm
ID: 31411790
I'll use cgordon81s method until I can get the SQL agent installed.  thanks.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Error - Query 6 49
Win 10...Some user folders missing location tab 7 138
Anything wrong with Window server backup? 8 82
SSMS Imprt data from Excel 7 20
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

740 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