DRAG DROP
You install a Microsoft SQL Server 2008 R2 instance that uses default settings.
You want to add a storage area network (SAN) array. The SAN has two mapped drives: D
and L.
You need to ensure that all new databases meet the following requirements:
-Data files are stored on drive D in the SQLData folder. -Log Files are stored on drive L in
the SQLLogs folder.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

Answer:

Explanation:

Note: In SSMS, right click on the server and choose “Properties”. On the “Database
Settings” page of the Server Properties window, specify your new locations for data and log
files.

You could also do this with T-SQL by writing directly to the registry:
USE [master] GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’,
N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’DefaultData’, REG_SZ,
N’E:\YourData’ GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’,
N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’DefaultLog’, REG_SZ,
N’E:\YourLogs’ GO

sql server 2008: setting default location for mdf/ldf