Here is my 2cents,

There are two options to shrink file/Database. If you use "TRUNCATEONLY" option, since iti s not mvoing any data and just take off tailed unused space back...

Actually, that is normal behavior for SQL server.

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

I'd just lower the Max vaule just a bit to have other extended store procedures have space to use that memory.

I've never done Chinese Characters but I've dealt w/ unicode before and based on that, let me try to answer as much as I can. However, all I am saying...

I still haven't found the best solution for that but so I am using two different way to deal with that.

One, using DTS package to copy the data over the...

First, that is not sql error that you should look at the first place even though that error might cause the failure. Go to windows directory and search for sqlstp.log...

Not sure this is the right one but, first, I'd event log to find out why it is doing that or get any error message and also check the disk...

I just would like to let you know what I've been experienced with our NetApp box as SQL Server db Disk Storage. I am using NetApp F740.

This product was working...

When you said, general performance monitoring, do you want to watch, any dead lock, number of active transactions, cpu, ram useage, etc?

Also since it is on a  different...

Correct me if I am wrong but I think what SQLBill asked about permissions was about SQL Service Account that run SQLServerAgents and MSSQLServer. If it was setup to use...

I asked like above because the golfer wrote that "I can connect through enterprise manager to a default instance of sql 2000". That means at least network either already opened the right port...

How about this way,

First, get the port number that instance is using. If you don't know, you can get into the box and open the "SQL Server Network Utility" and...

Hi sa24,

It wasn't related to database backup or database status makred as suspect. I don't think it is related to my case but thank you for the link.

I'd Like to know what is the version of the SQL server that you are using?

It sounds like it. Thank you for the input