Solved

SQL 2005 .mdf files not on backup tape

Posted on 2007-11-29
6
1,028 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
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 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