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 the script before running it. […]
Tag: Database Files
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.