Lounge Network - Knowledge Base

  View Printer Friendly Version Search
KNOWLEDGE BASE HOME » 14. INFORMATION: CORPORATE & BUSINESS HOSTING Viewing Answer
[MSSQL] Am I getting charged for my MSSQL log files?
All of the MSSQL databases are charged on their Space usage (both data and log).

There is one 20MB MSSQL database included with each Windows Business Class Web Hosting Plan. Additional database space is charged at $10+gst per 10 MB per month.

If you want to reduce your log file size then the following Transact-SQLs may help:

# Change the database recovery model to SIMPLE

ALTER DATABASE database_name
SET RECOVERY SIMPLE ;

Reference:http://msdn2.microsoft.com/en-us/library/ms174269.aspx


# Shrink the database

DBCC SHRINKDATABASE ( database_name ) ;

Reference: http://msdn2.microsoft.com/en-us/library/aa258287(SQL.80).aspx


# Size of the database

use database_name
go
exec sp_spaceused
go



KNOWLEDGE BASE HOME » 14. INFORMATION: CORPORATE & BUSINESS HOSTING Viewing Answer




Knowledgebase Manager

© Copyright Lounge Network 2001-2017