michael.kaufmann (2/23/2011)

---

SUPER SQL STAR (2/22/2011)

---

GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..

The directories for the default data files, log files and backups are stored in the system registry. As mentioned already you have the ability to change the default data and log directories using SQL Server Management Studio, by right clicking on the server name and selecting properties and navigating to the Database Settings page as shown below.

...

Super SQL Star,

are you Greg Robidoux and is this your pseudonym here on SSC?

If you aren't, please give credit to Greg and quote that you copied from his excellent post (http://www.mssqltips.com/tip.asp?tip=1583), as Tejaswili Patil already pointed out.

Regards,

Michael