Comprehensive data protection for all workloads
Post Reply
futureweb
Enthusiast
Posts: 67
Liked: 6 times
Joined: Sep 03, 2015 12:15 am
Full Name: Patrick
Contact:

tempdb.mdf file way bigger than veeam.db

Post by futureweb » Aug 07, 2016 10:42 pm

Hi,

not sure, it might be normal, but our tempdb.mdf is 20 GB of size, while veeambackup ist 7,6 and logs are 5 GB.

Is this normal?

Thanks
Patrick

Gostev
SVP, Product Management
Posts: 24303
Liked: 3333 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: tempdb.mdf file way bigger than veeam.db

Post by Gostev » Aug 07, 2016 10:57 pm

Hi Patrick, yes this is not uncommon. Because we operate with the database in SQL 2005 compatible mode, many basic SQL operations leverage tempdb heavily. This should largely go away with 9.5, for which the minimal supported SQL Server version will be 2008. Thanks!

futureweb
Enthusiast
Posts: 67
Liked: 6 times
Joined: Sep 03, 2015 12:15 am
Full Name: Patrick
Contact:

Re: tempdb.mdf file way bigger than veeam.db

Post by futureweb » Feb 02, 2017 10:51 pm

Hi,

is there anything specific we have to do in 9.5 with SQL 2014, to get the tempdb.mdf smaller again?
Running 9.5 now, with U1, tempdb.mdf is still 26.2 GB big.

Thanks
Patrick

Gostev
SVP, Product Management
Posts: 24303
Liked: 3333 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: tempdb.mdf file way bigger than veeam.db

Post by Gostev » Feb 04, 2017 1:48 am

I don't have much experience in SQL Server, but from what I remember there was a compact/shrink operation you could perform on any database... have you tried that?

futureweb
Enthusiast
Posts: 67
Liked: 6 times
Joined: Sep 03, 2015 12:15 am
Full Name: Patrick
Contact:

Re: tempdb.mdf file way bigger than veeam.db

Post by futureweb » Feb 04, 2017 2:40 am 1 person likes this post

Oh ok, I thought it's something with Veeam 9.5, not doing it at the db itself.
Normal shrink didn't work, but shrinking the file by explicitly telling it the new filesize worked. (as it was 26 GB big, but 99 % free).

Thanks
Patrick

marieelieg
Expert
Posts: 122
Liked: 6 times
Joined: Oct 20, 2016 7:15 am
Contact:

[MERGED] tempdb keeps growing

Post by marieelieg » Jul 27, 2017 12:09 pm

Hello everyone,

I have Veeam v8 installed. The Veeam Backup DB is installed locally on the Veeam server on sql server 2012. No other instance or database is installed on this sql.

The tempdb (system db that sql creates during installation) is still growing and now is around 70 GB. I have read that this tempdb is used for temporary transactions and should return to normal size when those transactions are done. I also read that some applications fail to "tell" this tempdb that the transactions are done and that's why it keeps on growing, and upon restart of the server, tempdb should return to normal size.

I did restart the server, however, tempdb is still 70GB.

I need to know how to fix this.
Is this an issue related to Veeam 8.0?
If I upgrade Veeam to 9.5, will this issue be solved?

Any help is much appreciated!

P.Tide
Product Manager
Posts: 5139
Liked: 444 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: tempdb keeps growing

Post by P.Tide » Jul 28, 2017 12:10 pm

Hi,

Update to 9.5 should help (see the posts above). Anyway, I'd recommend to contact our support team first. Once you do please post your case ID.

Thanks

marieelieg
Expert
Posts: 122
Liked: 6 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: tempdb.mdf file way bigger than veeam.db

Post by marieelieg » Jul 28, 2017 12:15 pm

Hello PTide,

No I haven't yet. On Monday I will be upgrading to Veeam 9.5. If the problem still persists then, I will open a case with Veeam.

Thanks!

Post Reply

Who is online

Users browsing this forum: Bing [Bot], caine0001, Google [Bot], J.Giroux and 94 guests