Problem :
After I Create Cluster and I make 2 Share Disk one for Data and the another for Logs I forget to Customize the location For the database What can I do to Change this Location ?
Salutation :
You have two ways the first by T-SQL and the Second is Wizard Steps :
First Way:
A- Change the Default location for data file :
EXEC xp_instance_regwrite
N’HKEY_LOCAL_MACHINE’,
N’Software\Microsoft\MSSQLServer\MSSQLServer’,
N’DefaultData’,
REG_SZ
,N’F:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA’
GO
B- Change the Default location for Logs file :
EXEC xp_instance_regwrite
N’HKEY_LOCAL_MACHINE’,
N’Software\Microsoft\MSSQLServer\MSSQLServer’,
N’DefaultLog’,
REG_SZ
,N’G:\MSSQL10_50.MSSQLSERVER\MSSQL\Log’
GO
Second Way:
Open the management Studio >>> Write Click on the Server >>> Select properties
Then Select Database Setting >>> you Will See Database Default Location
Like this:
Like Loading...
Related
Published by Mustafa EL-Masry
I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page
https://mostafaelmasry.com/about-me/
View all posts by Mustafa EL-Masry
