pabby061203
asked on
Backup Exec skipping SQL files
SQL Files being skipped - 'unable to open item'
I need to ensure that my dbases are being backed up but my backup is skipping a lot of ldf and mdf files.
I have the SQL Agent installed and have read about an identical situation here in EE. My Selections navigated through the network to the sql Server where it splits into F$ and E$. It seems that it is the files in these two drives cannot be accessed. I am not sure if this is the correct way to backup my sql dbases - can someone please clarify,
thanks
I need to ensure that my dbases are being backed up but my backup is skipping a lot of ldf and mdf files.
I have the SQL Agent installed and have read about an identical situation here in EE. My Selections navigated through the network to the sql Server where it splits into F$ and E$. It seems that it is the files in these two drives cannot be accessed. I am not sure if this is the correct way to backup my sql dbases - can someone please clarify,
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MDF files and LDF files of a running database are always in use by SQL server and can't be opened exclusevely by the backup program.
You should use SQL server to backup the database to a .BAK file (by using a maintenance schedule for instance) and then backup that file with our backupsystem.
You should use SQL server to backup the database to a .BAK file (by using a maintenance schedule for instance) and then backup that file with our backupsystem.
Did you check the Symantec/ Veritas site for more info ?
I hope this helps !