Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

SQL Server Management

Hi there,
We have a production DB.
Under allocated space I see the following:

total DB space: 720.50 MB used: 641.50 MB free: 79.0 MB
total tranLOG space: 15,618.68 MB user: 42.78 MB free: 15,575.9 MB

Since I see only 79 MB of available space for data. what can I do to increase total DB space? and even reduce Transact Log space?

thank you
regards.

[442 byte] By [EdgarZapata] at [2008-2-10]
«« Difference between Editing & Checking out through the Project Portal
»» make DSOFramer object either not visible or transparent
# 1
Hi,

Does your db not grow automatically, when you get more data in it?

rgerbig at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2
It does.
In any case, I already posted this in another forum.

I was told to search the BOL for alter database
And go to http://www.helpdna.net/bosqlfaq01.htm

regards.

EdgarZapata at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 3
You can reduce log file space to run DBCC SHRINKFILE on the logfile.

Databases can be shrunk as well with DBCC SHRINKDATABASE.

use ALTER DATABASE to set various database options (like AUTO_SHRINK).

You can set growth behavior of individual database files or log files with

ALTER DATABASE ... MODIFY FILE ( NAME = ..., FILEGROWTH = 10%)

... fill in the dots ...

Hope this helps.

MichielWories at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified