How to purge when there is a torn page in the SQL DB

0 Likes

Problem:

How to purge when there is a torn page in the SQL DB

Resolution:

  • Product Name: StarTeam
  • Product Version: 2005 R2, 2006
  • Product Component: Server
  • Platform/OS Version: Windows 2000, Windows 2003

Description:
How to purge when there is a torn page in the SQL DB


Answer/Solution:

Resolution to this problem is to migrate the database using Server Administration tool. Launch the Server Administration GUI tool, shutdown the ST server and go to menu bar Actions--->Migrate. Idea is to create new configuration (recreate pure database instance) based on existing one to rectify the structural problems in db data files.

Once the new configuration is successfully created, you the Purge the database.




Author: Praveen Boyineni

Old KB# 27471
Comment List
Related
Recommended