What are the challenges you face when working across database platforms? Take the survey
Options

Cannot Do log restores

bkanbkan Posts: 4 New member
Heloo,
All i was satisfied with the way we used to do backup using SSMS. Since we brought this tool its a nightmare. We are using sqlbackup 9.0 for backups and restores. Issue started on march 19th midnight where the backup were not copied to shared file servers. After that it says we are not restoring from the oldest LSN file (we did that as well). Now restore job runs with warning about orphan users and we see 0GB restored. In the job i found this
RESTORE LOG [SQL_01_DBNAME] FROM DISK = '\\BACKUPFILESVRLOC\LogShipping\IDBNAME\LOG_PLTFLOOR_*.sqb' WITH ERASEFILES = 10, FILEOPTIONS = 1, MAILTO_ONERRORONLY = 'itsupport@SUPPORT.COM', STANDBY = 'K:\SQL Server Backup\LogShipping\IDBNAME\Undo_IPLTFLOOR.dat', DISCONNECT_EXISTING, MOVETO = 'K:\SQL Server Backup\LogShipping\SQL01\Processed'

In the above command the .dat file is missing, how can i get that back?
Thanks
Sign In or Register to comment.