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
View all HP BladeSystem bc2800 manuals
Add to My Manuals
Save this manual to your list of manuals |
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
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