DotNetShoutout - Change location of database file + correct logical file name of the database file

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

4
Shouts

Shout it

Change location of database file + correct logical file name of the database file

published 436 days, 17 hours, 13 minutes ago posted by

dhara 442 days, 6 hours, 28 minutes ago

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this I had to use to the below sql.

category: Data | clicked: 101 | | source: beyondrelational.com | show counter code

tags: SQL Server

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout