Hello ,Folks
SQL Server 2000 (sp3)
I have posted this question yesterday and still have not got an idea why it
is happening.
I have a database 11GB and every night I do a full backup (WITH INIT) of
the database that .BAK file was always around 11 GB as well
Two days ago it finnished (backup operation) with 16GB .bak file. The
.MDF,.LDF files have not grown since.
The question is WHY is my .BAK file grew so much? What could be a
reason?
ThanksHi Alex
From the sp_spaceused information you figures don't correspond
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
This says your database is 27GB and there is 10GB unused space, so 16GB for
a backup seems reasonable.
John
"Alex" wrote:
> Hello ,Folks
> SQL Server 2000 (sp3)
> I have posted this question yesterday and still have not got an idea why it
> is happening.
> I have a database 11GB and every night I do a full backup (WITH INIT) of
> the database that .BAK file was always around 11 GB as well
> Two days ago it finnished (backup operation) with 16GB .bak file. The
> ..MDF,.LDF files have not grown since.
> The question is WHY is my .BAK file grew so much? What could be a
> reason?
> Thanks
>
>|||John
Yes , you are right, the database contains three files , however , it has
been all time that the .BAK file was 11GB , so what happened at night to
grow to 16GB?
Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
> Hi Alex
> From the sp_spaceused information you figures don't correspond
> 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
>
> This says your database is 27GB and there is 10GB unused space, so 16GB
> for
> a backup seems reasonable.
> John
> "Alex" wrote:
>> Hello ,Folks
>> SQL Server 2000 (sp3)
>> I have posted this question yesterday and still have not got an idea why
>> it
>> is happening.
>> I have a database 11GB and every night I do a full backup (WITH INIT)
>> of
>> the database that .BAK file was always around 11 GB as well
>> Two days ago it finnished (backup operation) with 16GB .bak file. The
>> ..MDF,.LDF files have not grown since.
>> The question is WHY is my .BAK file grew so much? What could be a
>> reason?
>> Thanks
>>|||Hi Alex
The simple answer would be that there is more information in the file!
Unless you are archiving data from your database then you would expect a
steady growth. A 4GB increment would indicate something abnormal has
happened, such as someone copyied a large table. To find out space used by
each table you could run something like:
CREATE TABLE #spaceused ( name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18),
reservedK AS CAST(LEFT(reserved,charindex(' ', reserved)-1) AS BIGINT) )
EXEC sp_msforeachtable 'INSERT INTO #spaceused ( name, rows, reserved, data,
index_size, unused ) EXEC sp_spaceused [?]'
SELECT * FROM #spaceused
ORDER BY reservedK DESC
DROP TABLE #spaceused
John
"Alex" wrote:
> John
> Yes , you are right, the database contains three files , however , it has
> been all time that the .BAK file was 11GB , so what happened at night to
> grow to 16GB?
> Thanks
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
> > Hi Alex
> >
> > From the sp_spaceused information you figures don't correspond
> >
> > 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
> >
> >
> > This says your database is 27GB and there is 10GB unused space, so 16GB
> > for
> > a backup seems reasonable.
> >
> > John
> >
> > "Alex" wrote:
> >
> >> Hello ,Folks
> >>
> >> SQL Server 2000 (sp3)
> >>
> >> I have posted this question yesterday and still have not got an idea why
> >> it
> >> is happening.
> >>
> >> I have a database 11GB and every night I do a full backup (WITH INIT)
> >> of
> >> the database that .BAK file was always around 11 GB as well
> >> Two days ago it finnished (backup operation) with 16GB .bak file. The
> >> ..MDF,.LDF files have not grown since.
> >>
> >> The question is WHY is my .BAK file grew so much? What could be a
> >> reason?
> >>
> >> Thanks
> >>
> >>
> >>
>
>
Showing posts with label growing. Show all posts
Showing posts with label growing. Show all posts
Friday, February 24, 2012
.BAK is growing up
Hello ,Folks
SQL Server 2000 (sp3)
I have posted this question yesterday and still have not got an idea why it
is happening.
I have a database 11GB and every night I do a full backup (WITH INIT) of
the database that .BAK file was always around 11 GB as well
Two days ago it finnished (backup operation) with 16GB .bak file. The
.MDF,.LDF files have not grown since.
The question is WHY is my .BAK file grew so much? What could be a
reason?
ThanksHi Alex
From the sp_spaceused information you figures don't correspond
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
This says your database is 27GB and there is 10GB unused space, so 16GB for
a backup seems reasonable.
John
"Alex" wrote:
> Hello ,Folks
> SQL Server 2000 (sp3)
> I have posted this question yesterday and still have not got an idea why
it
> is happening.
> I have a database 11GB and every night I do a full backup (WITH INIT) of
> the database that .BAK file was always around 11 GB as well
> Two days ago it finnished (backup operation) with 16GB .bak file. The
> ..MDF,.LDF files have not grown since.
> The question is WHY is my .BAK file grew so much? What could be a
> reason?
> Thanks
>
>|||John
Yes , you are right, the database contains three files , however , it has
been all time that the .BAK file was 11GB , so what happened at night to
grow to 16GB?
Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...[vbcol=seagreen]
> Hi Alex
> From the sp_spaceused information you figures don't correspond
> 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
>
> This says your database is 27GB and there is 10GB unused space, so 16GB
> for
> a backup seems reasonable.
> John
> "Alex" wrote:
>|||Hi Alex
The simple answer would be that there is more information in the file!
Unless you are archiving data from your database then you would expect a
steady growth. A 4GB increment would indicate something abnormal has
happened, such as someone copyied a large table. To find out space used by
each table you could run something like:
CREATE TABLE #spaceused ( name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18),
reservedK AS CAST(LEFT(reserved,charindex(' ', reserved)-1) AS BIGINT) )
EXEC sp_msforeachtable 'INSERT INTO #spaceused ( name, rows, reserved, data,
index_size, unused ) EXEC sp_spaceused [?]'
SELECT * FROM #spaceused
ORDER BY reservedK DESC
DROP TABLE #spaceused
John
"Alex" wrote:
> John
> Yes , you are right, the database contains three files , however , it has
> been all time that the .BAK file was 11GB , so what happened at night to
> grow to 16GB?
> Thanks
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
>
>
SQL Server 2000 (sp3)
I have posted this question yesterday and still have not got an idea why it
is happening.
I have a database 11GB and every night I do a full backup (WITH INIT) of
the database that .BAK file was always around 11 GB as well
Two days ago it finnished (backup operation) with 16GB .bak file. The
.MDF,.LDF files have not grown since.
The question is WHY is my .BAK file grew so much? What could be a
reason?
ThanksHi Alex
From the sp_spaceused information you figures don't correspond
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
This says your database is 27GB and there is 10GB unused space, so 16GB for
a backup seems reasonable.
John
"Alex" wrote:
> Hello ,Folks
> SQL Server 2000 (sp3)
> I have posted this question yesterday and still have not got an idea why
it
> is happening.
> I have a database 11GB and every night I do a full backup (WITH INIT) of
> the database that .BAK file was always around 11 GB as well
> Two days ago it finnished (backup operation) with 16GB .bak file. The
> ..MDF,.LDF files have not grown since.
> The question is WHY is my .BAK file grew so much? What could be a
> reason?
> Thanks
>
>|||John
Yes , you are right, the database contains three files , however , it has
been all time that the .BAK file was 11GB , so what happened at night to
grow to 16GB?
Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...[vbcol=seagreen]
> Hi Alex
> From the sp_spaceused information you figures don't correspond
> 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
>
> This says your database is 27GB and there is 10GB unused space, so 16GB
> for
> a backup seems reasonable.
> John
> "Alex" wrote:
>|||Hi Alex
The simple answer would be that there is more information in the file!
Unless you are archiving data from your database then you would expect a
steady growth. A 4GB increment would indicate something abnormal has
happened, such as someone copyied a large table. To find out space used by
each table you could run something like:
CREATE TABLE #spaceused ( name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18),
reservedK AS CAST(LEFT(reserved,charindex(' ', reserved)-1) AS BIGINT) )
EXEC sp_msforeachtable 'INSERT INTO #spaceused ( name, rows, reserved, data,
index_size, unused ) EXEC sp_spaceused [?]'
SELECT * FROM #spaceused
ORDER BY reservedK DESC
DROP TABLE #spaceused
John
"Alex" wrote:
> John
> Yes , you are right, the database contains three files , however , it has
> been all time that the .BAK file was 11GB , so what happened at night to
> grow to 16GB?
> Thanks
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
>
>
.BAK is growing up
Hello ,Folks
SQL Server 2000 (sp3)
I have posted this question yesterday and still have not got an idea why it
is happening.
I have a database 11GB and every night I do a full backup (WITH INIT) of
the database that .BAK file was always around 11 GB as well
Two days ago it finnished (backup operation) with 16GB .bak file. The
..MDF,.LDF files have not grown since.
The question is WHY is my .BAK file grew so much? What could be a
reason?
Thanks
Hi Alex
From the sp_spaceused information you figures don't correspond
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
This says your database is 27GB and there is 10GB unused space, so 16GB for
a backup seems reasonable.
John
"Alex" wrote:
> Hello ,Folks
> SQL Server 2000 (sp3)
> I have posted this question yesterday and still have not got an idea why it
> is happening.
> I have a database 11GB and every night I do a full backup (WITH INIT) of
> the database that .BAK file was always around 11 GB as well
> Two days ago it finnished (backup operation) with 16GB .bak file. The
> ..MDF,.LDF files have not grown since.
> The question is WHY is my .BAK file grew so much? What could be a
> reason?
> Thanks
>
>
|||John
Yes , you are right, the database contains three files , however , it has
been all time that the .BAK file was 11GB , so what happened at night to
grow to 16GB?
Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...[vbcol=seagreen]
> Hi Alex
> From the sp_spaceused information you figures don't correspond
> 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
>
> This says your database is 27GB and there is 10GB unused space, so 16GB
> for
> a backup seems reasonable.
> John
> "Alex" wrote:
|||Hi Alex
The simple answer would be that there is more information in the file!
Unless you are archiving data from your database then you would expect a
steady growth. A 4GB increment would indicate something abnormal has
happened, such as someone copyied a large table. To find out space used by
each table you could run something like:
CREATE TABLE #spaceused ( name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18),
reservedK AS CAST(LEFT(reserved,charindex(' ', reserved)-1) AS BIGINT) )
EXEC sp_msforeachtable 'INSERT INTO #spaceused ( name, rows, reserved, data,
index_size, unused ) EXEC sp_spaceused [?]'
SELECT * FROM #spaceused
ORDER BY reservedK DESC
DROP TABLE #spaceused
John
"Alex" wrote:
> John
> Yes , you are right, the database contains three files , however , it has
> been all time that the .BAK file was 11GB , so what happened at night to
> grow to 16GB?
> Thanks
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
>
>
SQL Server 2000 (sp3)
I have posted this question yesterday and still have not got an idea why it
is happening.
I have a database 11GB and every night I do a full backup (WITH INIT) of
the database that .BAK file was always around 11 GB as well
Two days ago it finnished (backup operation) with 16GB .bak file. The
..MDF,.LDF files have not grown since.
The question is WHY is my .BAK file grew so much? What could be a
reason?
Thanks
Hi Alex
From the sp_spaceused information you figures don't correspond
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
This says your database is 27GB and there is 10GB unused space, so 16GB for
a backup seems reasonable.
John
"Alex" wrote:
> Hello ,Folks
> SQL Server 2000 (sp3)
> I have posted this question yesterday and still have not got an idea why it
> is happening.
> I have a database 11GB and every night I do a full backup (WITH INIT) of
> the database that .BAK file was always around 11 GB as well
> Two days ago it finnished (backup operation) with 16GB .bak file. The
> ..MDF,.LDF files have not grown since.
> The question is WHY is my .BAK file grew so much? What could be a
> reason?
> Thanks
>
>
|||John
Yes , you are right, the database contains three files , however , it has
been all time that the .BAK file was 11GB , so what happened at night to
grow to 16GB?
Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...[vbcol=seagreen]
> Hi Alex
> From the sp_spaceused information you figures don't correspond
> 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
>
> This says your database is 27GB and there is 10GB unused space, so 16GB
> for
> a backup seems reasonable.
> John
> "Alex" wrote:
|||Hi Alex
The simple answer would be that there is more information in the file!
Unless you are archiving data from your database then you would expect a
steady growth. A 4GB increment would indicate something abnormal has
happened, such as someone copyied a large table. To find out space used by
each table you could run something like:
CREATE TABLE #spaceused ( name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18),
reservedK AS CAST(LEFT(reserved,charindex(' ', reserved)-1) AS BIGINT) )
EXEC sp_msforeachtable 'INSERT INTO #spaceused ( name, rows, reserved, data,
index_size, unused ) EXEC sp_spaceused [?]'
SELECT * FROM #spaceused
ORDER BY reservedK DESC
DROP TABLE #spaceused
John
"Alex" wrote:
> John
> Yes , you are right, the database contains three files , however , it has
> been all time that the .BAK file was 11GB , so what happened at night to
> grow to 16GB?
> Thanks
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0D7D6906-B6E8-47DD-AED0-21F101C1571C@.microsoft.com...
>
>
.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.
|||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...
>
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.
|||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...
>
.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.
>> 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
>|||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
>> 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.
>> 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
>>
>|||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...
>> 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.
>> 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
>>
>>
>
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.
>> 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
>|||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
>> 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.
>> 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
>>
>|||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...
>> 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.
>> 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
>>
>>
>
.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...
>
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...
>
Subscribe to:
Posts (Atom)