Posts

Showing posts from March, 2014

Get the password used in a SQL Job that launch an SSIS password protected package

Image
On MS SQL Server 2008 R2 (and maybe other versions) : Simply right-click on the job and select the option Script Job as > CREATE To > New Query Editor Window The password will be written in the SQL query.

Resolve the error "Service Temporarily Unavailable" on Belgacom e-services My Bill & Usage

If you get the error message "Service Temporarily Unavailable" when you connect to the e-services administration, you can simply change the email address used as your login and that should do the trick.

Check the reason why Synology Network Backup failed

If you have encountered errors with the Synology Network Backup and that the log message is as vague as Network Backup failed to backup task [xxx] to [xxxx.synology.me]. ([23] Some files could not be transferred. Possible reasons: 1) backup user has no permission to access the files, 2) illegal file name. 3) file name too long) and you want to get more information about the error, simply connect to the console and open the file /var/log/rsync.error 

Restore Synology network backup after nas migration

Image
If you have changed the source server of a network backup, you may follow these steps in order to recover your backups without the need to transfer again all your files through the network : Connect to the target (backup) server Go in the NetBackup folder Go in the folder you want to recover (you may rename it if you wish) Delete all files at the root of this folder (not the subfolders) Go in the @app folder Delete all files at the root of this folder (not the subfolders) Create the backup task using the same target folder name as previously. You may receive an error message: "The operation failed.  Please login to DSM again and retry". Simply ignore it. Run the backup task Take care that if you have set a new user to the backup task on your target (backup) server since the last backup has been made. You have to ensure that the access rights for this new user are consistent along the whole folders' tree (use chown -R or check the corresponding checkbo