Viewing 10 posts - 46 through 56 (of 56 total)
Also check for any open connections to the database if you have one close that...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 12, 2008 at 9:21 am
Restarting the SQL Server Service will not improve server performance. 🙂
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 12, 2008 at 5:02 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 12, 2008 at 4:53 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 9, 2008 at 7:48 am
It seems that client does not have permissions to connect to the server.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 9, 2008 at 7:41 am
Drop the user and then recreate the user with CREATE USER FOR LOGIN and then user GRANT clause to grant the permissions.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 9, 2008 at 7:38 am
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
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 9, 2008 at 7:32 am
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
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 8, 2008 at 9:07 am
may be other jobs are running at same time and due to this network error occurs
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 8, 2008 at 8:43 am
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...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 8, 2008 at 8:25 am
Viewing 10 posts - 46 through 56 (of 56 total)