I am sorry, run it from query analyzer.

Just run dbcc shrinkdatabase(tempdb)

from DA. it's that simple.

Robert

In EM, try to click on tools, select option,

click advanced, then change query time_out time.

Robert

Only for restoring master database, you must start sql server with sqlservr.exe -m, then you can do the restore.

Robert

select what you want to print from QA, then save as word document and print

Robert

It seems to me this is sql login timeout.

When more than one user login at the same time, it may happen. The sql2k default time is 4 second. If you...

Forgot to mention. If the initial log file is so big, you don't want it so big, then you can use detach and attach the log file

to reduce it.

...

If the initial file size is so big, you can't shrink it to smaller. If the log file grows so big, you can do the follows:

1, Back up the database,

2,...

Don't choose repair minor problem, that needs database in single user only. If you really needs to repair any errors run dbcc repair database.

Robert

You can run dbcc shrinkdatabase(tempdb)

from QA anytime.

Robert

Could you tell us your procesor and memory?

and the cpu usage, memory usage.

Robert

Thanks for the reply.

I do backup the db everyday and the trans log file every hour. I optimize the db every Sunday. After optimizing, the trans log file...

Hi Allen,

I checked the error log file. It says "The specified network name is no longer available".

In fact, I backed up all DBs to the same server with the same...

I had the same problem with similar error messages. My job backs up more than one hundred databases. about 30 each with 3 GB, the others are small one. I...

I mean if it is for win2k advanced server then only 1 gb for sql server.So if I want to give sql server 3 GB, then just input 1 GB...