| Author |
.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)
Thanks
| |
|
|
Although 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.
| |
| Hari Prasad 2006-10-24, 6:29 pm |
| 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@hotmai
l.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...
>
>
| |
| Hari Prasad 2006-10-24, 6:29 pm |
| 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@hotmai
l.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@hotmai
l.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...
>
>
|
|
|
|