Viewing 15 posts - 1,501 through 1,515 (of 2,496 total)
Part of being a good DBA is risk asessment. We know that Microsoft have hardcoded assumptions about where the resource db is located within the SP2 install, so we...
February 5, 2009 at 4:22 am
Have a look at SQL Server FineBuild. Even if you decide you don't want to use the scripts to do the installs, it can be worth raiding the Reference...
February 4, 2009 at 7:13 am
George,
Maybe it does not matter what the folders are called, I have not tried different folder names.
Provided that the CD1 media is in a different folder to the CD2...
February 4, 2009 at 5:14 am
Personally, I would not move master or model, for slightly different reasons.
The SP2 install places a new version of mssqlsystemresource into the original location of this database (as defined at...
February 4, 2009 at 3:12 am
Anders, it sounds like you are saying that if an organisation gets themselves a bad outsourcing contract then they can have problems. Sounds logical to me...
February 4, 2009 at 2:40 am
You should look in the SQL install logs to find the root cause of this problem.
The Agent account is the first account to be validated, and the same error message...
February 4, 2009 at 2:35 am
The /AGTSVCPASSWORD parameter does not like the password value to be in quotes.
I said this in a previous post in this thread because I had an install that failed...
January 30, 2009 at 2:55 am
I have had a similar problem when trying to install on a guest server. The local accounts are accepted but the domain accounts are not. The cause of...
January 30, 2009 at 2:43 am
You should be able to write a script to generate the necessary SQL Agent jobs.
January 29, 2009 at 7:07 am
On a 32-bit box, the limit of 4GB is there because that is the largest number you can hold in a 32-bit integer.
32-bit Windows uses some special code called PAE...
January 29, 2009 at 6:06 am
Can anyone answer what that % for the TotalServerMemory that is set in SSAS properties actually specifies
On a 32-bit box, this refers to memory below the 4GB line. On...
January 29, 2009 at 5:53 am
Sorry, that was a typo. I have corrected it to say /3GB.
If you have more than 16GB on the box, you must NOT use the /3GB switch. This...
January 29, 2009 at 5:49 am
Do you have /3GB set in BOOT.INI? If not, then 1.6 GB is about all that AS will be able to get on your server.
If you do not have...
January 29, 2009 at 5:06 am
In SSMS, right-click on your AS instance and select Properties. Scroll down to find the Memory options and set these as required, using the Value column. See BOL...
January 29, 2009 at 3:26 am
Take a look at FineBuild for SQL Server 2008 http://sqlserverfinebuild.codeplex.com/releases/view/47333
SQL Server FineBuild gives 1-click installation and best-practice configuration of SQL Server. It gives everyone a rock-solid foundation for exploiting...
January 29, 2009 at 3:17 am
Viewing 15 posts - 1,501 through 1,515 (of 2,496 total)