February 18, 2021 at 12:54 pm
Good read. Thanks!
February 18, 2021 at 5:14 pm
You can change the default file locations when installing SQL Server. You can also move the system databases later if you want to.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
February 18, 2021 at 7:59 pm
You can change the default file locations when installing SQL Server. You can also move the system databases later if you want to.
I have always found this to be a pain - there are more than just database files that should be moved and to get them moved after installation can be quite an effort.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 18, 2021 at 8:20 pm
ScottPletcher wrote:You can change the default file locations when installing SQL Server. You can also move the system databases later if you want to.
I have always found this to be a pain - there are more than just database files that should be moved and to get them moved after installation can be quite an effort.
To clarify, I'm talking just about the system dbs. Model and msdb are easy; master is a bit of a pain but it's still doable.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
February 18, 2021 at 8:48 pm
Jeffrey Williams wrote:ScottPletcher wrote:You can change the default file locations when installing SQL Server. You can also move the system databases later if you want to.
I have always found this to be a pain - there are more than just database files that should be moved and to get them moved after installation can be quite an effort.
To clarify, I'm talking just about the system dbs. Model and msdb are easy; master is a bit of a pain but it's still doable.
Yes - I know...but then you also have the security certificates, full text catalogs, error logs, default trace, agent logs, dump files and system health trace files. Moving these files requires additional changes and if those changes are not made correctly can cause SQL Server to not start.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply