Change TFS Database to other server

Por -
To change TFS Database to other server:

# Preview

Note: You can use the /preview at the end to display the actions that you must take to update the configuration. This just shows a preview of what is to be done.

# Stop IIS/TFS

iisreset /stop -> Stop IIS
net stop TfsJobAgent -> Stop TFS Job Agent

# Backup SQL Databases

# Restore SQL Databases

# Prepare SQL Server for Team Foundation Server - For Old versions

TFSConfig PrepSQL /SQLInstance: ServerName\InstanceName

# Remap DB to other server
 
TFSConfig RemapDBs /DatabaseName:ServerName\Instance;Tfs_Configuration /SQLInstances:ServerName\Instance

# Change the Ownership of the Restored Databases

TFSConfig Accounts /ResetOwner /SQLInstance:ServerName\Instance /DatabaseName:Database

# Register the Location of the Restored Databases if You Are Not Restoring the Application Tier

TfsConfig registerDB /SQLInstance:ServerName\Instance /DatabaseName:Database

# Start IIS

iisreset /start -> Start IIS

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Cisco router password recovery

Por -
1) Press Break on the terminal keyboard a couple of times after you see the message program load complete, entry point: 0x80008000, size: 0x6fdb4c in order to put the router into ROMMON. 2) Type confreg 0x2142 at the rommon 1> prompt in order to boot from Flash. This step bypasses the startup configuration where the passwords are stored. 3)  Type reset at the rommon 2> prompt. The router reboots, but ignores the saved configuration. 4)  Type no after each setup question, or press Ctrl-C in order to skip the initial setup procedure. 5)  Type enable at the Router> prompt. You are in enable mode and should see the Router# prompt. 6)  Type   configure memory   or copy startup-config running-config in order to copy the nonvolatile RAM (NVRAM) into memory. 7)  Type show running-config. The passwords (enable password, enable secret, vty, and console passwords) are in either an encrypted or encrypted format. You can reuse ir change. 8)  Type configure terminal. The hostname (conf
Leia mais