Cannot Do log restores
bkan
Posts: 4 New member
in SQL Backup
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
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
