Onde achar o Backup?
03/05/2017
0
Bom dia a todos,
Nao estou achando o backup de um BD, memmo tudo informando que o backup foi feito.
Olhem so onde olhei: Log Sql Server
Date 2017-05-02 19:00:55
Log SQL Server (Current - 2017-05-03 09:36:00)
Source Backup
Message
Database backed up. Database: NOME_DO_BD, creation date(time): 2014/09/19(12:59:00), pages dumped: 5781169, first LSN: 4403:173882:1, last LSN: 4403:173885:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{95F31BA9-5CED-481B-A83A-8A272DF32470}3'}). This is an informational message only. No user action is required.
Fiz um select para saber onde acho esse VIRTUAL_DEVICE.
---Find Physical device
SELECT d.name, MAX(b.backup_finish_date) AS last_backup_finish_date, max(physical_device_name) AS physical_device_name
FROM master.sys.databases d WITH (NOLOCK)
LEFT OUTER JOIN msdb.dbo.backupset b WITH (NOLOCK) ON d.name = b.database_name AND b.type = 'D'
LEFT OUTER JOIN msdb.dbo.backupmediafamily c WITH (NOLOCK) ON b.media_set_id = c.media_set_id
WHERE d.name <> 'tempdb'
GROUP BY d.name
ORDER BY 2
Resultado:
NOME_DO_BD 2017-05-02 19:00:55.000 E:\\MSSQL\\Backup\\FULL_(local)_NOME_DO_BD_20140919_103925.sqb
Me conectei a maquina e fui no diretorio. Nao e nao existe nada. Sera que teria alguma ideia?
Quando tento restaurar, fala que a midia é falha. Sera que tem um problema no backup, mesmo com todoas mensagem falando que foi tudo executado com sucesso?
Abracos,
Bruno Cunha
Nao estou achando o backup de um BD, memmo tudo informando que o backup foi feito.
Olhem so onde olhei: Log Sql Server
Date 2017-05-02 19:00:55
Log SQL Server (Current - 2017-05-03 09:36:00)
Source Backup
Message
Database backed up. Database: NOME_DO_BD, creation date(time): 2014/09/19(12:59:00), pages dumped: 5781169, first LSN: 4403:173882:1, last LSN: 4403:173885:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{95F31BA9-5CED-481B-A83A-8A272DF32470}3'}). This is an informational message only. No user action is required.
Fiz um select para saber onde acho esse VIRTUAL_DEVICE.
---Find Physical device
SELECT d.name, MAX(b.backup_finish_date) AS last_backup_finish_date, max(physical_device_name) AS physical_device_name
FROM master.sys.databases d WITH (NOLOCK)
LEFT OUTER JOIN msdb.dbo.backupset b WITH (NOLOCK) ON d.name = b.database_name AND b.type = 'D'
LEFT OUTER JOIN msdb.dbo.backupmediafamily c WITH (NOLOCK) ON b.media_set_id = c.media_set_id
WHERE d.name <> 'tempdb'
GROUP BY d.name
ORDER BY 2
Resultado:
NOME_DO_BD 2017-05-02 19:00:55.000 E:\\MSSQL\\Backup\\FULL_(local)_NOME_DO_BD_20140919_103925.sqb
Me conectei a maquina e fui no diretorio. Nao e nao existe nada. Sera que teria alguma ideia?
Quando tento restaurar, fala que a midia é falha. Sera que tem um problema no backup, mesmo com todoas mensagem falando que foi tudo executado com sucesso?
Abracos,
Bruno Cunha
Bruno Cunha
Curtir tópico
+ 0
Responder
Posts
03/05/2017
Bruno Cunha
Apenas outra informacao: Quando tento abrir fazer o retore do backup. Olha so o erro que peguei no event viewer do Windows.
+ System
- Provider
[ Name] MSSQLSERVER
- EventID 18204
[ Qualifiers] 49152
Level 2
Task 2
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-05-03T19:14:30.000000000Z
EventRecordID 280158
Channel Application
Computer xxxxx.xxxxxxx.com
- Security
[ UserID] S-1-5-21-3664346857-1087292617-3713493073-465406
- EventData
BackupDiskFile::OpenMedia
E:\\MSSQL\\Backup\\{95F31BA9-5CED-481B-A83A-8A272DF32470}3
open
2(The system cannot find the file specified.)
1C470000100000000F00000043005100430042004F00550031005700560050004400570030003300000000000000
--------------------------------------------------------------------------------
Binary data:
In Words
0000: 0000471C 00000010 0000000F 00510043
0008: 00420043 0055004F 00570031 00500056
0010: 00570044 00330030 00000000 0000
In Bytes
0000: 1C 47 00 00 10 00 00 00 .G......
0008: 0F 00 00 00 43 00 51 00 ....C.Q.
0010: 43 00 42 00 4F 00 55 00 C.B.O.U.
0018: 31 00 57 00 56 00 50 00 1.W.V.P.
0020: 44 00 57 00 30 00 33 00 D.W.0.3.
0028: 00 00 00 00 00 00 ......
+ System
- Provider
[ Name] MSSQLSERVER
- EventID 18204
[ Qualifiers] 49152
Level 2
Task 2
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-05-03T19:14:30.000000000Z
EventRecordID 280158
Channel Application
Computer xxxxx.xxxxxxx.com
- Security
[ UserID] S-1-5-21-3664346857-1087292617-3713493073-465406
- EventData
BackupDiskFile::OpenMedia
E:\\MSSQL\\Backup\\{95F31BA9-5CED-481B-A83A-8A272DF32470}3
open
2(The system cannot find the file specified.)
1C470000100000000F00000043005100430042004F00550031005700560050004400570030003300000000000000
--------------------------------------------------------------------------------
Binary data:
In Words
0000: 0000471C 00000010 0000000F 00510043
0008: 00420043 0055004F 00570031 00500056
0010: 00570044 00330030 00000000 0000
In Bytes
0000: 1C 47 00 00 10 00 00 00 .G......
0008: 0F 00 00 00 43 00 51 00 ....C.Q.
0010: 43 00 42 00 4F 00 55 00 C.B.O.U.
0018: 31 00 57 00 56 00 50 00 1.W.V.P.
0020: 44 00 57 00 30 00 33 00 D.W.0.3.
0028: 00 00 00 00 00 00 ......
Responder
Clique aqui para fazer login e interagir na Comunidade :)