Video Screencast Help

geeting this error while taking the backup of sqlserver its urgent

Created: 13 Oct 2012 • Updated: 15 Oct 2012 | 8 comments
roh234's picture
This issue has been solved. See solution.

hi all

i have created one backup exec server in work group enivroment from that backup server i am taking the backup of sql server,i have created the  seperate user for installaing the backupexec on media server and createdthe sameuser on my sql server with the same password,i have tested the creditional and it is succeful

 

i have  pushed the agent for window to my sql server when i am doing theremote installtion it is only shoing my agent for window and backup exec,but when i was instlling the  backup exec media server and entered my licence key it is showing me 3 things

agent for window

agent for application and db

backup exec server whichi have  checked for installtion

now whe i am doing the remote installation y i am not geeting the option of application and database so i have selected the agent for window and installed them created backup job for my sql

 

but i gotthis error

Job Completion Status
Job ended: Saturday, October 13, 2012 at 6:35:45 PM
Completed status: Failed
Final error: 0xe000ff19 - A communications failure has occurred with a SQL Server resource.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-65305

Errors
Click an error below to locate it in the job log

 

Backup- Vishnu
V-79-57344-65305 - The database server is not responding. Backup set canceled. V-79-57344-65305 - The database server is not responding. Backup set canceled.

Exceptions
Click an exception below to locate it in the job log

 

Backup- Vishnu
V-79-57344-893 - Snapshot Technology: Initialization failure on: "Vishnu\MSSQLSERVER". Snapshot technology used: Microsoft Volume Shadow Copy Service (VSS). Snapshot technology error (0xE000037D): An attempt to connect to SQL Server has failed. The logon account may have invalid credentials, or the logon account may have been applied to the wrong resource. Check the Windows Event Viewer for details.

 

Backup- Vishnu
V-79-57344-893 - Snapshot Technology: Initialization failure on: "Vishnu\MSSQLSERVER". Snapshot technology used: Microsoft Volume Shadow Copy Service (VSS). Snapshot technology error (0xE000037D): An attempt to connect to SQL Server has failed. The logon account may have invalid credentials, or the logon account may have been applied to the wrong resource. Check the Windows Event Viewer for details.

 

 

kindly help me to solve this

 

Comments 8 CommentsJump to latest comment

sazz.'s picture

Which version of SQL:

Make sure under sql studio management on SQL server ->security-> logins add backupexec user account in there & give it server admin, sysadmin, dbcreator.

Also

http://www.symantec.com/docs/TECH125780

 

roh234's picture

hi thanks for responding

 

its sql 2008,

 

might be it is the solution of 2nd error what aboutfirst

sazz.'s picture

First make sure AOFO is unchecked for database backups.

Make sure credentials are right for the account and setup as per previous thread.

Check the event viewer on SQL and check if there are any error.Check this article if that matches your issue

http://www.symantec.com/docs/TECH124776

 

SOLUTION
pkh's picture

Why are you installing the BE media server in a workgroup?  This will present a problem with it comes to permissions because BE is designed to work in  a domain.

roh234's picture

hi pkh

i dont have option of AD,my client is not ready to connect the server with the domin,

i have test creditional it ispassed but i got the erorwhile running job.

 

now i have tp soolve this and use the software in workgroup enviroment

 

kindly suggestthe solutiona and one more thing is installed the right agent ,agent for window is coming i have installed that

sazz.'s picture

Are you getting error only while backing up sql?

Have you tried backing up just the local drives, does it work?

Have you already checked the event viewer?Any error message or anything?

Under what account your BE services running?

roh234's picture

i am backing up the drive in which my mdf and ldf files are there and system state and thes are the local drive,i have not checked the event viewer ,my be services are running with the seperate userwho has admin permisstion,

Jaydeep S's picture

Does the account that you are using in backup exec for this backup have enough credentials on the drives that have the mdf and ldf files (NTFS permissions).

Also, try to disable AOFO on the backup job and then try a backup.