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

Convert physical disk (GPT) to VHDx

Por -
How to do it: Use Disk2vhd to create a VHDX (or VHD, but I recommend VHDX) from your physical disk - it doesn't really matter which drives you check/uncheck as long as your Windows drive is checked. Create a Gen2 VM in Hyper-V and attach the new VHDX and your choice of Windows installation media (DVD or VHD). Boot the VM (it shouldn't matter what's listed first under the Firmware tab - it'll likely boot from your installation media anyway since your VHDX doesn't work yet). Hit Shift+F10 to bring up the Command Prompt (or click through troubleshooting buttons to the Command Prompt). Type "diskpart" and hit Enter. Type "list vol" and hit Enter - note the drive letter of your Windows volume (most likely the largest option), as well as which volume says Raw next to it. Type "sel vol #" where "#" is the number of the volume that says Raw next to it (this is the reason your VHDX doesn't "just work" when Disk2vhd has co...
Leia mais

How to Enable SSH on Cisco Switch, Router

Por -
1) Generate the RSA Keys      myswitch(config)# crypto key generate rsa             The name for the keys will be: myswitch.mydomain.com          How many bits in the modulus [512]: 1024      % Generating 1024 bit RSA keys, keys will be non-exportable...[OK] 2) Setup the Line VTY configurations     # line vty 0 4      (config-line)# transport input ssh     (config-line)# login local     (config-line)# password 7     (config-line)# exit 3) Setup the Console configuration      # line console 0      (config-line)# logging synchronous      (config-line)# login local 4) Verify SSH access      myswitch# sh ip ssh           SSH Enabled - version 1.99           Authentication timeout: 120 secs; Authentication retries: 3 That's it...
Leia mais