If you are using Software Assurance, then from the date of your next SA review after SQL 2012 is released I am told your SQL Server licences will be moved...

The reason the two backups were different sizes is almost certainly due to the additional space map pages that get inserted into SQL Server as files grow.

A single space map...

The NT SERVICE\SQLSERVERAGENT and NT SERVICE\MSSQLSERVER entries are what are known as Service SIDs. Google can tell you more about what these are.

To me, it looks like your SQL...

I suggest you look at Ola Hallengren's databae maintenance solution. http://ola.hallengren.com/ It has won a number of awards, and is likely to be a lot more reliable than something...

DUPLICATE POST

Please reply using http://www.sqlservercentral.com/Forums/Topic1250853-146-1.aspx?

The account needs to have the Domain 'Add workstations to Domain' right.

This can be granted on its own via a script, or your account can be added to...

My understanding of how AWE works means that AWE is not available on a 64-bit OS. Therefore the 32-bit SQL Server functionality that allows use of memory above the...

Don't forget that if you are running on Windows 2008 or above, ther are useful performance benefits from having one MSDTC instance per clustered node if you are running any...

There are a few things that can help.

http://sqlinstaller.codeplex.com aims to integrate the SQL install into .Net applications. My guess is that it provides some classes that act as a...

FineBuild aims to provide a SQL Server installation complete with requested Service Pack and CU plus best-practice configuration from just a single click.

I have also seen some other SQL installation...

IMHO unless you get to above 1TB, there is very little advantage to taking a differential backup compared to a full backup, especially where the full backup is at a...

I've never got to my FU level, but I have there are more important things than trying to get it. At the start of 2010 I dropped to half-time...

The SQL Server install checks the operating system when it starts, and Windows 2000 fils this check.

The error message will tell you the name of the rule that does the...

For me, the main changes in SQL 2008 clustering compared to SQL 2005 are:

1) Explicit install options for creating the first node and adding additional nodes. This stops potentially...

Unfortunately most of the information in this link is wrong applies to Windows 2008 but not to SQL 2008. The multi-subnet clustering and support for OR dependencies never made...