use mydatabase

go

dbcc updateusage(mydatabase)

go

sp_msforeachtable @command1= 'sp_spaceused ''?'''

go

with the restore it could be one of a few things. more than likely it's the I/O speed when trying to create the files (how big is your database?)

or perhaps...

not sure this is exactly what you're looking for but how about

select amountid,count(*) from amount group by amountid where amountid>0

this should then have the same values in the resultset

select amountid,count(*)...

redgate and imceda both provide backup compression tools to do this

imceda's sql litespeed is particularly good, but they've been bought out by quest, so the prices have gone up

2 things you can do

1)stop sql agent -it uses msdb so you won't be able to restore

2) if that fails right click ont eh database and choose properties and set...

the log % used is 0.18981564% so i'm guessing a backup or switch to simple must have occurred at some point

can you post the exect syntax of the shrinkfile statement

as far as i'm aware you don't have to be in single user mode, although i have known shrinkfile to be...

none, as i've never had the reason to query it.

since standard edition supports multimple cpus and i can see my queries in the query execution plan as using parallelism i've...

then just run a dbcc shrinkfile

or even use enterpise manager tools to shrink the file (even though they suck)

no problems at all

just make sure that after you shrink the...

i agree david,

but there is a way to keep both in sync - although it's expensive

store the documents on a nas or san and use snapshots and the...

instarquery paralellism is available on both editions

performance differences between editions will depend on the number fo CPUs and the amount of RAM although not all ram is available in...

there are a few reasons for not storing the data in the database, but they are mainly to do with manageability.

the data stored in the binary field is not stored...

can you open query analyser and post the results of the following statement

DBCC SQLPERF(LOGSPACE)

that should let us know how to advise you to proceed

i beleive it's possible, but you should upgrade your tools in order to ensure you have the "latest" client

the sql 2000 tools only take a few monments to install and...

I beleive that log shipping will be broken, although i'm not sayig there isn't a way round it.

if i could ask - why does your database take 2 days to...