Showing posts with label Admin Script. Show all posts
Showing posts with label Admin Script. Show all posts

Tuesday, 25 March 2014

Admin Script: Increase Service time out to start SQL Server Reporting Services

During SQL Server Installation, SQL Server Reporting Services fails to start for setup default configuration. Fortunately, it can be bypass by press 'Cancel'.

However, SSRS still fails to start manually and it always complain of timeout (default is 30000 = 30 seconds) as shown in below Event viewer.

Hence, the only solution is to increase the Service Timeout.

Have a great day

Monday, 6 January 2014

Admin Script: Backup SQL Server Databases with Week Of Month Timestamp

This is my collection of generic database backup script for SQL Server using SQLCMD.exe.

The purpose of the script is to backup SQL Server database in the Week Of Month format. The script is invoked via task scheduler to perform database backup (System and User database) weekly

This script consists of two files:
1. SqlServerBackup_WeekOfMonth.cmd
    Script to setup configuration and the script invocation from Task Scheduler

2. SqlServerBackup_WeekOfMonth.sql
    T-SQL Script to perform the database backup


This script works for SQL Server Database (Express or Full Version) from version 2008 and above.

If the setup is done properly, the final result is as follows:

Monday, 23 December 2013

Admin Script: Clean Up Users Folder

This admin script is created to help removing unneeded files such temp files and IE temp files to speed up the backup of users folder.

This admin script is created for Windows Vista and above and you need to run "Run as administrator".

Hope it help and please put comment to share other clean up path.

Thursday, 5 September 2013

Admin Script: ADDS DsTools to append user attribute value "IPTel/ipPhone"

My friend requested me on script to help mass appending update value to user attribute "IPTel" (ipPhone) as shown on below screenshot.