Viewing 15 posts - 5,716 through 5,730 (of 6,678 total)
SQLBOT (1/5/2009)
Will a restore work for getting the backup into a readable active log?~BOT
Nope, a restore will restore the database and apply the changes stored in the transaction log backup....
January 5, 2009 at 1:47 pm
It is not a Kerberos issue - please read the document I linked to for further information. On Win2008/SQL2008 you cannot just add a user to the local Administrator...
January 5, 2009 at 9:30 am
Well, then add the COUNT windowing function.
SELECT (ROW_NUMBER() OVER (PARTITION BY r.RaceID, ORDER BY someresultformula))
/ (COUNT() OVER(PARTITION BY r.RaceID)) AS...
January 4, 2009 at 2:47 pm
BTW - the key here is the combination of Windows Server 2008/SQL Server 2008.
January 4, 2009 at 2:36 pm
Did you validate the BUILTIN\Administrators group in SQL Server 2008? I believe the problem you are having is the fact that security has changed on Windows Server 2008 -...
January 4, 2009 at 2:33 pm
Jayakumar Krishnan (1/4/2009)I ensured that the group where the NT user member of is Admin of the box, the same config on this box is followed other boxes as well...
January 4, 2009 at 12:06 pm
Well, just for that you don't need SQL Server Agent. If that is all you are doing, you might want to consider installing SQL Server Express instead. Download...
January 3, 2009 at 10:38 am
Review the event logs for any errors when trying to start SQL Server Agent. You can also review the SQL Server error logs for any messages there.
SQL Server Agent...
January 3, 2009 at 10:28 am
No - I don't think that it related to SAN. Most likely you have the default backup directory defined to the D: drive. You can find it by...
January 3, 2009 at 12:07 am
Is there a question here?
FWIW - item #1 is debatable and you will get people on both sides of the issue. I personally setup my service accounts as local...
January 2, 2009 at 7:04 pm
This looks like the original SP2 release - which had several problems. I would recommend upgrading to at least 9.0.3054 (at a minimum). Ideally, if you can apply...
January 2, 2009 at 3:20 pm
Preet (1/2/2009)
bbbrian007 (12/27/2007)
Maybe in the future, Microsoft will improve their optimization...
January 2, 2009 at 11:23 am
Oops - I read that wrong. Index ID 0 is a heap - ID 1 is a clustered index.
January 2, 2009 at 11:11 am
No problem - glad I could help.
January 2, 2009 at 10:43 am
Phil Factor (1/2/2009)
January 2, 2009 at 10:41 am
Viewing 15 posts - 5,716 through 5,730 (of 6,678 total)