Change Plan for moving "distribution" db files to E to H drive .
1. Connect to Sever your server
2. Connect to SQL server instance MSSQLSERVER
3. Run the following query to make changes to system catalog view to point the files to the new location in which they will be .
use master
go
Alter database distribution modify file (name = distribution, filename = 'H:\MSSQL_MSSQLSERVER\DATA\distribution.MDF')
Go
Alter database distribution modify file (name = distribution_log, filename = 'H:\MSSQL_MSSQLSERVER\DATA\distribution.LDF')
Go
You should see the following results:
The file "distribution" has been modified in the system catalog. The new path will be used the next time the database is started.
4. Stop SQL Server
5. Copy the database files (Distribution.mdf, Distribution.ldf) from the drive E to Drive H location on your server . the one you used in the command above
6.Start SQL Server
7.Review no errors are present in the SQL Server error log related to not being able to open the DB
8 .Review all agents working properly.
1. Connect to Sever your server
2. Connect to SQL server instance MSSQLSERVER
3. Run the following query to make changes to system catalog view to point the files to the new location in which they will be .
use master
go
Alter database distribution modify file (name = distribution, filename = 'H:\MSSQL_MSSQLSERVER\DATA\distribution.MDF')
Go
Alter database distribution modify file (name = distribution_log, filename = 'H:\MSSQL_MSSQLSERVER\DATA\distribution.LDF')
Go
You should see the following results:
The file "distribution" has been modified in the system catalog. The new path will be used the next time the database is started.
4. Stop SQL Server
5. Copy the database files (Distribution.mdf, Distribution.ldf) from the drive E to Drive H location on your server . the one you used in the command above
6.Start SQL Server
7.Review no errors are present in the SQL Server error log related to not being able to open the DB
8 .Review all agents working properly.
