All,

I also have similar problem on one of my server running SQL Server 7.0 SP3 on Windows NT 4.0 Server Enterprise Edition (with 2.5GB RAM, 4 Proc). Sometimes during maintenance...

Did you check if the server is in Windows Authentication Mode?! If mixed, you could try to get in with Win Auth mode.

NelsonVere : What version of SQL and OS are you running?!

Are you getting any error when run SQL to make it 'single user' FALSE OR Changing from EM??

tyang,

Can you check the ERRORLOG for the exact error?! Normally your maintenance report might not show the exact error...

Thank You Brian and Allen for sharing the thoughts...

Thats exactly what I have in mind. But I kindof unstable in this idea. I am thinking of creating a group with...

I have checked few months back.Microsoft had a Training centre in Charlotte.

Thanks a lot for your help and info Allen.

Would it be a good idea to add guest to db_denydatawriter role in master database?! I wanted to feel safe with that...

Yes. I did add guest to "db_denydatareader" role yesterday. Whats the relation?! Is that how I messed it up?!?!??!?

OOPS... Sorry Allen... I was typing when you replied.

No NEWNAME Option under MODIFY FILE is introduced in SQL 2000. However MODIFY FILE with less options is supported in SQL 7.0

You need to use this to change the logical names :

ALTER DATABASE DB1

MODIFY FILE (NAME=DB1_Data, NEWNAME=DB2_Data)

ALTER DATABASE DB1

MODIFY FILE (NAME=DB1_Log, NEWNAME=DB2_Log)

We have integrated Business Objects to retrieve data from DB2/UNIX and SQL Server7/NT.

I would prefer doing Log Shipping than the other options.

I am not sure. Other members are most welcome to give few thoughts!!!