12 How to move msdb database to another drive in SQL Server

Channel Avatar
Comment
X
Share
12 How to move msdb database to another drive in SQL Server
12 How to move msdb database to another drive in SQL Server
How to move msdb database to another drive in SQL Server
SSIS Tutorials: https://www.youtube.com/playlist?listPL_YF–8vjjEVEXMf2hEFn0D5tEJV9kRqi
SSIS real time scenarios examples: https://www.youtube.com/playlist?listPL_YF–8vjjEU1Hdlqp2U_q0JNyFPYUIKY
SSIS Interview questions and answers: https://www.youtube.com/playlist?listPL_YF–8vjjEVYkoxioTCEKAkBxjLEUUB7
SQL Server: https://www.youtube.com/playlist?listPL_YF–8vjjEXhnFIdBkE90bISulbeAid2
SQL Server Developer Interview questions: https://www.youtube.com/playlist?listPL_YF–8vjjEVsr-u4uo3Hw7Aa7TzCulGc

—SQL Script

ALTER DATABASE model
MODIFY FILE(NAME ‘modeldev’, FILENAME ‘E://SQLDATA//model.mdf’)

ALTER DATABASE model
MODIFY FILE(NAME ‘modellog’, FILENAME ‘E://SQLDATA//modellog.ldf’)
———————————————————————
ALTER DATABASE msdb
MODIFY FILE(NAME ‘msdbdata’, FILENAME ‘E://SQLDATA//msdbdata.mdf’)

ALTER DATABASE msdb
MODIFY FILE(NAME ‘msdblog’, FILENAME ‘E://SQLDATA//msdblog.ldf’)
—————————–

How to move msdb database to another drive in SQL Server
How do I move Msdb to another drive?
How do I move a SQL database to another drive?
How do I move my tempdb database to another drive?
How do I change the database location in SQL Server?

If you have any questions or suggestions please comment on the video or write to me at “[email protected]”

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *