02-03-2011 09:25 AM
Hi,
I've got a problem with Backup Exec 2010 trial version.
When I backup a virtual machine running SQL 2008 server with the agent for vmware virtual infrastructures
and SQL agent licensed (trial version) every thing goes fine. But when I try to restore for example one SQL database
I must notice that all databases are with a size of 9KB and I am not able to restore a database.
Instead when I make a backup with the normal SQL agent every thing is fine.
I can restore the databases and they also have there normal size.
Any idea whats going wrong there?
Regards, Tobi
02-03-2011 06:12 PM
May I know where are the backups taken.... Disk or Tape?? If the backups are taken to Tape, please try to duplicate the data to disk and then try the restore of SQL Database and see if it is acting the same way.
Thanks,
-Sush...
02-03-2011 11:42 PM
Hello Sush,
the backups are taken to disk...
Any other idea?
Thanks, Tobi
02-03-2011 11:45 PM
Are there any Exceptions (in orange colour) in the Job log of the backup job.??
Thanks,
-Sush...
02-03-2011 11:50 PM
no, absolutely a clear job without failures
02-07-2011 10:00 AM
Hi
Can you please update the job log for the restore which is failing & also the snap of selection for incremental which shows 9kb
Also please answer the following questions below
Will wait for update
Thank You
02-08-2011 08:23 AM
Thank you for your reply.
I get no restore job log because already when I want to define my restore job I get the error.
My system is running german language and I try to translate to english (and also give screenshots).
When I have choosed my database to restore (9KB or now 11KB) in the restore job and then try to "Check selection" under "Microsoft SQL-Redirect" I get the error "The restore selections don't include SQL server selections"
1. Version of SQL
-> SQL 2008 R2 Express
2. What type of Disks does the VM Carry, Thick, Thin?
-> Thick
3. What Type of DataStore for the location of the VMDKs?
-> SAN with RAID 10
4. How is the DataStore connected to the ESX Server?
iSCSI, Fibre, Local?
-> Fibre
6. Is the backup going through the VC or ESCX? ESX
-> VC
7. If a backup is done with the alternative, (CV or ESX) will the restore work?
-> no
8. Is it the only SQL server in the Env?
Does a backup / restore work for another SQL ServeR?
-> there are more SQL Servers but not working for any.
02-08-2011 08:34 AM
Hi
Could you please update the job log also for your sql backup
Thank You
02-09-2011 04:50 AM
Sorry, I can't understand what you want me to do !?!?
02-09-2011 04:53 AM
Hi
Can you post the job log for the full backup & incremntal backup you have performed
Thank You
02-09-2011 07:24 AM
Ok thanks, here ist the log of the backup:
Auftragsprotokoll: BEX_BACKUP_00069.xmlAuftragsprotokoll für Test
Abschlussstatus: Erfolgreich
Alle einblendenAlle ausblenden
Auftrag - Informationen
Auftragsserver: BACKUP
Auftragsname: Test
Auftrag gestartet am Dienstag, 8. Februar 2011 um 15:32:37
Auftragstyp: Sichern
Auftragsprotokoll: BEX_BACKUP_00069.xml
Laufwerk und Laden von Medium angefordert: 08.02.2011 15:32:37
Geräte und Medien - Informationen
Laufwerks- und Medieninformationen von Medienladevorgang: 08.02.2011 15:32:38
Laufwerkname: ecs Sicherung Backup-to-Disk
Medienkennung: B2D000005
Medien-GUID: {f083bb02-a104-4d7d-b8b3-b3c22af6ef76}
Überschreibschutz bis: 08.02.2011 16:32:38
Anhängbar bis: 31.12.9999 01:00:00
Name des Ziel-Mediensatzes: ecs Backup-to-Disk
Alle verwendeten Medien
B2D000005
IMG000050
Auftragstyp - Sichern
Sicherungsoptionen
Medienvorgang - Medium überschreiben.
Komprimierungstyp: Hardware [falls vorhanden, sonst keine]
Verschlüsselungstyp: Keine
Server - BACKUP
Satz - Informationen -
VMVCB::\\BACKUP\VCGuestVm\(DC)ecs(DC)\vm\adserver
Sichern Satz - Informationen
Familienname: "Medium erstellt am 08.02.2011 um 15:32:37"
Backup von "VMVCB::\\BACKUP\VCGuestVm\(DC)ecs(DC)\vm\adserver"
Backup-Satz Nr. 1 auf Speichermedium Nr. 1
Beschreibung des Backup-Satzes: "Test"
Backup-Methode: Vollständig - Virtuelle Computer sichern
Die Option zum Wiederherstellen einzelner Dateien und Ordner aus dem Backup eines virtuellen Computers war für dieses Backup ausgewählt.
Remote Agent for Windows Systems muss auf dem virtuellen Computer installiert sein, damit die Granular Recovery Technology zur Datenwiederherstellung verwendet werden kann.
Backup begonnen am 08.02.2011 um 15:33:40.
Sichern Satz - Detaillierte Informationen
Medienkennung: IMG000050
GRT-Backup-Satzordner: Z:\ecs Sicherung Backup-to-Disk\IMG000050
Transportmodus "san" für Datenträger "adserver.vmdk" verwendet
Backup Exec hat "C:" auf dem virtuellen Computer "\\ADSERVER.ecs.local" erkannt und geschützt.
Backup Exec hat Microsoft SQL Server-Daten auf dem virtuellen Computer "\\adserver.ecs.local" erkannt und geschützt.
Backup Exec hat Microsoft SQL Server-Daten auf dem virtuellen Computer "\\adserver.ecs.local" erkannt und geschützt.
Backup abgeschlossen am 08.02.2011 um 15:37:46.
Sichern Satz - Zusammenfassung
35507 Dateien in 6186 Verzeichnissen gesichert.
1 virtuelle Computer gesichert
1 Datenträger von virtuellem Computer gesichert
10.390.262.867 Byte verarbeitet in 4 Minuten und 6 Sekunden.
Durchsatzrate: 2417 MB/Min.
Komprimierungstyp: Keine
Auftragstyp - Überprüfen
Server - BACKUP
Satz - Informationen -
VMVCB::\\BACKUP\VCGuestVm\(DC)ecs(DC)\vm\adserver
Überprüfen Satz - Informationen
Überprüfen von "VMVCB::\\BACKUP\VCGuestVm\(DC)ecs(DC)\vm\adserver"
Backup-Satz Nr. 1 auf Speichermedium Nr. 1
Beschreibung des Backup-Satzes: "Test"
Überprüfung begonnen am 08.02.2011 um 15:37:48.
Überprüfung abgeschlossen am 08.02.2011 um 15:40:18.
Überprüfen Satz - Zusammenfassung
0 Dateien in 0 Verzeichnissen überprüft.
1 virtuelle Computer überprüft
1 Datenträger vom virtuellen Computer überprüft
10.390.262.867 Byte verarbeitet in 2 Minuten und 30 Sekunden.
Durchsatzrate: 3964 MB/Min.
Auftragsabschlussstatus
Auftrag beendet am Dienstag, 8. Februar 2011 um 15:40:19
Abschlussstatus: Erfolgreich
02-09-2011 07:27 AM
Hi
Instead of posting like this please go to job monitor & then open the full backup job & then go to job log & click on expand all & do same for your incremental backup job too & once both the job log are saved please attach them & then post it here
thank you
02-10-2011 12:51 AM
Sorry, I am still a little bit confused.
I have no explicit full and incremental backup. I only selected the full virtual machine in my backup job over "VMware vCenter- and ESX-Server". Now I try againt to attach the backup log file as a zipped html file or in which format should I attach it?
Thank you very much for your patience.
Tobi
02-11-2011 06:59 AM
Hi
Thanks for your earlier log & I request you to please do the following on backup server & on virtual SQL server & then run the restore & update me with the logs
Once the restore of incremental fails please go to C-program file-symantec-backupexec-logs folder on media server & sql server & please update me with beremote & bengine log created
I will wait for the attachement
Thank You
02-14-2011 05:43 AM
Hi,
thanks again for your reply.
Until my last post I haven't ever tried a restore because of the failure "The restore selections don't include SQL server selections", I got in the definition of the restore job, mentioned in my fourth post.
Trying to do a restore was succesful...
I was confused by the failure message and by the displayed size of the database.
An other problem I can see is, that the restore from B2D only goes with about 6MB/sec to my virtual SQL server on my SAN althought the backup goes with about 3000MB/sec.
Thanks, Tobi