Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KBTry running DBCC UPDATEUSAGE(0) and report back the space used.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns977AEC59B7F29gurbaohotmailcom@.12
9.250.171.65...
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@.TK2MSFTNGP12.phx.gbl:
> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>
Hi,
seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'
was missing some tables...
I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.
Case closed :-)
Thanks,
Showing posts with label inserted. Show all posts
Showing posts with label inserted. Show all posts
Tuesday, March 27, 2012
Database growing unexpectedly
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB
Try running DBCC UPDATEUSAGE(0) and report back the space used.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns977AEC59B7F29gurbaohotmailcom@.129.250.171. 65...
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@.TK2MSFTNGP12.phx.gbl:
> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>
Hi,
seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'
was missing some tables...
I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.
Case closed :-)
Thanks,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB
Try running DBCC UPDATEUSAGE(0) and report back the space used.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns977AEC59B7F29gurbaohotmailcom@.129.250.171. 65...
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@.TK2MSFTNGP12.phx.gbl:
> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>
Hi,
seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'
was missing some tables...
I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.
Case closed :-)
Thanks,
Database growing unexpectedly
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KBTry running DBCC UPDATEUSAGE(0) and report back the space used.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns977AEC59B7F29gurbaohotmailcom@.129.250.171.65...
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@.TK2MSFTNGP12.phx.gbl:
> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>
Hi,
seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'
was missing some tables...
I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.
Case closed :-)
Thanks,sql
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KBTry running DBCC UPDATEUSAGE(0) and report back the space used.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns977AEC59B7F29gurbaohotmailcom@.129.250.171.65...
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@.TK2MSFTNGP12.phx.gbl:
> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>
Hi,
seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'
was missing some tables...
I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.
Case closed :-)
Thanks,sql
Thursday, March 22, 2012
Database Files
Hi,
I Inserted a new file in my database, and when I try to exclude it from my database sql says that the file is not empty ! The question is : Is there a way to clean up the file so can be deleted ! What shoud i Do !
Thank's
DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
Look it up in BOL for a complete description.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's
|||Hi-
You can use :-
USE MyDB
GO
DBCC SHRINKFILE (MyDataFile, 7)
GO
This example shrinks the size of a file named MyDataFile in the MyDB user
database to 7 MB.
Thanks
-Surajit
surajits@.nospam.yahoo.com
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's
|||Argh!...
I should have known better.
The real code snippit shoudl be:
Use <MyDatabaseName>
go
DBCC Shrinkfile (<MyFileName>, EMPTYFILE)
You can then use the ALTER DATABASE command to remove the file.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ezg5X%23LTEHA.3548@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
> Look it up in BOL for a complete description.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doubt" <anonymous@.discussions.microsoft.com> wrote in message
> news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
my
> database sql says that the file is not empty ! The question is : Is there
a
> way to clean up the file so can be deleted ! What shoud i Do !
>
I Inserted a new file in my database, and when I try to exclude it from my database sql says that the file is not empty ! The question is : Is there a way to clean up the file so can be deleted ! What shoud i Do !
Thank's
DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
Look it up in BOL for a complete description.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's
|||Hi-
You can use :-
USE MyDB
GO
DBCC SHRINKFILE (MyDataFile, 7)
GO
This example shrinks the size of a file named MyDataFile in the MyDB user
database to 7 MB.
Thanks
-Surajit
surajits@.nospam.yahoo.com
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's
|||Argh!...
I should have known better.
The real code snippit shoudl be:
Use <MyDatabaseName>
go
DBCC Shrinkfile (<MyFileName>, EMPTYFILE)
You can then use the ALTER DATABASE command to remove the file.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ezg5X%23LTEHA.3548@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
> Look it up in BOL for a complete description.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doubt" <anonymous@.discussions.microsoft.com> wrote in message
> news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
my
> database sql says that the file is not empty ! The question is : Is there
a
> way to clean up the file so can be deleted ! What shoud i Do !
>
Database Files
Hi
I Inserted a new file in my database, and when I try to exclude it from my database sql says that the file is not empty ! The question is : Is there a way to clean up the file so can be deleted ! What shoud i Do
Thank'sDBCC Shrinkfile (<yourdbname>, EMPTYFILE)
Look it up in BOL for a complete description.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Hi-
You can use :-
USE MyDB
GO
DBCC SHRINKFILE (MyDataFile, 7)
GO
This example shrinks the size of a file named MyDataFile in the MyDB user
database to 7 MB.
Thanks
-Surajit
surajits@.nospam.yahoo.com
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Argh!...
I should have known better.
The real code snippit shoudl be:
Use <MyDatabaseName>
go
DBCC Shrinkfile (<MyFileName>, EMPTYFILE)
You can then use the ALTER DATABASE command to remove the file.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ezg5X%23LTEHA.3548@.TK2MSFTNGP09.phx.gbl...
> DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
> Look it up in BOL for a complete description.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doubt" <anonymous@.discussions.microsoft.com> wrote in message
> news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> > Hi,
> >
> > I Inserted a new file in my database, and when I try to exclude it from
my
> database sql says that the file is not empty ! The question is : Is there
a
> way to clean up the file so can be deleted ! What shoud i Do !
> >
> > Thank's
>
I Inserted a new file in my database, and when I try to exclude it from my database sql says that the file is not empty ! The question is : Is there a way to clean up the file so can be deleted ! What shoud i Do
Thank'sDBCC Shrinkfile (<yourdbname>, EMPTYFILE)
Look it up in BOL for a complete description.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Hi-
You can use :-
USE MyDB
GO
DBCC SHRINKFILE (MyDataFile, 7)
GO
This example shrinks the size of a file named MyDataFile in the MyDB user
database to 7 MB.
Thanks
-Surajit
surajits@.nospam.yahoo.com
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Argh!...
I should have known better.
The real code snippit shoudl be:
Use <MyDatabaseName>
go
DBCC Shrinkfile (<MyFileName>, EMPTYFILE)
You can then use the ALTER DATABASE command to remove the file.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ezg5X%23LTEHA.3548@.TK2MSFTNGP09.phx.gbl...
> DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
> Look it up in BOL for a complete description.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doubt" <anonymous@.discussions.microsoft.com> wrote in message
> news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> > Hi,
> >
> > I Inserted a new file in my database, and when I try to exclude it from
my
> database sql says that the file is not empty ! The question is : Is there
a
> way to clean up the file so can be deleted ! What shoud i Do !
> >
> > Thank's
>
Database Files
Hi,
I Inserted a new file in my database, and when I try to exclude it from my d
atabase sql says that the file is not empty ! The question is : Is there a w
ay to clean up the file so can be deleted ! What shoud i Do !
Thank'sDBCC Shrinkfile (<yourdbname>, EMPTYFILE)
Look it up in BOL for a complete description.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Hi-
You can use :-
USE MyDB
GO
DBCC SHRINKFILE (MyDataFile, 7)
GO
This example shrinks the size of a file named MyDataFile in the MyDB user
database to 7 MB.
Thanks
-Surajit
surajits@.nospam.yahoo.com
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Argh!...
I should have known better.
The real code snippit shoudl be:
Use <MyDatabaseName>
go
DBCC Shrinkfile (<MyFileName>, EMPTYFILE)
You can then use the ALTER DATABASE command to remove the file.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ezg5X%23LTEHA.3548@.TK2MSFTNGP09.phx.gbl...
> DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
> Look it up in BOL for a complete description.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doubt" <anonymous@.discussions.microsoft.com> wrote in message
> news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
my[vbcol=seagreen]
> database sql says that the file is not empty ! The question is : Is there
a
> way to clean up the file so can be deleted ! What shoud i Do !
>
I Inserted a new file in my database, and when I try to exclude it from my d
atabase sql says that the file is not empty ! The question is : Is there a w
ay to clean up the file so can be deleted ! What shoud i Do !
Thank'sDBCC Shrinkfile (<yourdbname>, EMPTYFILE)
Look it up in BOL for a complete description.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Hi-
You can use :-
USE MyDB
GO
DBCC SHRINKFILE (MyDataFile, 7)
GO
This example shrinks the size of a file named MyDataFile in the MyDB user
database to 7 MB.
Thanks
-Surajit
surajits@.nospam.yahoo.com
"Doubt" <anonymous@.discussions.microsoft.com> wrote in message
news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
> Hi,
> I Inserted a new file in my database, and when I try to exclude it from my
database sql says that the file is not empty ! The question is : Is there a
way to clean up the file so can be deleted ! What shoud i Do !
> Thank's|||Argh!...
I should have known better.
The real code snippit shoudl be:
Use <MyDatabaseName>
go
DBCC Shrinkfile (<MyFileName>, EMPTYFILE)
You can then use the ALTER DATABASE command to remove the file.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ezg5X%23LTEHA.3548@.TK2MSFTNGP09.phx.gbl...
> DBCC Shrinkfile (<yourdbname>, EMPTYFILE)
> Look it up in BOL for a complete description.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doubt" <anonymous@.discussions.microsoft.com> wrote in message
> news:4803DDD7-1B38-4D71-9016-CED5BFD66A65@.microsoft.com...
my[vbcol=seagreen]
> database sql says that the file is not empty ! The question is : Is there
a
> way to clean up the file so can be deleted ! What shoud i Do !
>
Subscribe to:
Posts (Atom)