• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Verutas Backup Exec 9.1 unable to backup .ldf and .mdf files in SQL

I am using backup exec 9.1 and SQL Server 2000 with Winodws 2003 server.  Backup exec can see .ldf and .mdf files on the sql server however it does not backup the files.  It runs a job and deems it successful without backing up the files!  
I have already checked http://seer.support.veritas.com/docs/242688.htm article but to no avail.  Can anyone advise?
0
fsaiexpert
Asked:
fsaiexpert
2 Solutions
 
Jeroen RosinkCommented:
perhaps note 10 of following article gives you some help:
http://seer.support.veritas.com/docs/261695.htm
0
 
fsaiexpertFSAI ExpertAuthor Commented:
Thanks for the prompt reply - the server is a standalone server - not clustered.
0
 
Jeroen RosinkCommented:
Can it be that the database is locked up by anotherone? and therefor you see the files but those are not included in the backup?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Steve McCarthy, MCSE, MCSA, MCP x8, Network+, i-Net+, A+, CIWA, CCNA, FDLE FCIC, HIPAA Security OfficerIT Consultant, Network Engineer, Windows Network Administrator, VMware AdministratorCommented:
For Veritas to backup SQL successfully, you either need to purchase the SQL agent or stop the database.  You can have the Pre and Post in your job to do a net stop sqlserver before the job and a net start sqlserver after the backup job is complete.
0
 
turn123Commented:
Hi fsaiexpert :-),
Since we haven't heard from you for a couple of days could you please give us an update on the status of this question?
See:  http://www.experts-exchange.com/help.jsp#hi51 Thank you, turn123's friendly update request script.
Offtopic comments about this script to http://www.experts-exchange.com/Applications/Q_21188389.html please :-).
0
 
Steve McCarthy, MCSE, MCSA, MCP x8, Network+, i-Net+, A+, CIWA, CCNA, FDLE FCIC, HIPAA Security OfficerIT Consultant, Network Engineer, Windows Network Administrator, VMware AdministratorCommented:
I'll ask for a share of a split here.
0
 
Steve McCarthy, MCSE, MCSA, MCP x8, Network+, i-Net+, A+, CIWA, CCNA, FDLE FCIC, HIPAA Security OfficerIT Consultant, Network Engineer, Windows Network Administrator, VMware AdministratorCommented:
sounds good to me
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now