SQL

118 Topics

Restore SQL to file?
is it possible to restore a database out in a file, instead of direct to another Sql server?
Solved
Emort
12 years ago Place Backup Exec
4.3KViews
3likes
2Comments
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
747Views
3likes
7Comments
What is in the BFK files
Hello everyone, We use backup Exec 2010 for backingup from 4 servers. Last night an differential job, using modified time ran. When I checked the status of the backup this morning, I came to the conclusion that the size of the created bkf file whas 5GB. This should be a lot more. Can someone explain how to check the data inside the BKF files? I'm really curious about the data that is backupped and what is not. Thanks in advance!
Solved
Roy_T
12 years ago Place Backup Exec
3.1KViews
2likes
9Comments
sql backup failure
I have updated Backup Exec 2012. I have several backup jobs, both SQL (Server and Express) as files. A job in question, if SQL Express 2008, generates fault. The configuration is equal to the other SQL jobs. The following error: -------------------------------------------------- -------------- Completed status: Failed Final error: 0xe0008492 - Database Query Failure. See the job log for details. Final error category: Resource Errors For additional information Regarding this error refer to link V-79-57344-33938 -------------------------------------------------- -------------- V-79-65323-3201 - An error occurred on a query to database RMS. V-79-65323-3201 - Can not open backup device 'RMS_00__7e694887_9e14_4492_98d5_97cb2159c40b_'. Operating system error 0x80070005 (Access is denied.). -------------------------------------------------- -------------- I await possible solution
Solved
Wilson_Sells
12 years ago Place Backup Exec
2.1KViews
2likes
10Comments
After upgrading to BE 2012 Sharepoint jobs fails, Access Denied.
Hi After upgrading and thenreinstalling BE 2012 my Sharepoint 2007SP3jobs failes. Much like the old http://www.symantec.com/business/support/index?page=content&id=TECH163882, fixed in 2010R3 SP2. Completion status: Failed Final error: 0xe0001602 - Access is denied (Share point backup). Final error category: Security Errors For additional information regarding this error refer to link V-79-57344-5634 This Exception may also show up: Backup- Sharepoint - 80\Content-DB1 (SERVERNAME\SHAREPOINT\WSS_Content) When I create the job the Test credentials check out OK, all passes. But the the job runs and it failes, when I the go in and check the credentials again they failed. Any one else with this problem? Solution? regards Robert
Robert_Eriksson
13 years ago Place Backup Exec
1.5KViews
2likes
11Comments
Backup Exec 2010 R2 crash ?
Hi Everyone, Has anyone here ever crash their Backup Exec 2010 R2 media server 64bit while scheduling the backup job ? mine just crashed and i lost all of the settings, here's what I can get from the displayed popo up messagebox: External component has thrown an exception. at BackupExec.UI.BEDlgs.ShowDialogWithAdamm(Int32 dialogId) at BackupExec.UIFramework.CommandManager.a(Object A_0, EventArgs A_1) at System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FDoIdle(Int32 grfidlef) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at BackupExec.UI.MainForm.a(String[] A_0) at BackupExec.UI.MainForm.b(String[] A_0) any explanation and suggestion would be greatly appreciated. Thanks.
Solved
Symanticus
14 years ago Place Backup Exec
1KViews
2likes
6Comments
Cannot select Blackberry Enterprise Server Express SQL instance in a selection list
I have installed BES Express and I am trying to backup the configuration database. I can see the database instance in the selection list but when I try to select it i get the following error: "An error was encountered while attempting to browse the contents of SERVER\BLACKBERRY. A network connection to the server could not be established." I am using Backup Exec 10D and BES Express is installed on the same server. I have installed BES Express for other clients with similar setups and I have had no problems with backups. Any help would be appreciated. Thanks.
Solved
Edward_Charles
14 years ago Place Backup Exec
706Views
2likes
6Comments
Adamm Database Event: Database Connection Lost!
Hi all, On the server application log, i encountered such an event which i couldn't find much info as to why and how to resolve this. Adamm Database Event: Database Connection Lost! Error = E_PVL_DB_LOST_CONNECTION Server = “computername” Active Node = “” Instance = “BkupExec” Database = “BEDB” Connection String = “DRIVER=SQL Server;SERVER=computername\BkupExec;DATABASE=DEDB; App=DEWS PVL" The database is installed on the same machine so i suppose it couldn't be a network failure which causes this as shown from the article below. http://www.symantec.com/business/support/index?page=content&id=TECH87166 Can anyone help me? Thanks.
Solved
Qingyan_Lim
12 years ago Place Backup Exec
3.1KViews
1like
10Comments
Duplication to Tape
Good morning, I have configured a backup job to perform a backup of our SQL server, C: D: E: F: All SQLDatabases and the system state. It goes to DeDuplication Disk Storage then to tape once complete. When this runs the duplication to tapepart of the job it only copies the System state then ends the jobs. (16GB out of 550GB) Any clues? Lee
leeweedon
12 years ago Place Backup Exec
1.4KViews
1like
7Comments
Using SQL 2012 for Backup Exec 2012 database?
Hi, the SCL for Backup Exec 2012 contain on site 20 SQL Server 2012 for using for theBEDB. But when I install BE2012 it says this: The instance is default instance on the same server using SQL 2012 Enterprise Edition. The service account have full sysadmin-sql and domain-admin rights. Anyone tried this before? What I have to do? Thanks!
ksattler
13 years ago Place Backup Exec
1.4KViews
1like
11Comments