Viewing 15 posts - 586 through 600 (of 2,497 total)
Just realised you were doing this on SQL 2005. Be aware that the SQL 2005 SPs and CUs have a poor record of being able to work if master...
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 6, 2013 at 9:25 am
What you want to do is a bit like cutting open your chest and connecting your major blood vessels to another heart. It can work, but do not be...
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 6, 2013 at 9:23 am
Reporting Services for SQL 2000 was a separate component with its own install process. It will also need IIS installed for it to work.
Best of luck in finding the...
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 6, 2013 at 9:13 am
This should work. We have had to do the same process to increase the size of some of our AWS EBS disk sets.
Also, for AWS we have decided it...
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 5, 2013 at 6:19 am
Separating the data and log files are a company policy
Once upon a time this policy did not exist. Then it got created.
You need another company policy that says 'Leave...
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 30, 2013 at 2:48 am
If you are running on Windows 2008 or Vista or above, then the Administrator account has two sets of authorities. This is built in to Windows and you cannot...
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 30, 2013 at 2:39 am
DB mirroring cannot work due to the latency. This is cross site. sql edition is enterprise.
Asynchronous mirroring will work over any distance.
Your choices are limited by the technology available and...
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 15, 2013 at 3:23 am
Work out the risks of your approach and the risks of other approaches, and discuss these with your manager. Part of your manager's job is to approve the work...
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 15, 2013 at 3:06 am
How did your Windows instances get created? Did someone do a Windows install, a Sysprep type install, or simply clone an existing system.
If your system was cloned from a...
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 9, 2013 at 8:50 am
We use SQL P2P replication to provide scale-out, high availability, and resilience. It does what it says on the can.
There are some warnings in the P2P documentation about quiescing...
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 5, 2013 at 3:37 am
Sounds like you had a problem while the Setup Support Files were being installed. Until this process has got near finishing you do not get any log files.
The most...
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 3, 2013 at 3:44 am
The high-risk approach is to shut down the servers, move them to the new DC, then start them up. It can be done, and I know of organisations that...
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
June 26, 2013 at 6:31 am
If your licences are under Software Assurance then you are bound by the SQL 2012 licensing rules even if you are running an older version of SQL Server.
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
June 26, 2013 at 6:18 am
Do you manage both Windows and SQL Server, or is there somebody else who manages Windows at your organisation.
If someone else manages Windows, then ask them to set up the...
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
June 26, 2013 at 6:08 am
As others have said, running mixing non-Production and Production on the same server is a bad idea.
One of the main issues is Governance. It is established good practice to...
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
June 25, 2013 at 7:48 am
Viewing 15 posts - 586 through 600 (of 2,497 total)