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...

but don't quote me - i had a beer at lunchtime, so look up datediff in books on line for hte exact syntax

hic

create procedure sp_tetsproc

as

select datediff(d,dateofinterest,'01/01/1970 03:00')*24*60*60*1000 from mytable

go

this would give you the number of milliseconds between 1/1/1970 03:00 and the field you requested

if the servers are on the same service pack version then there will be no difference between them.

even if they're on different versions then i don't think there will...

could i ask why you're moving the model? it's only the template for new databases.

it might be easier to just to a DTS transfer of all the "additional" objects you...