How can the storage directory be changed in SQL Server?

To change the storage directory of SQL Server, you need to follow these steps:

1. Connect to a SQL Server instance in SQL Server Management Studio.
2. In the “Object Explorer”, right-click on the server instance and select “Properties”.
3. In the “Server Properties” dialog box, choose the “Database Settings” tab.
4. In the “Default Database Location” section, you can change the default storage location for data files and log files. Click on the “Browse” button to select a new storage directory.
5. Click “OK” to save the changes.

Please note that changing the storage directory may require restarting the SQL Server instance to take effect. Before changing the storage directory, make sure to backup the database to prevent data loss.