DevOps Technology Blog | SQL Server

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

by XDK 15. March 2016 09:50

Exception:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. For more information about this error navigate to the report server on the local server machine, or enable remote errors

Workaround:

Changing the data files 'auto growth' property from restricted to unrestricted resolved the issue.

  • Connected to the database server thru Microsoft SQL Server Management Studio
  • Right click on the database
  • Select properties
  • Select files
  • Click on ellipses buttons
  • Select "unrestricted File Growth"
  • Click OK

 

Tags:

SQL Server | SQL Analysis Services | SQL Reporting Services

How do I perform full backup of a TFS database without affecting the scheduled backups?

by XDK 20. October 2015 13:48

Solution:

You can perform a Copy-Only backup in SQL Server. A Copy-Only is a SQL Server backup that is independent of the sequence of conventional SQL Server backups.

  • Open SQL Server Management Studio
  • Right Click on the TFS database you want to backup
  • Select Tasks --> Back Up... menu

 

  • On the General page of the Back Up Database dialog box, select the Copy Only Backup option.

 

  • Click OK

Tags:

SQL Server

How to perform an in-place upgrade from SQL Express to SQL Server other editions?

by XDK 17. July 2015 09:28

Solution:

1. Open Command prompt with "Run as Administrator" permission

2. Change directory to your SQL server setup/install folder

3. Execute the follwoing command

setup /ACTION=editionupgrade /INSTANCENAME=SQLEXPRESS /PID=XXXXX-XXXXX-XXXXX-XXXXX

  • INSTANCENAME - Existing SQL EXPRESS instance you want to upgrade
  • PID - Product Key

Tags:

SQL Server

Performance decreases in TFS 2013 Update 2 after you upgrade to SQL Server 2014

by XDK 11. January 2015 15:14

Explanation:

These issues occur because the hardware requirements for SQL Server 2014 are greater than those for earlier versions of SQL Server. 

Work Around:

Work Around link

Tags:

Team Foundation Server | SQL Server | TFS 2013

How to delete orphan workspaces and shelvesets from TFS team collection database?

by XDK 20. December 2013 07:17

Todeleteorphanworkspaces.sql (2.93 kb)

 

To delete orphan workspaces.sql (2.93 kb)

Explanation:

Deleting a team project through tfsdeleteproject command will result making the associated workspaces and shelvesets as orphan records in TFS collection database. The collection database size may not reduce as expected even after team project delete. 

tfsdeleteproject /force /q /excludewss /collection:"<Collection Name>" "<Project Name>"

Solution:

The attached script finds and deletes the workspaces\shelvesets that only have workspace\shelvesets mappings for projects that no longer exist and delete them. 

Please backup the collection database before you execute the script.

This script require TFS 2012 update 2 or newer

To delete orphan workspaces.sql (2.93 kb)

To delete orphan shelvesets.sql (2.58 kb)

Tags:

Team Foundation Server | SQL Server

About the author

My name is Xavier Dilip Kumar Jayaraj having 13+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

DevOps Tools

ALM tools:
Azure DevOps
IBM Rational
CA Agile Central-Rally
CollabNet VersionOne

Configuration tools:
• Puppet
• CHEF
• AWS OpsWorks
• Ansible

Build automation tools:
Apache Ant 
Apache Maven
Boot
Gradle
Grunt
MSBuild
Waf

Continuous Integration tools:
Bamboo
Buildbot
Hudson
TeamCity

Testing tools:
Selenium
Watir
Wapt
ApacheJMeter
QTest

Version control system tools:
Subversion
Team Foundation Server
GIT
Mercurial
Perforce

Code review tools:
Crucible
Gerrit
GitHub
Bitbucket Server

Continuous Delivery/release management tools:
XL Release
ElectricFlow
Serena Release
Octopus Deploy