SQL server has died and i cant recover data from net backup
Hi,
I'm wondering if anyone can shed any light on a issue I'm having, We has a very old physical server win 2003 with sql 200 installed which has died, I need to recover from backup and I have followed the best practiced recovery sql guide from veritas but I keep getting the following.
- begin Restore
14/07/2016 21:31:21 - Info dbclient(pid=753580) INF - RESTORE STARTED USING
14/07/2016 21:31:21 - Info dbclient(pid=753580) Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
14/07/2016 21:31:21 - Info dbclient(pid=753580) Dec 10 2010 10:56:29
14/07/2016 21:31:21 - Info dbclient(pid=753580) Copyright (c) 1988-2005 Microsoft Corporation
14/07/2016 21:31:21 - Info dbclient(pid=753580) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
14/07/2016 21:31:21 - Info dbclient(pid=753580) Batch = C:\qpulse.bch, Op# = 1.
14/07/2016 21:31:21 - Info dbclient(pid=753580) INF - Using backup image samoa.MSSQL7.SAMOA.db.QPulse5.~.7.001of001.20160713190209..C
14/07/2016 21:31:21 - Info dbclient(pid=753580) INF - restore database "QPulse5" from VIRTUAL_DEVICE='VNBU0-753580-738588-1468528281' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'QPulse5' to 'E:\Restore\QPulse5.mdf', move 'QPulse5_log' to 'E:\Restore\QPulse5_log.LDF', replace
14/07/2016 21:31:21 - Info dbclient(pid=753580) INF - Number of stripes: 1, Number of buffers per stripe 2.
14/07/2016 21:31:21 - Info dbclient(pid=753580) ERR - Error in CoCreateInstance: 0x80040154.
14/07/2016 21:31:21 - Info dbclient(pid=753580) CONTINUATION: - An attempt was made to reference a token that does not exist.
14/07/2016 21:31:23 - Info dbclient(pid=753580) INF - OPERATION #1 of batch C:\qpulse.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2(2) seconds.
14/07/2016 21:31:25 - Info dbclient(pid=753580) INF - Results of executing <C:\qpulse.bch>:
14/07/2016 21:31:25 - Info dbclient(pid=753580) <0> operations succeeded. <1> operations failed.
Can someone advise me what is failing here any help is welcolmed as Im fresh out of ideas.
Regards
Chris
