Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Sql Server change data and log path of existing database Ask Question. Asked 10 years, 5 months ago. Active 5 years, 8 months ago. Viewed 23k times. Soham Dasgupta Soham Dasgupta 4, 20 20 gold badges 73 73 silver badges bronze badges.
It is important to note that updating these locations will NOT migrate the current data and log files to the new directories. These changes will only apply to new databases created from this point forward. Turns out that setting the default database locations requires you to restart the SQL instance in order for those changes to take effect. Any additional feedback? Submit and view feedback for This product This page.
View all page feedback. In this article. I have two SQL Server instance which are running in different locations. One is in East india and second one is located in South India.
Now i want to test SQL Replication test whether it is performing or not. But let me clear you, i have only read only permission in both SQL servers. Be sure that the new log path exists and the SQLAgent service account has sufficiant permissions on that path. Otherwise, the SQLAgent service will not start and there is no way to change the path using msdb. OUT' GO. Related Articles. Different ways to execute a SQL Agent job.
Popular Articles.
0コメント