Viewing 15 posts - 421 through 435 (of 756 total)
pshaship (7/12/2011)
Reason for the issue:
The SQL Server service account abc\mssqlsrv did not exit in logins on both Principal & Mirror
Solution:
Add the service account in logins on both the servers...
July 20, 2011 at 8:49 am
4u.chethan,
4u.chethan (7/19/2011)
SQL 2008 RTM version fails everytime when you install on 2008 R2 windows serveryou have to do slip stream installation
Thank you for sharing the link!
July 20, 2011 at 8:34 am
Can you connect by using the IP-Address and the port number?
July 20, 2011 at 7:49 am
Indeed the price of SQL Server makes it very attractive when compare to Oracle. To me the nicest thing about SQL Server is the community. You will find tons of...
July 20, 2011 at 7:12 am
SQLRNNR's advice of creating the new file on a different disk is very good. Considering that your database is growing 6 Gb per week (312Gb per year), you may want...
July 20, 2011 at 4:04 am
Gila's post is very elaborate, a quick read will help you out, so please read her post and let us know if your problem has been solved.
July 20, 2011 at 3:52 am
David, if you have time and the answers, it will be very nice if you can answer Ninja's questions, so that other people with the same problem can solve it...
July 20, 2011 at 3:36 am
Elliott Whitlow (7/19/2011)
However, I have some pretty serious concerns. If you are a new DBA your first real project should not...
July 20, 2011 at 3:17 am
To the best of my knowledge a Service Pack (SP) will always include all updates (major and critical) that have come before. You dont need to go bit-by-bit through the...
July 19, 2011 at 10:11 am
I think this link http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7218 will answer your question. good luck! 🙂
July 19, 2011 at 9:59 am
There are many ways of doing that. You can use SSIS to create a package that does the restore of the backup of the production database. If you are only...
July 19, 2011 at 9:51 am
How did you check the CPU usage?
One of the links I checked http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/e2ddf26f-f86c-4368-b4a7-17b2b7c64aa5/ mentioned:
SELECT scheduler_id, current_tasks_count, runnable_tasks_count
FROM sys.dm_os_schedulers
WHERE scheduler_id < 255
If you see the runnable tasks count above...
July 19, 2011 at 9:47 am
GSQUARED gave you a very good tip regarding the SQL version. Regarding the hardware, the first thing you should mention is what is your budget. According to your budget you...
July 19, 2011 at 9:43 am
Phil Melling (7/3/2011)
Phil Melling (7/1/2011)
I'm sorry, but putting it in to simple is bad advice.
I should probably add that it's not my intention to be rude or to put people...
July 3, 2011 at 8:54 am
Viewing 15 posts - 421 through 435 (of 756 total)