That is also our situation it will be production. THanks very much.

Thanks for the clarification. I will look into these traces too.

Thanks very much for your response. We'll run the IO diagnostics.

I ran sp_config as suggested and got the same results as you showed in your example in both prod and test databases. Thanks for the idea, anything else??

I have it working now.

Thanks very much for all the help!

Yes it's part of the file name. I'm still struggling with the syntax. Can you see what's wrong with this:

BACKUP DATABASE CE10 to disk = 'c:\mssql\backup\ce10_db_ '+ convert(varchar(8),...

Yes I'm using a SQL script. Maybe I just can't get the right syntax:

BACKUP DATABASE CE10 to disk =

'c:\mssql\BACKUP\ce10_db_convert(getdate()).BAK' WITH NOINIT

How do I append/convert correctly? I'll try...

Thanks for all your responses. I thought I was really missing something! I feel much better now.:)

Thank you, that's what I thought. But our vendor is trying to say that all rights to all databases come with public role. They must have granted these permissions. ...

I have read the document you mentioned on locking pages in memory but haven't done that yet. Not sure I fully understand the affects it would have.

I also...

The SQL Server is enterprise ed, sp 2. Windows is 2003 enterprise x64 ed.

There is a password set on the database but not workgroup level security. I tried unsetting the password but we got the same error. We are just trying to...

Thank you, I understand about Windows/mixed mode.

I was just trying to determine if there are other password parameters that can/should be set, such as length, special characters, etc. Again thanks...

The answer to this query is 0. Does this mean we have no restrictions set?

Thanks very much!

Thanks very much. I will explore these options.