05-24-2012 10:08 AM
Hi,
we use Symantec Exec 2010 R3. We backup many servers and applications. Now I reinstalled SQL server, imported all data and gave the SAME fqdn name to this server. I installed agent (not sure if the right way) through Tools / Install Options and Media Servers on Other Servers / selected same server from AD. How to be sure that bach up will work as it did before reinstallation?
thank you,
n
Solved! Go to Solution.
05-24-2012 12:49 PM
...that all looks right. Check the Job Setup tab and make sure your jobs appear there along with your selection lists.
Then check the media sets and make sure your tapes are there. Once done, run a backup job!
Thanks!
05-24-2012 10:13 AM
1st make sure if the server appears in the "Favorite Resources" of the selection list.
Select few resources from the server and perfrom a test for credentails.
You may take a backup of a file or a small size folder or else you may try a "Test Run" of the
actual job. Test Run will just scan the selected resources and will return tentative results
05-24-2012 12:49 PM
...that all looks right. Check the Job Setup tab and make sure your jobs appear there along with your selection lists.
Then check the media sets and make sure your tapes are there. Once done, run a backup job!
Thanks!
05-25-2012 05:11 AM
05-25-2012 05:30 AM
even all accounts are in place my backup failled with:
V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cann...
User 'guest' does not have permission to run DBCC checkdb for database 'master'.
V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cann...
User 'guest' does not have permission to run DBCC checkdb for database 'msdb'.
How could I check consistency or run pre buckup activities to be sure that backup will be succesfful on the schedule time?
thank you,
05-25-2012 05:43 AM
thank you, I check sysadmin permissions in sql server.
And how could I check consistency or run pre buckup activities to be sure that backup will be succesfful on the schedule time?
thanks
05-25-2012 05:46 AM
...check under Tools --> Options --> SQL. You can set the checks there.
Check below for further information:
http://www.symantec.com/business/support/index?page=content&id=HOWTO73850
05-25-2012 07:00 AM
thank you Craig. I have other backups configured wich also failled last couple weeks. As space in tapes is limited, could I do pre backup activities to ensure that everything is correct. Could I perform Test Run of the backup ?
thank you
05-25-2012 07:02 AM
...no reason for you not to try...
You can also do a credential check in the selection list if need-be.
05-26-2012 03:39 AM
I run one incremental check job and got:
Errors
Click an error below to locate it in the job log Backup- SQL.domain.com
V-79-65323-3035 - An error occurred on a query to database model.
V-79-65323-3035 - An error occurred on a query to database RServer
V-79-65323-3035 - An error occurred on a query to database RTempDB.
V-79-57344-867 - The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup.
Exceptions
Click an exception below to locate it in the job log. Backup- SQL.domain.com
The item APSQL.ukmin.lt\model in use - skipped.
The item APSQL.ukmin.lt\RServer in use - skipped.
The item APSQL.ukmin.lt\RTempDB in use - skipped.
The item APSQL.ukmin.lt\test in use - skipped.
is this one error? or it is related that it can't find full backup?
thank you,
05-26-2012 06:50 AM
05-26-2012 07:24 PM
You need to run a full backup of your SQL databases before running an incremental backup.