Setting Default File Locations on SQL Server

I’m in SQL just about every day of the week. Supporting multiple clients with multiple SQL servers in operation, we’re regularly working on databases. Part of that process is to backup and restore databases on our local machines for development.

One of the annoying items about SQL for me is that it wants to bury your database files deep within the Windows program folder for your SQL install. I really don’t want to dig down 7 levels of folder structure to get to my files. I can see how that might be handy and serve as a layer of protection, but …read more