Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

TMS Database File is Running Out of Space

HI,

I am getting "TMS Database File is Running Out of Space" error on my TMS Server portal page. I have 180GB free space on my drive.

Do you guys have any idea about this issue, please help me out....

Regards,

Nikhil Jayan

Everyone's tags (1)
12 REPLIES
Cisco Employee

Re: TMS Database File is Running Out of Space

Hi

Are you using SQL express? There is a size limit on the database in the express edition, 2008 = 10gb, 2005 = 4 gb if i remember correct. Are you using the express edition

And how large is the database? Is the database stored on a disk with the 180gb free space?

Sent from Cisco Technical Support iPhone App

TMS Database File is Running Out of Space

Hi Ohm,

Thanks for your immediate reply.

i am using SQL Express 2005 edition.

i have 180gb free space on database contained disk.

Regards,

Nikhil Jayan

Cisco Employee

Re: TMS Database File is Running Out of Space

Hi

Ok, so how large is the actual tmsng.mdf file? You should find it in the data folder in the sql server path.

/magnus

Sent from Cisco Technical Support iPad App

New Member

TMS Database File is Running Out of Space

Hi,

we are getting this error too. Our disk has 32% free diskspace and the SQL File "tmsng.mdf" is about 3.949.824kb.

How can we solve that problem?

regards Jens

VIP Purple

Re: TMS Database File is Running Out of Space

If it's approaching the 4Gb mark, and complaing about getting full, it sounds like you're got the 2005 version of SQL express.  It's not disk space it's complaing about, it's the SQL database size.

There are a couple of options to solve this:

1)     Upgrade/migrate the database to a SQL 2008 express database

2)     Migrate the database to a full blow SQL server (on a separate SQL server box).

Wayne

--

Please remember to rate responses and mark your question as answered if appropriate.

Wayne
--
Please remember to rate responses and to mark your question as answered if appropriate.
New Member

TMS Database File is Running Out of Space

Hi Wayne,

oh yes, I haven't post these informations. We are on a Windows SQL Server 2008 express database.

That's why I'm not understanding the error.

New Member

TMS Database File is Running Out of Space

Hi everybody,

I think I found the solution. The SQL Server 2008 express has also a 4GB database limit.

Since SQL Server 2008 R2 express it was increased to 10GB.

http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

regards jens

TMS Database File is Running Out of Space

Hi Jens,

the answer is to use a database which can support the amount of data you need to handle.

Though if you need something more then these limits I would first check if there is data which

should be purged. If you do not need history data its better to be removed.

On the other side if you have so much live data, looking into a dedicated SQL server might make sense.

Please remember to rate helpful responses and identify helpful or correct answers.

Please remember to rate helpful responses and identify

Cisco Employee

TMS Database File is Running Out of Space

Excellent points Martin

New Member

TMS Database File is Running Out of Space

Hi Martin,

thats our solution. We are preparing to migrate the DB to a big SQL Server.

What do you mean with history data, how can I find them and purge them if necessary.

/regards

Cisco Employee

Re: TMS Database File is Running Out of Space

@Jens: In TMS, go to Administrative Tools > TMS Server Maintenance >Purge Old Data in Database Tables Plan

Cisco Employee

Re: TMS Database File is Running Out of Space

Other then the data purge options, be sure to backup the database and transaction logs regularly. After doing the backups, run an SQL task to shrink the database.

Sent from Cisco Technical Support iPhone App

1230
Views
0
Helpful
12
Replies
CreatePlease to create content