Hi Allen,

No I did not change the SQL Server Startup account. That is the same as what SQL Server runs in. After SA PW was Changed last night, this is...

Also please note that I have SQL Mail configured with Outlook and the user profile that I have set up also had its PW changed, which I reverted back...

I usually keep an eye on free space. Another way to see is when you notice loss of free disk space on the server. Then you can check...

In SQL 7 you can use EM to see size a particular table is using.

Yes, Always use the cluster admin to stop or start any of the SQL Services. Never start or stop the services from EM or services. I restarted SQL...

Going to create another thread on this.

I had a question pertaining to orphaned logins. I am a DBA working on SQL 7. Whenever I restore a DB somewhere I manually fix the users by...

First of all the deletion of old BAK files takes place after the current BAK file is successfully created. If it fails, then the earlier bak files that are...

For this reason I think its best that SQL Server Should be the only thing running on a Production Box. As a DBA you have a better grasp on...

I normally take a full backup before and after I do this. I am using SQL Server 7 and have a standby read-only DB that I am shipping logs...

Set up some sort of archiving process. We have a similar situation. I have a dedicated box that I use for data mining. I have created a...

This is my input to index status. If you set to not automatically recompute distribution statistics, then you should manually run update statement periodically (when a large amount of...

Thank You. That did it.

Already checked. Port 1433 is not being used by any other app. Infact any other port that is used gives the same result in the SQL server error...

*.trn sizes are good indicator. If you need to regularly do these checks, might be an idea to add a date col to the tables and have the insert/update statements...