Warning : this query does direct access to system-objects ! They may change without warning with hotfix, sp, ...

This is what I use...

start with :

ALTER DATABASE yourdb Set RESTRICTED_USER , read_only WITH ROLLBACK IMMEDIATE

Restore database yourdb from .....

check your backup with

RESTORE LABELONLY

FROM disk=yourbackup-file

RESTORE HEADERONLY

FROM disk=yourbackup-file

and check the creation dates !

I guess you have restored an older version of master !

how about trying :

alter database yourdb set online

long shot ... but ...

did someone try to run the "copy database" wizard

It does a detach...

since you dev-server is less strict than your prod server, there might be problems at dev-side.

on the other hand, if there were to occur problems, the developers would have to...

I don't know, but I can tell you this is not a one to one operation.

You'll need to think about your join predicates to determine which part(s) to use in...

check msmdsrv.exe in taskmanager.

IF pss says so, accept it.  For the moment I cannot check because I nolonger have msAs available on a big...

AFAIK Analysis Service (32 bit) takes maximum 3Gb. Even if more is available.

did you disable AWE when you enabled the /3Gb switch ?

correct.

HTH

When you have 8Gb ram you should alter your boot.ini to use /3Gb _and_ /pae and _not_enable AWE ! 

This is what we have in the boot.ini :

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server...

John,

when you only have 4 Gb ram on your server AWE would be overhead because you should only use /3gb switch in the boot.ini

Have a look at http://www.sql-server-performance.com/awe_memory.asp

Sorry for the late followup : I've been attending SQLPASS2005

btw Natalia I got it working now

Thanks

just a thinking :

imgFname varchar(30),

that 30 may be to small, then you'll get an error stating truncation would take place if you want to store a imgFname that is...