.BAK file is growing up

Hello.
SQL Server 2000 (SP3)
I monitor my db's size and it has not changed about a month , however .BAK
file is grown up for about 5gb. Is it possible?
Db size is about 30gb and we have autogrow feature turned on (10 percent)
ThanksAlthough your db size is 30 gigs. It could be that there was ample free
space in it and it is filling up.|||Although your db size is 30 gigs, it could be that there was ample free
space in it and it is filling up.|||Hi,
Since if the file backup file growth is very high; then i feel that you are
appending to the backup file.
Execute the below command to check how many backup sets you have in your
backup file.
RESTORE Headeronly FROM disk='c:\master.bak'
A client can use RESTORE HEADERONLY to retrieve all the backup header
information for all backups on a particular backup device. The header
information is sent as a row by the server for each backup on a given backup
device in a table
Thanks
Hari
SQL Server MVP
"Alex" <test@.test.com> wrote in message
news:eNrI6J62GHA.3944@.TK2MSFTNGP04.phx.gbl...
> Hello.
> SQL Server 2000 (SP3)
> I monitor my db's size and it has not changed about a month , however
> .BAK file is grown up for about 5gb. Is it possible?
> Db size is about 30gb and we have autogrow feature turned on (10 percent)
> Thanks
>|||Hari

> Since if the file backup file growth is very high; then i feel that you
> are appending to the backup file.
No, it suddenly happened (growing .BAK ) last night and we have been
using WITH INIT option for all time.
So I have only one file in .BAK sets
Any ideas please
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qhOwp62GHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Since if the file backup file growth is very high; then i feel that you
> are appending to the backup file.
> Execute the below command to check how many backup sets you have in your
> backup file.
> RESTORE Headeronly FROM disk='c:\master.bak'
>
> A client can use RESTORE HEADERONLY to retrieve all the backup header
> information for all backups on a particular backup device. The header
> information is sent as a row by the server for each backup on a given
> backup device in a table
> Thanks
> Hari
> SQL Server MVP
> "Alex" <test@.test.com> wrote in message
> news:eNrI6J62GHA.3944@.TK2MSFTNGP04.phx.gbl...
>|||Hello,
Can you execute a SP_Spaceused on that database and see how much is utilized
for data and index.
THanks
Hari
SQL Server MVP
"Alex" <test@.test.com> wrote in message
news:%23FWeB372GHA.3476@.TK2MSFTNGP04.phx.gbl...
> Hari
>
> No, it suddenly happened (growing .BAK ) last night and we have been
> using WITH INIT option for all time.
> So I have only one file in .BAK sets
> Any ideas please
>
>
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qhOwp62GHA.4764@.TK2MSFTNGP05.phx.gbl...
>|||Hi,Hari
Here iis an output
database_name
database_size unallocated space
----
----
-- --
dbname
28511.69 MB 519.01 MB
reserved data index_size
unused
-- -- -- --
23568632 KB 6408816 KB 6066240 KB 11093576 KB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%238MZOy92GHA.4164@.TK2MSFTNGP05.phx.gbl...
> Hello,
> Can you execute a SP_Spaceused on that database and see how much is
> utilized for data and index.
> THanks
> Hari
> SQL Server MVP
> "Alex" <test@.test.com> wrote in message
> news:%23FWeB372GHA.3476@.TK2MSFTNGP04.phx.gbl...
>