Also check for any open connections to the database if you have one close that...

Restarting the SQL Server Service will not improve server performance. 🙂

Because you have not included the witness server it does'nt automatically update the status if you are stopping the sql server service. Automatic Failover is only supported if you include...

You can predict the size of your database in the logical design phase of your database by calculating the size of your tables and then calculate its expected growth in...

It seems that client does not have permissions to connect to the server.

Drop the user and then recreate the user with CREATE USER FOR LOGIN and then user GRANT clause to grant the permissions.

I cannot find any information regarding SQL Server 2005 service pack 3 on Microsoft website. Any one of you got any idea when it is due to be released.

ALI

Hi

I think the best way for archiving the data is to use SQL 2005 feature i.e. partition tables to split the data across multiple filegroups.

Ali

may be other jobs are running at same time and due to this network error occurs

Hi,

I don't agree with this that degree is not important. I think degree is very important if you have one from good university because you do your research in that...