Open File Backups

[William_Hildret]

Hello all,

I have a question regarding the netbackup Open File backup feature. I have these backups that I'm trying to do that I have VSP enabled for. There are these sql files that are in use when doing the backup and I can never seem to get these .ldf and .mdf files backed up.

Is there any other modifications that I can make that will back these files up beyond the wait time and file read settings?

[zippy]

WiIliam,

exclude them, ask the DBA if they need them first, in an email CYOA if you know what I mean!

JD

[paul_johnston]

VSP is intened for file-oriented open-file backups. Web server, file server, user laptop/desktop computer.

To do a hot database backup you'll need an backup agent to deal with transactional issues, like the NetBackup for Microsoft SQL Server Agent.

http://www.symantec.com/Products/enterprise?c=optdetail&cid=1018&refId=2&optId=74

Product documentation freely available from:
http://support.veritas.com/menu_ddProduct_NBUESVR_view_CL.htm

The only other choice would be either look into utlizing VSS rather than VSP or bring SQL down and backup the files cold.

hth

[Raghava_Chary]

Will,

I agree with Paul, you need to have SQL Agent to backup databases ... or else you can ask DBA to stop the SQL services at a particular time so that you can backup those files.

If DBA is already performing database level then you must exclude them from backup so that it will not give you return code1.

Raghava.