Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

sql backup error

Created: 15 Dec 2012 • Updated: 17 Dec 2012 | 4 comments
This issue has been solved. See solution.

Hi

when i want get backup from SQL DB i see this error:

Unable to attach to a resource. Make sure that all selected resources exist and are on-line, and then try again. If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection For additional information regarding this error refer to link V-79-57344-33932

i use a backup to disk folder method and create a folder in backup server

this error shows when i want get a backup server from SQL server but when i get backup file "no DB" my job is successfully

how do i solve this problemsad

Comments 4 CommentsJump to latest comment

psj_symhelp's picture

Hi

Check the credential of backup job logon account for sql server and test should be successfull.

check the database status is online and uncheck database physical consistancy in backup job.

make sure that backup job logon account should have full rights on sql database like dbowner and dbcreator

 

run the backup job and check result. If problem occured share job logs

SOLUTION
sadegh's picture

tnx smileyheart

my problem solved by change the account type with right permission

sadegh's picture

but i face a new problem

when i get backup after finish job i see this exception

Database MSCRM_CONFIG is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.

i install a remote agent in OS and OS is inside vmware virtual machin

SQL Backup method is full - backup entire database filegroup

how do i do??frown

 

CraigV's picture

Check below for this error:

http://www.symantec.com/business/support/index?page=content&id=TECH126063

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...