tempdb.mdf file way bigger than veeam.db

Availability for the Always-On Enterprise

tempdb.mdf file way bigger than veeam.db

Veeam Logoby futureweb » Sun 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
futureweb
Enthusiast
 
Posts: 53
Liked: 5 times
Joined: Thu Sep 03, 2015 12:15 am
Full Name: Patrick

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

Veeam Logoby Gostev » Sun 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!
Gostev
VP, Product Management
 
Posts: 20985
Liked: 2248 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

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

Veeam Logoby futureweb » Thu 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
futureweb
Enthusiast
 
Posts: 53
Liked: 5 times
Joined: Thu Sep 03, 2015 12:15 am
Full Name: Patrick

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

Veeam Logoby Gostev » Sat 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?
Gostev
VP, Product Management
 
Posts: 20985
Liked: 2248 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

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

Veeam Logoby futureweb » Sat 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
futureweb
Enthusiast
 
Posts: 53
Liked: 5 times
Joined: Thu Sep 03, 2015 12:15 am
Full Name: Patrick


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Majestic-12 [Bot] and 16 guests