. and ./ can also be used sometimes as well.

Just curious as to why this is an issue. Only setupadmin and sysadmin have the authority to use this stored procedure. It sounds as if more than just the DBA(s)...

I agree with sswords to a point ... the old school method of 25% was usually a starting point. Monitoring growth and usage are musts along with adjusting the frequency...

I just spent 4 hours on the phone with Microsoft on this one ... damn, I knew I had read about it in the recent past but could not remember...

you stated: "this server only runs sql/analysis server / reporting server"

Well 4 Gb of RAM would seem enough but here's what I think may be happening:

Operating system uses what it...

I just ran into this KB article the other day ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;174799

Just for general information ...

[Sybase DBA mode "ON"]

You can do it in Sybase, but then the databases are 'joined at the hip' for all restore/DR operations (so you had...

If it's truly a 'simple' document storage database why not just execute the document reindexing ... If I understand correctly that a DMS does not store the actual documents, just...

Dependent on the following:

1. database backup file size (or .mdf/.ldf files if you opt for detach/attach)
2. network speed
3. number of databases

this and and a little benchmark testing (just 2-3 backups) ....

you may...

By default all Domain Administrator accounts are system administrators in SQL Server by virtue of membership to the BUILTIN\Administrators if it is persent. If BUILTIN\Administrators is not present, then Domain...

I felt the 'Sybase DBA' in rising back to life ...

Good catch Jeff !

I just wish to state that I never (really, NEVER NEVER) upgrade an exisiting installation in this fashion. My advice is:

1. script your logins (sp_help_revlogin is available from MS)
2. script your...

Script out the JOB, delete it and add it back in for starters ...

Also, check the user account provileges for the service accounts.

This is one for Steven Covey - lose-lose ...

Just a question, if your boss 'understands' SQL (that implies he's technical) then why hasn't he delivered you better criteria ?

 It sounds...