"Disk full"

I am running Windows 2000 professional, we are showing the entire drive
is full( 30gig). I suspect it is in system backups. Any ideas?Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running Windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running Windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.|||thanks, I'll look at that.

"Disk full"

I am running windows 2000 professional, we are showing the entire drive
is full( 30gig). I suspect it is in system backups. Any ideas?Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.|||thanks, I'll look at that.

"Disk full"

I am running windows 2000 professional, we are showing the entire drive
is full( 30gig). I suspect it is in system backups. Any ideas?
Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegro ups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>
|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegro ups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>
|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.
|||thanks, I'll look at that.

HELP ! Disappearing objects

We are supposed to be deploying to SQL2K5 this friday night. I've been
taking backups from our SQL 2K server and restoring them directly on our 2K5
box. Everything seems to work ok except for one of our databases. When I
expand the "views" in Sql Management Studio object browser I get an error
that says "Parameter cannot be null" and none of the objects are there!!!
All other object types seem fine and only this database exhibits this
behavior. I'm not sure how to track this down.the error message is actually this
Value cannot be null.
Parameter name: context (ObjectExplorer)
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23QwU%23MMaGHA.4788@.TK2MSFTNGP02.phx.gbl...
> We are supposed to be deploying to SQL2K5 this friday night. I've been
> taking backups from our SQL 2K server and restoring them directly on our
> 2K5 box. Everything seems to work ok except for one of our databases.
> When I expand the "views" in Sql Management Studio object browser I get an
> error that says "Parameter cannot be null" and none of the objects are
> there!!! All other object types seem fine and only this database exhibits
> this behavior. I'm not sure how to track this down.
>|||One thing that I know doesn't work in 2005 is databases in a too low compatibility mode (60 and 65,
I believe). I'd think that SSMS would give a better error message, but worth looking into.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23dtxLQMaGHA.3304@.TK2MSFTNGP04.phx.gbl...
> the error message is actually this
> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:%23QwU%23MMaGHA.4788@.TK2MSFTNGP02.phx.gbl...
>> We are supposed to be deploying to SQL2K5 this friday night. I've been taking backups from our
>> SQL 2K server and restoring them directly on our 2K5 box. Everything seems to work ok except for
>> one of our databases. When I expand the "views" in Sql Management Studio object browser I get an
>> error that says "Parameter cannot be null" and none of the objects are there!!! All other object
>> types seem fine and only this database exhibits this behavior. I'm not sure how to track this
>> down.
>|||And what if you query sys.objects? Are the object listed in
the catalog view? Or in the information_schema.views view?
I've hit a few flaky things like that with SSMS. Usually
when I hit the bug with the index error in SSMS, I start
seeing other object display issues until I close SSMS and
reopen. I think some, most of those are fixed in SP1 for SQL
2005.
-Sue
On Tue, 25 Apr 2006 16:51:57 -0700, "Tim Greenwood"
<tim_greenwood A-T yahoo D-O-T com> wrote:
>We are supposed to be deploying to SQL2K5 this friday night. I've been
>taking backups from our SQL 2K server and restoring them directly on our 2K5
>box. Everything seems to work ok except for one of our databases. When I
>expand the "views" in Sql Management Studio object browser I get an error
>that says "Parameter cannot be null" and none of the objects are there!!!
>All other object types seem fine and only this database exhibits this
>behavior. I'm not sure how to track this down.
>