Viewing 15 posts - 2,086 through 2,100 (of 2,497 total)
What does the SQL ERRORLOG file show for the attempted start. Also, is there anything relevant in the Windows System or Application Event Logs?
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
April 12, 2007 at 7:55 am
You can move all your system databases in a single SQL session.
1) Stop SQL Server.
2) Start SQL with a NET START /T3608 command.
3) Run the ALTER statements to re-configure...
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
April 12, 2007 at 7:52 am
One thing to factor into your tests... An update of 50,000 rows may take place entirely in the buffer pool. An update of 100,000 rows may require some updates 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
April 12, 2007 at 7:38 am
Happycat59's answer is a good one. Remember when you move to SQL 2005 that the format of Agent Tokens changes. The SQL 2005 BOL has the details, and also look...
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
April 12, 2007 at 7:33 am
If you have no systems already using SQL 2005, then I reccommend you go to SQL 2005 SP2 + Hotfix rollup. Do your QA on that and resolve any issues...
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
April 10, 2007 at 3:16 am
Lynn is giving very good advice about transaction log backups, recovery mode, etc.
You also said you had the databases set to 'auto shrink'. This is bad. You should never shrink...
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
April 10, 2007 at 3:08 am
I completely agree with Joe's advice. If you do not have good in-house skills in choosing SANs, big servers, etc, then you WILL waste lots of time and money trying...
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
April 10, 2007 at 2:57 am
We recently had a departmental training day, with one particular exercise showing how damaging micro-management can be.
We were split into teams, with each team nominating...
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
April 10, 2007 at 2:44 am
That is right.
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
April 9, 2007 at 2:41 am
The SQL 2005 install media comes on 2 CDs. CD1 contains the server components, CD2 contains only the client components. If you have DVD media, you will find the components...
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
April 5, 2007 at 3:30 am
We have trialled running DTS on a 64-bit SQL 2005 machine. The only problem I found is that some custom DTS components that need to be in \system32 on 32-bit...
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
April 5, 2007 at 3:26 am
Is this the first time you have tried to start SQL after moving the system databases or changing the service account? Can you log on using the service account 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
April 5, 2007 at 3:23 am
If you run SQL Server using a domain service account, try asking for mail capability to be added to that account. As everything is not totally new, this may 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
April 5, 2007 at 3:16 am
When all is said and done, you have hit a limit on what SQL Server can do.
We had a similar problem with our data warehouse. We had to examine...
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
April 5, 2007 at 3:04 am
Very good editorial! We all need to look out for the safety of each other, otherwise no-one is safe. I would rather be embarrassed by asking someone if they 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
April 5, 2007 at 2:54 am
Viewing 15 posts - 2,086 through 2,100 (of 2,497 total)