|
You cannot backup a live databse and these are the sql database
You have two options
Buy the netbackup sql database agent to back them up
Or as I do
The sql adin has set up a backup dir
He then schedules sql to do it own backup and up the backup files in that backup dir
My normal system backup policy exclides the sql data from backup abd excludes the backup dir
I then have a seperate policy that runs at 2 a (a time after I know th backup to disk has completed) and this policy just backups the backup dir
Good point about this is that I don't have to know how to backup or restore sql
I just back up or restore files
The sql dba does the restore from the disk files th the actual database
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu <veritas-bu-bounces AT mailman.eng.auburn DOT edu>
To: VERITAS-BU AT mailman.eng.auburn DOT edu <VERITAS-BU AT mailman.eng.auburn DOT edu>
Sent: Sat Mar 20 09:34:34 2010
Subject: [Veritas-bu] open files to be backed up
Hi All,
I have a small issue here :
Backup of one of the server is getting partially successfull
Master : Solaris 10 , netbackup 6.5.4
Client : window 2003 , netbackup 6.5.4
Here the files that are not getting backed up :
03/19/2010 21:31:38 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\Audit_DB_Data.MDF (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:39 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\Audit_DB_Log.LDF (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:40 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\crnmr4_Data.MDF (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:41 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\crnmr4_Log.LDF (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:41 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:42 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:43 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:44 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:45 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:31:46 - Warning bpbrm (pid=14837) from client : WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
03/19/2010 21:59:29 - end writing; write time: 0:58:17
the requested operation was partially successful (1)
I want these files to be backed up. I tried
Disabled Open file backup and refired backup - -- still didnot backup these files
Selcted -- Enabled VSP , Individual drive snapshot, Abort on error -- refired backup -- still didnot backup these files
Selcted -- Enabled VSS , Individual drive snapshot, Abort on error -- refired backup -- still didnot backup these files
Can sombody help me how to get these files to be backed up. its a production server , need to fix this quickly
Thanks
Sachin
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
| 