HP BladeSystem bc2800 Administrator's Guide HP Session Allocation Manager (HP - Page 34

The default file location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL

Page 34 highlights

Truncate Table Auditlog Truncate Table History d. Click Execute. You should see Command(s) completed successfully In the messages section. 2. Shrink the database: a. Open SQL Server Management Studio and expand the Databases folder. b. Right-click on SAM database, and select Tasks > Shrink > Files. c. In the File type list, select Data. d. In the Shrink action section, select Reorganize pages before releasing unused space. e. Set the Shrink file size to the default 100MB. f. Click OK. 3. Verify that you have a 100MB SAM_data.mdf file. NOTE: The default file location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL \Data. 26 Chapter 3 Installation ENWW

  • 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

Truncate Table Auditlog
Truncate Table History
d.
Click
Execute
.
You should see
Command(s) completed successfully
In the messages section.
2.
Shrink the database:
a.
Open SQL Server Management Studio and expand the Databases folder.
b.
Right-click on
SAM database
, and select
Tasks
>
Shrink
>
Files
.
c.
In the
File type
list, select
Data
.
d.
In the
Shrink action
section, select
Reorganize pages before releasing unused space
.
e.
Set the
Shrink file
size to the default
100MB
.
f.
Click
OK
.
3.
Verify that you have a 100MB SAM_data.mdf file.
NOTE:
The default file location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
\Data.
26
Chapter 3
Installation
ENWW