MSSQL 2008 server suddenly stopped backing up
MSSQL 2008 server suddenly stopped backing up. There are two database, they back up in the same (14:00) time, backup first database was successful, second no. After that moment both database have not backed up, in bpcd I didn't fount anything useful. where to find the problem?
Azure SQL Backup Failed with error 3829
Hi all, I have configured an azure sql backup with protection plan. But the backup get failed with error 3829. In the job detail I found the following error . ERR - 'sqlpackage' client utility does not exists on given host. Error: [Errno 2] No such file or directory: 'sqlpackage' ;Backup failed to backup the requested files I have installed the sqlpackage and unixODBC-2.3.7-1.rh.x86_64.rpm and msodbcsql17-17.10.2.1-1.x86_64.rpm in the media server. path for the sqlpackage utility is added to the path variables and the changed the permissions of the sqlpackage utility to the nbsvc user. Still I receive the same error.
Restore MS SQL transaktion logs to new database
Hi! We have recently started tests with Netbackup on SQL-servers as a way of both saving space and having a more versatile backup-environment, both for our DBAs and our backup team. My big problem is trying to restore a database with multiple transactionlogbackups to a different name, as I quite often need to compare data from various dates and times. I have been successfull restoring with the MOVE-template, but when I try to restore subsequent transactionlog-images, it just failes . This is the last entries from a log where I first restored the database to a different name with the move-template, and then (in the same script-file) tried to restore 3 transactionlog images. INF - Results of executing <C:\Temp\SbManageme.bch>: <1> operations succeeded. <3> operations failed. INF - The following object(s) were not backed up successfully. INF - ? INF - ? The database was created and is in recovering-mode, ready to receive transactionlogs, but I don´t understand how I can restore them. Is there a template available for situations like this? Where can I find that? Thanks!