Installation & Configuration

This category contains useful information relating to the installation and configuration of SQL Server

Detach, Move, and re-Attach database

0
12 months ago
in
The Transact-SQL Script below, is useful if you want to standardise the location of your databases. I have been managing a server whereby databases created by other people were created all over the place!! Therefore, this script was written to make life so much easier. Be sure to read through [...]

Reinstalled SQL Server 2005, with the wrong collation??

0
3 years ago
in
If yes, then following the instructions below, from MSDN (http://msdn.microsoft.com/en-us/library/ms179254.aspx): Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them. See my note below Export all your data using a tool such as bulk [...]

Problems with installing SQL Server

0
3 years ago
in
If you are trying to install SQL Server 2005, and receive an error regarding the SQL Server Native Client package being missing, go to your “servers” install CD/folder, and right-click on the sqlncli.msi file, and click on Uninstall. Once uninstalled, just re-run the setup again, and it should [...]

Move “tempdb” database

0
3 years ago
in
When SQL Server is installed, the “tempdb” database is placed by default, on the same drive that SQL Server is installed on. As this is usually the same drive as the operating system, it is best to move the “tempdb” database to a separate drive. To move the “tempdb” database to a separate drive to [...]
Go to Top