Posts tagged SQL Server Installation

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