Viewing 15 posts - 1,711 through 1,725 (of 2,497 total)
Any suggestions?
This is much a company procedure issue as a permissions issue.
Draft a note about prohibiting the restore of databases to C:, and get a high-level manager 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
March 25, 2008 at 3:26 am
The standard industry practice to prevent people hacking into your data file is encryption.
SQL Server supports encryption of its databases. If the DBA does not know the encryption key,...
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
March 20, 2008 at 6:25 am
Just a guess, but have you checked that the SMTP server still has the same address, is still working, and there is still a route through your local firewalls from...
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
March 19, 2008 at 4:01 am
If you want some scripts that will do these moves, try SQLServerFineBuild.
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
March 19, 2008 at 3:53 am
It may be safe to remove the log files, but this will be just a very temporary solution. The next time fixes are appiled to Windows, the install process...
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
March 19, 2008 at 3:49 am
I completely agree on the need to test the restore process by starting with getting the tape (or whatever) from offsite storage.
This tests a lot of thing you need in...
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
March 19, 2008 at 3:38 am
Once you have confirmed the new install location and that your system databases are referencing it then you can manually remove the c:\program files\microsoft\sql server
Don't do this unless 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
March 19, 2008 at 3:22 am
I agree that getting a vendor product to do the scripting is likely to be the most comprehensive answer.
However if you want something free, take a look at SQLServerFineBuild. ...
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
March 18, 2008 at 3:58 am
I certainly reccommend running CHECKDB, but I think it should be run at the most convenient time of the day which may not be when you do a backup.
At my...
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
March 18, 2008 at 3:50 am
If you have multiple instances on a box, they will all compete for the available memory. None of the instances are aware of what the others are doing, so...
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
March 18, 2008 at 3:39 am
You may need to change the service account logins. See BOL on how to do this.
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
March 17, 2008 at 4:35 am
You cannot change the permissions on any system object in SQL Server 2005 & 2008. This is because the permissions are held in the mssqlsystemresource db, which 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
March 17, 2008 at 4:31 am
If you are looking for scripts to smooth the SQL Server 2005 install process, try http://www.codeplex.com/SQLServerFineBuild. This gives you a single-click best practice install and configuration for SQL.
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
March 17, 2008 at 4:24 am
My take is that if the Windows admins want it moved for existing installs, they need to show the costs, downtime, risks and benefits involved in the move. If...
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
March 14, 2008 at 5:43 am
A lot of Windows Administrators like to keep the system drive reserved for the OS as far as possible. If this is happening at your place it is 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
March 14, 2008 at 3:27 am
Viewing 15 posts - 1,711 through 1,725 (of 2,497 total)