Viewing 15 posts - 871 through 885 (of 2,497 total)
In the Microsoft world, clustering is mainly intended to be a high-availability solution, not a DR solution. You only get a degree of DR protection if you have geographically...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 23, 2011 at 7:57 am
Back in 2001 I was dealing with a customer who had a 14 TB database. Although this was not on SQL Server their approach to backup would work fine...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 23, 2011 at 7:30 am
There is some extra configuration you must do on SQL 2008 R2 to get DTS Designer work - some files must be copied but this is all documented in BOL.
I...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 22, 2011 at 4:31 am
From the small amount of information given, it looks like the cluster service is trying to write to its \Temp folder in the cluster service profile. Can you confirm...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 22, 2011 at 4:10 am
I think you need to review the risks and issues of what you want to do. It is very easy for technical folk to focus on how to solve...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 22, 2011 at 4:03 am
Personally, I would not touch any of the indexes supplied by Microsoft. This is to avoid any issues with them if you need their support for any issues within...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 22, 2011 at 3:42 am
If you are on W2003 you are probably also on old hardware that is nearing the end of its useful life. As part of a platform refresh you are...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 9, 2011 at 4:18 am
My main concern when installing SQL Server is build consistency. I want the assurance that if the server had to be rebuilt then SQL Server would behave in exactly...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 8, 2011 at 5:19 am
If user AAA who is a member of domain\TEST group is also a member of domain\LIVE group and the domain\LIVE group has access to your database, then that user has...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 8, 2011 at 3:38 am
What did you find in SQL9_Hotfix_KB2494112_sqlrun_sql.msp.log
and the other log files?
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 3, 2011 at 3:13 am
If the failure happens while the setup support files are being installed, you may find the log files in a Temp folder, either the system temp folder or your personal...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 2, 2011 at 6:39 am
You probably need to take this step by step.
First, you say you are running Active/Acvtive. This means you have at least two clustered SQL instances installed, and instance1 is...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 1, 2011 at 5:08 am
You can learn a lot by reading the books, but until you set up a cluster yourself the full horror of what you are doing is not apparent 🙂
If you...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 1, 2011 at 4:54 am
Each clustered SSAS instance on a cluster is in its own resource group with its own IP address. Therefore multiple clustered SSAS instances can all listen on their own...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 1, 2011 at 4:45 am
Ther are significant schema changes in the Report Server database between SQL 2005 and SQL 2008. By doing this restore you are putting your system outside of Microsoft support....
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 25, 2011 at 9:59 am
Viewing 15 posts - 871 through 885 (of 2,497 total)