- Create two folders and grant read write permissions to service account
d:\master_data e:\master_log
- Find the current path
- Stop SQL Server
- Move the files (master.mdf, mastlog.ldf) into new folders
- Go to SSCM --> R.C on respective instance SQL Server Service --> properties --> Advanced --> Startup Parameters--> Change the path of data and Log file
- Apply --> OK
- Start the service.
- Go to SSMS --> check the new path
No comments:
Post a Comment