agent for microsoft sql server

362 Topics

BE2012 SQL Full then Inc backup, Inc backup does not run
I have a MS Server 2008, SQL 2012 server I've been backing up for a while now. Basically, I configured a Full backup job to run nightly followed directly by an Incremental job to fullfill the Logs backup requirement. These backups go to a virtual tape library then get dumped to tape automatically after an eject of the virtural tape occurs. So, I set the Inc job to eject the tape. The requirement here being I need a nightly full backup to disk, then tape. Problem is... Just the other day, the Incremental job just won't run anymore, no error, doesn't even show up in the log even though it's clearly scheduled. Is there some unstated rule in BE2012 that it doesn't run a second Incremental stage if a Full backup occurs? I'd expect an error or a skipped job message to at least indicate what happened. It's just odd. Like I said, it WAS working then just quit last week. I even deleted the old job and created a new to see if that was the issue with no luck. Anyone have any ideas? Thanks
Solved
trelectric
13 years ago Place Backup Exec
761Views
3likes
5Comments
BE 12.5 Cannont Add SharePoint Farms
Community, Working with Backup Exec 12.5 in a test environment to test backup and restores from our production environment. I installed SharePoint 2007(SP2) on Windows server 2003 (SP2), SQL 2000 (SP4) and .net 3.5 (SP1) one one server and Windows Server 2003 (SP2) Backup Exec 12.5 (SP4) with SQL and SharePoint agents licensed, in a simplistick setup with pretty much all the defaults. When I try and add the SharePoint server as a SharePoint resource I get the error: "None of the Web servers for the specified server farm could be accessed." I can successfully connect backup and restore SQL, but that isn't the method used on our production. I've tried every article/discussion I could find related to this error, any advice or troulbeshooting steps would be greatly appreciated. Also attached is the debug when I try to add the sharepoint server farm Backup Server: *************************************************************************** ***** SGMon log for \\BACKUP2003 ***** *************************************************************************** BKUPEXEC: [03/05/13 10:36:16] [3148] luster" key does not appear to be present in the registry BKUPEXEC: [03/05/13 10:36:16] [3148] iled to open Microsoft cluster () BKUPEXEC: [03/05/13 10:36:16] [3148] S cluster keys do not appear to be present in the registry BKUPEXEC: [03/05/13 10:36:16] [3148] iled to open VCS cluster () BESERVER: [03/05/13 10:36:16] [3356] -1 Client requested key (1362447526). BESERVER: [03/05/13 10:36:16] [3844] "Cluster" key does not appear to be present in the registry BESERVER: [03/05/13 10:36:16] [3844] Failed to open Microsoft cluster () BESERVER: [03/05/13 10:36:16] [3844] VCS cluster keys do not appear to be present in the registry BESERVER: [03/05/13 10:36:16] [3844] Failed to open VCS cluster () BESERVER: [03/05/13 10:36:16] [3844] 01 Server Configuration: Client added: 7 BESERVER: [03/05/13 10:36:16] [3844] -1 Client 'BACKUP2003' connected('','NT AUTHORITY\SYSTEM'): 0x10ca370 BEREMOTE: [03/05/13 10:36:16] [1228] "Cluster" key does not appear to be present in the registry BEREMOTE: [03/05/13 10:36:16] [1228] Failed to open Microsoft cluster () BEREMOTE: [03/05/13 10:36:16] [1228] VCS cluster keys do not appear to be present in the registry BEREMOTE: [03/05/13 10:36:16] [1228] Failed to open VCS cluster () BEREMOTE: [03/05/13 10:36:16] [1228] GetServerType for local machine BEREMOTE: [03/05/13 10:36:16] [1228] Finding MNET entries using PunchDownWithWNetCalls() BEREMOTE: [03/05/13 10:36:16] [1228] Notes Agent:FindDrives BEREMOTE: [03/05/13 10:36:16] [1228] No Oracle SID's were discovered BEREMOTE: [03/05/13 10:36:16] [1228] GetServerType for local machine BEREMOTE: [03/05/13 10:36:16] [1228] Device Shadow?Copy?Components Dle platform 2 major version 5 minor version 2 build 3790 BEREMOTE: [03/05/13 10:36:16] [1228] No utility partitions found on any of the disks BEREMOTE: [03/05/13 10:36:16] [1228] NRDS_RA_FindDrives entered BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client connected. BEREMOTE: [03/05/13 10:36:16] [1228] FS_CreateTempDLE BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client connected. BEREMOTE: [03/05/13 10:36:16] [1228] NRDS cache-hit for sharepointtest BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client disconnected. BEREMOTE: [03/05/13 10:36:16] [1228] FS_CreateTempDLE BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client connected. BEREMOTE: [03/05/13 10:36:16] [1228] NRDS cache-hit for sharepoint2 BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client disconnected. BEREMOTE: [03/05/13 10:36:16] [1228] FS_CreateTempDLE BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client connected. BEREMOTE: [03/05/13 10:36:16] [1228] NRDS cache-hit for backup2003 BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client disconnected. BENETNS: [03/05/13 10:36:16] [2528] NRDS API - client disconnected. BEREMOTE: [03/05/13 10:36:16] [1228] NRDS_RA_FindDrives completed BEREMOTE: [03/05/13 10:36:16] [1228] Informational: Cps root device creation using default Cps library mechanism when creating device 'Cont?Prot?Srv' in CPS::DetermineRootCpsComponent:696 BEREMOTE: [03/05/13 10:36:16] [1228] Informational: Cps library not available. Not creating Cps root device 'Cont?Prot?Srv' in CPS::DetermineRootCpsComponent:700 BEREMOTE: [03/05/13 10:36:16] [1228] Function called: DB2_FindDrives BEREMOTE: [03/05/13 10:36:16] [1228] Status 0xE0008488 returned calling FindDrives for file system 28 in DLE_UpdateList BEREMOTE: [03/05/13 10:36:16] [1228] AD:DeviceName "System?State" in SystemState::CreateDLEs:361 BEREMOTE: [03/05/13 10:36:16] [1228] AD:Full Device Path "System?State" in SystemState::CreateDLEs:366 BEREMOTE: [03/05/13 10:36:16] [1228] AD:ADRO Agent is authorized for System?State. BEREMOTE: [03/05/13 10:36:16] [1228] AD:Found 0 instances of Active Directory Applcation Mode in SystemState::GetADAMInstanceCount:1365 BEREMOTE: [03/05/13 10:36:16] [1228] ADC_FindAgents entered BEREMOTE: [03/05/13 10:36:16] [1228] AdcEstablishConnection: , ERROR: Error=8007054B BEREMOTE: [03/05/13 10:36:16] [1228] ADC_FindEntries: Could not create ADC instance BEREMOTE: [03/05/13 10:36:16] [1228] ADC_FindAgents completed BEREMOTE: [03/05/13 10:36:16] [1228] Status 0xE000FE0B returned calling FindDrives for file system 33 in DLE_UpdateList BEREMOTE: [03/05/13 10:36:16] [1228] SQL2_FindDrives - the default SQL Service is not running on BACKUP2003. BEREMOTE: [03/05/13 10:36:16] [1228] SQL2_FindDrives - checking named instance BKUPEXEC. BEREMOTE: [03/05/13 10:36:16] [1228] IsServiceClusterOk called on BACKUP2003 BEREMOTE: [03/05/13 10:36:16] [1228] Found SOFTWARE\MICROSOFT\Microsoft SQL Server\MSSQL.1 in the registry. BEREMOTE: [03/05/13 10:36:16] [1228] VCS cluster keys do not appear to be present in the registry BEREMOTE: [03/05/13 10:36:16] [1228] Failed to open VCS cluster () BEREMOTE: [03/05/13 10:36:16] [1228] Found SOFTWARE\MICROSOFT\Microsoft SQL Server\MSSQL.1 in the registry. BEREMOTE: [03/05/13 10:36:16] [1228] SQL2_CreateDLE - creating BACKUP2003\BKUPEXEC. BEREMOTE: [03/05/13 10:36:16] [1228] SQL Version 2005 BEREMOTE: [03/05/13 10:36:16] [1228] Found SOFTWARE\MICROSOFT\Microsoft SQL Server\MSSQL.1 in the registry. BEREMOTE: [03/05/13 10:36:16] [1228] Found SOFTWARE\MICROSOFT\Microsoft SQL Server\MSSQL.1 in the registry. BEREMOTE: [03/05/13 10:36:16] [1228] Setting 2K5 extended feature bit. BEREMOTE: [03/05/13 10:36:16] [1228] AddESE_DLEs( ) BEREMOTE: [03/05/13 10:36:16] [1228] first load attempt of esebcli2.dll failed: The specified module could not be found. BEREMOTE: [03/05/13 10:36:16] [1228] Looking for esebcli2.dll in sysetm path BEREMOTE: [03/05/13 10:36:16] [1228] never found EseBcli2.dll BEREMOTE: [03/05/13 10:36:16] [1228] esebcli2.dll not loaded BEREMOTE: [03/05/13 10:36:16] [1228] EV_FindDrives BEREMOTE: [03/05/13 10:36:16] [1228] evFileSystem::RefreshTopology() BEREMOTE: [03/05/13 10:36:16] [1228] CEvServices::GetEVInstallPath : Could not find EV registry key. BEREMOTE: [03/05/13 10:36:16] [1228] CEvServices::GetEVInstallPath : Probably EV is not installed on this machine. BEREMOTE: [03/05/13 10:36:16] [1228] This EV version is not supported by Backup Exec. BEREMOTE: [03/05/13 10:36:16] [1228] evFileSystem::RefreshTopology: Failed while requesting XML. BEREMOTE: [03/05/13 10:36:16] [1228] evFileSystem::EV_FindDrives: RefreshTopology() failed. BEREMOTE: [03/05/13 10:36:16] [1228] Status 0x00000001 returned calling FindDrives for file system 37 in DLE_UpdateList BESERVER: [03/05/13 10:36:16] [3844] 01 Server Configuration: Client removed: 6 BESERVER: [03/05/13 10:36:16] [3844] -1 Client 'BACKUP2003' Disconnected:0x10ca370 BEREMOTE: [03/05/13 10:36:16] [1620] FS_ResolveDevName: [Server Farm 1 (SHAREPOINTTEST)] BEREMOTE: [03/05/13 10:36:16] [1620] MB2-Resolve returned 1 BEREMOTE: [03/05/13 10:36:16] [1620] Notes Agent:CLNFileSystem::ResolveDeviceName BEREMOTE: [03/05/13 10:36:16] [1620] ADC_ResolveDeviceName: pid = 1368, checking Server Farm 1 (SHAREPOINTTEST) BEREMOTE: [03/05/13 10:36:16] [1620] Inside evFileSystem::EV_ResolveDeviceName BEREMOTE: [03/05/13 10:36:16] [1620] Inside evFileSystem::IsGoodEVName BEREMOTE: [03/05/13 10:36:16] [1620] evFileSystem::IsGoodEVName: GoodEvName failed for (Server Farm 1 (SHAREPOINTTEST)) BEREMOTE: [03/05/13 10:36:16] [1620] evFileSystem::EV_ResolveDeviceName: IsGoodEVName failed for (Server Farm 1 (SHAREPOINTTEST)) BEREMOTE: [03/05/13 10:36:16] [1620] VRTSRV:DeviceName Server Farm 1 (SHAREPOINTTEST) BEREMOTE: [03/05/13 10:36:16] [1620] RPCDsSession::GetLoginCredentials: Connecting to BEM API as user: BACKUP2003\Administrator BESERVER: [03/05/13 10:36:16] [3344] -1 Client requested key (1362447526). BESERVER: [03/05/13 10:36:16] [3344] 01 Server Configuration: Client added: 7 BESERVER: [03/05/13 10:36:16] [3344] -1 Client 'BACKUP2003' connected('','BACKUP2003\Administrator'): 0x10c9190 BESERVER: [03/05/13 10:36:16] [3368] 01 Server Configuration: Client removed: 6 BESERVER: [03/05/13 10:36:16] [3368] -1 Client 'BACKUP2003' Disconnected:0x10c9190 BEREMOTE: [03/05/13 10:36:16] [1620] machine name = SHAREPOINTTEST BEREMOTE: [03/05/13 10:36:18] [1620] ERROR: e000feff Error: unknown error SharePoint Server: *************************************************************************** ***** SGMon log for \\SHAREPOINTTEST ***** *************************************************************************** BEREMOTE: [03/05/13 05:29:12] [3548] FS_ResolveDevName: [Server Farm 1 (SHAREPOINTTEST)] BEREMOTE: [03/05/13 05:29:12] [3548] MB2-Resolve returned 1 BEREMOTE: [03/05/13 05:29:12] [3548] Notes Agent:CLNFileSystem::ResolveDeviceName BEREMOTE: [03/05/13 05:29:12] [3548] Inside evFileSystem::EV_ResolveDeviceName BEREMOTE: [03/05/13 05:29:12] [3548] Inside evFileSystem::IsGoodEVName BEREMOTE: [03/05/13 05:29:12] [3548] evFileSystem::IsGoodEVName: GoodEvName failed for (Server Farm 1 (SHAREPOINTTEST)) BEREMOTE: [03/05/13 05:29:12] [3548] evFileSystem::EV_ResolveDeviceName: IsGoodEVName failed for (Server Farm 1 (SHAREPOINTTEST)) BEREMOTE: [03/05/13 05:29:12] [3548] VRTSRV:DeviceName Server Farm 1 (SHAREPOINTTEST) BEREMOTE: [03/05/13 05:29:12] [3548] FS_BlowOutMachine: entered -->Server Farm 1 (SHAREPOINTTEST)<-- BEREMOTE: [03/05/13 05:29:12] [3548] FS_BlowOutMachine: device already in DLE list BEREMOTE: [03/05/13 05:29:12] [3548] Could not resolve the "bews-ndmp" or the "ndmp" service, error code: 10109, using port 10000 BEREMOTE: [03/05/13 05:29:12] [3548] ndmpConnectEx: 'SHAREPOINTTEST' resolves to the local machine itself. So, we will try and connect to a loopback address ... BEREMOTE: [03/05/13 05:29:12] [3548] ndmpConnectEx : Control Connection information: A connection was established between end-points 127.0.0.1:1095 and 127.0.0.1:10000. BEREMOTE: [03/05/13 05:29:12] [2284] ndmpRun: Control connection accepted : connection established between end-points 127.0.0.1:10000 and 127.0.0.1:1095 BEREMOTE: [03/05/13 05:29:12] [3548] NDMP version 3 connection CONNECTED BEREMOTE: [03/05/13 05:29:13] [0000] BECryptoInit: BECrypto OpenSSL FIPS v1.1.1.0 mode successfully enabled. BEREMOTE: [03/05/13 05:29:13] [0000] BECryptoInit: BECrypto OpenSSL FIPS v1.1.1.0 mode successfully enabled. BEREMOTE: [03/05/13 05:29:13] [0232] LogonType set = [LOGON32_LOGON_INTERACTIVE][0x2] BEREMOTE: [03/05/13 05:29:13] [0232] LogonUser(LOGON32_LOGON_INTERACTIVE-0x2) success BEREMOTE: [03/05/13 05:29:13] [0232] Successfully impersonated SHAREPOINTTEST\Administrator BEREMOTE: [03/05/13 05:29:13] [0232] WhoAmI( ) reports: SHAREPOINTTEST\Administrator BEREMOTE: [03/05/13 05:29:13] [0232] LogonuserError: 0 BEREMOTE: [03/05/13 05:29:13] [3548] NDMPEngine::SetupNDMPConnection(): Using proxy authentication as requested BEREMOTE: [03/05/13 05:29:13] [0232] process ready? BEREMOTE: [03/05/13 05:29:14] [3548] GetTopology returned c27, from server SHAREPOINTTEST, as user SHAREPOINTTEST\Administrator BEREMOTE: [03/05/13 05:29:14] [3548] @@@@@@@MyCloseSocket called with sockfd = 1276(0x4fc) retval = 0 BEREMOTE: [03/05/13 05:29:14] [0232] @@@@@@@MyCloseSocket called with sockfd = 1224(0x4c8) retval = 0 BEREMOTE: [03/05/13 05:29:14] [3548] This server is NOT an SPS webserver, according to SHAREPOINTTEST BEREMOTE: [03/05/13 05:29:14] [3548] DSEnumerator failed with -536805633: The specified machine is not a SharePoint Server.
Solved
Bradley_Peatros
13 years ago Place Backup Exec
816Views
3likes
3Comments
Backup SharePoint Error since it needs SQL Server agent ?!?!?!!
Hi All, I'm having problem in backing up my SharePoint Server 2007 which is installed in one single server deployment with SQL Server 2008 as well here's the error log: ###################################################################################################################### Job ended: Thursday, May 27, 2010 at 11:00:17 PM Completed status: Failed Final error: 0xe000fe3c - Before you can back up this resource, you must purchase and install a license key for the appropriate Backup Exec agent. See Job Log for details. Final error category: Security Errors For additional information regarding this error refer to link V-79-57344-65084 ###################################################################################################################### Backup- MOSSDEV01.domain.comV-79-57344-65084 - Before you can back up this resource (MOSSDEV01.domain.com\MOSSDB), you must purchase and install a license key for the appropriate Backup Exec agent. For information about how to obtain a license key, go to the following URL: https://redirector.symantec.com?src=inpdt&pdt=be&action=t A selection on device \\MOSSDEV01.domain.com\Shadow?Copy?Components was skipped because of previous errors with the job. A selection on device \\MOSSDEV01.domain.com\System?State was skipped because of previous errors with the job. Verify Insufficient memory available. V-79-57344-33858 - A memory allocation request failed. The computer may be running low on virtual memory. ###################################################################################################################### Backup- MOSSDEV01.domain.comV-79-57344-65268 - AOFO: Initialization failure on: "MOSSDEV01.domain.com\MOSSDB". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS). V-79-10000-10896 - SQL Prepare for Freeze failed for snapshot. ###################################################################################################################### how can this happens ? I just want to backup my SharePoint but i have to purchase another agent for SQL Server 2008 ? can anyone help please ? Thanks
Solved
Symanticus
15 years ago Place Backup Exec
755Views
3likes
7Comments
Backup Exec 2012 health check guide
Hi, i'm a newbie to this backup exec 2012, and recently we have active contract on supporting this Backup Exec 2012. By supporting this, we need to perform health check or software preventive maintenance on the servers equipped with backup exec 2012 on quarterly basis. Just want to know that whether there are some guidelines or procedures/steps on what we need to include in the health check such as services, connections, patches? Please share with me if anyone know how to prepare a backup exec 2012 health check checklist in order to perform the preventive maintenance for the servers. Thanks
ericchong1syman
11 years ago Place Backup Exec
1.7KViews
2likes
5Comments
problem with backup sharepoint sql DB
hi using backup exec 2010 R3 SP4 to backup sharepoint sql server , server is 2003 R2 64bit sometimes the backup fails and i get this well knowen error ID 25 VOLSNAP on the server "The shadow copies of volume D: were deleted because the shadow copy storage could not grow in time. Consider reducing the IO load on the system or choose a shadow copy storage volume that is not being shadow copied." now i read many solutions on the web including moving the VSS Shadow copy to another disk and changing the MinDiffAreaFileSize in the registry both not help too much any good solution for that problem ?
asafno
11 years ago Place Backup Exec
234Views
2likes
0Comments
Regroup jobs of same type for severall servers
Hi all. I'm a pleased backup exec beta user. Since version 2010 my jobs to the same type of backup where separated because of version 2012 could do a single job to severall servers at the same time. So after severall weeks of good work with this last beta version that i'm using since beta program and i don't want any other i did a regroup to my SQL jobs for three servers to go on only one job. Let me explain. Server 1 Sql job 1 Server 2 Sql job 2 Server 3 Sql job 3 I hold it those three jobs and create a new job for servers:1,2,3 and the data to be backuped up is SQL server instance on wich of them. The same schedule that i had before wich is : Daily full backup at 22.00 and between 8.00 and 20.00 an incremental backup every 90 minutes. Now the issue: Only one of the servers, gives error wich is could not attach resource, and on the details i have that it couldn't connect to the SQL server instance. I'm using the same authentication as earlier the same network protocol and even the same NIC i checked that also, but only one server is unable to do the backup. On BE settings i have ports 10000 to 10031 to use to connect to servers, do i really need more...... Last to say, that the issue is on the incremental backup. The full backup works ok :) I have attached the settings of the sql job and the selection of the failed server.
Solved
RobRodrigues
11 years ago Place Backup Exec
593Views
2likes
5Comments
Again 0x80004005 - Unspecified error
Running Backup 2012 on w 2k8R2 64bit with followin patches: SP1, Hotfix 180964, 199866, 200433, 199190. no internet-access, no live-update. Article:TECH53004 is not applicable, because already done so. Still receive this error, but sometimes the bakcup is fine, next day backup failed. Is there any other solutions availabel? Can't believe I'm the only one recieving this error.
Solved
bandit61
12 years ago Place Backup Exec
2.1KViews
2likes
5Comments
Not following mount points, junction points message!
Hi, I am using a Dell Poweredge R710 connected to a Drobo 800i SAN that has the Deduplication drive configured to 4TB. I'm in the process of configuring BUE 2012 on all of our servers. When I am going through the job logs I noticed that even though I am getting reports showing completed and "Successful" backups to the Dedupe drive I get the following message on every "successful" job: Checkpoint restart cannot be applied to the following resource(s): System?StateBackup Exec will not follow mount points, junction points, and symbolic links when the Simplified Disaster Recovery indicator is ON. Drive and media mount requested: 1/22/2013 11:00:08 PM No appendable media could be mounted. Switching to overwrite operation on scratch media. 1) I want to use SRD on my Dedupe backups 2) Drobo is a recognized media for BUE - confirmed with Symantec and Drobo I have searched for answers (noticed someoen else getting told off for that in regards to this question- which was never answered.) I am also getting this error on other backup configured drives that are 1TB in size. Please note- the only other references I found references to tape and robotic media- and I do not use either. How do I eleiminate this error without eliminating the SRD? Thank you Ken
Ken_M
13 years ago Place Backup Exec
1.9KViews
2likes
6Comments
BE Agent backwards compatibility
I'm moving to a new BE2012 server from BE2010. Due to hardware issues (HBA needs to be moved from old server to new) and large number of servers, I'd like to upgrade the agents to 2012 incrementally and once they are all done, move the hba and start using 2012. Will 2012 Agents work with 2010, or will I have to do all the upgrades and move the HBA all at once?
Solved
Hans_A
13 years ago Place Backup Exec
1.3KViews
2likes
6Comments
Can't connect to SQL Default Instance
I have a SQL server that has 3 named instances and 1 default instance. I can connect to all of the named instances and back them up but not the default instance. The default instance is using not using the default port and I think I this is causing the problem. When I try to select the default instance I get a Browse Failure message saying that the Microsoft SQL Server does not appear to be running or network connections are preventing access to it. I have read a few articles for previous versions of BE and tried creating a .udl file to prove I can access the instance from the BE server which works correctly. The main thing I am coming acroos is that there is no way for BE to connect to a deafult instance that is running on a custom port, this is due to limitations in DBNETLIB. Is this the case or is there another way to backup my default instance?
jamespringle819
13 years ago Place Backup Exec
1.8KViews
2likes
8Comments