Autodesk 46304-050008-1600A Implementation Guide - Page 65

Upgrade Microsoft SQL, Method One

Get Autodesk 46304-050008-1600A - Vault R4 Essentials Aotc PDF manuals and user guides
UPC - 606121640691
View all Autodesk 46304-050008-1600A manuals
Add to My Manuals
Save this manual to your list of manuals

Page 65 highlights

Method One 1 Open a command prompt and navigate to the directory where the full version of SQL setup is located. 2 Enter "setup.exe SKUUPGRADE=1" (case sensitive). 3 Start the upgrade and select the AutodeskVault instance. 4 After the upgrade is complete, apply the latest SQL service pack since this upgrade actually does not have on and it is not transferred from SQL Express. Method Two 1 Create a full backup of your vault using the server console. NOTE In later steps, you delete all your vault databases. Validate that you can restore this backup on a test server before proceeding. Do not continue if your test restore fails. Correct any problems you have with the backup before continuing these steps. 2 After the test restore is successful, open the ADMS Console and delete all vaults and libraries listed. Then select Detach Master Vault from the Tools menu. 3 Make sure that all users are logged out of the vault. 4 Completely uninstall SQL Express, including the following applications in this order: ■ Microsoft SQL Server NOTE If you have more than one instance of SQL Express installed, be sure to uninstall only the AutodeskVault instance. DO NOT uninstall any other part of SQL after this step is complete. ■ MS SQL Server Native Client ■ MS SQL Server VSS Writer ■ MS SQL Server 2005 Backward Compatibility ■ MS SQL Server Setup Support Files Upgrade Microsoft SQL | 59

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
Method One
1
Open a command prompt and navigate to the directory where the full
version of SQL setup is located.
2
Enter
“
setup.exe SKUUPGRADE=1
”
(case sensitive).
3
Start the upgrade and select the AutodeskVault instance.
4
After the upgrade is complete, apply the latest SQL service pack since this
upgrade actually does not have on and it is not transferred from SQL
Express.
Method Two
1
Create a full backup of your vault using the server console.
NOTE
In later steps, you delete all your vault databases. Validate that you
can restore this backup on a test server before proceeding. Do not continue
if your test restore fails. Correct any problems you have with the backup
before continuing these steps.
2
After the test restore is successful, open the ADMS Console and delete all
vaults and libraries listed. Then select Detach Master Vault from the Tools
menu.
3
Make sure that all users are logged out of the vault.
4
Completely uninstall SQL Express, including the following applications
in this order:
■
Microsoft SQL Server
NOTE
If you have more than one instance of SQL Express installed, be
sure to uninstall only the AutodeskVault instance. DO NOT uninstall any
other part of SQL after this step is complete.
■
MS SQL Server Native Client
■
MS SQL Server VSS Writer
■
MS SQL Server 2005 Backward Compatibility
■
MS SQL Server Setup Support Files
Upgrade Microsoft SQL |
59