As deepak has said clearing some space on the drive the model log file resides on is the easiest way out of this. If default setings for model you probably...

the above article actually says the opposite:

The /3GB switch is used to tell SQL Server to take advantage of 3GB out of the base 4GB of RAM that Windows...

the truncateonly option means shrinkfile will not attempt to move any data before releasing space to the OS, so perhaps you happen to have data right at the end of...

anything in the errorlog?

for these files the backup times are extremely long. Either your hardware is maxed out or the backups are being blocked (check using sp_who2 during the backups), though few things...

In query analyser:  (presuming your new login is called test, does not have to be)

use master

go

EXEC sp_addlogin 'test', 'make a password up'

exec sp_defaultdb  'test',test

use test

go

exec sp_grantdbaccess 'test','test'

exec sp_addrolemember  "db_owner",...

is your distribution agent cleanup task running? As sugesh says file will not shrink it it is full.

As long as the table is not huge, dts may be a better option for you as you want to amend the data on the way out.

many thanks to everybody for their comments.

I will be recommending hyperthreading be turned of at the BIOS level.

I am loathe to push this any further but I have a strong...

thankyou very much for all the replies.

The 4 CPU limit on standard edition is a good point. But is it limited to 4 slots, or 4 cores?

SQL standard is able...

thanks for the comments, keep 'em coming.

Its 32 bit and the box (and 2 others like it) are to be used as SQL consolidated servers supporting multiple OLTP apps, but including...

could it be greyed out because all users in the database are orphaned following the restore from a different server.? Chck using exec sp_change_users_login 'report'.

If so you need to add...

that was sneaky. Most irritating thing was that I fell for it and read the question I wanted to see rather than the actual quesion. Do i get .667 of...

Bora,

I got my i/o profile by running system monitor using all the physical disk counters. I ran it for a good long time to capture all periods of usage and...

the sqldiag utility will certainly give you info on OS patch levels