Скачать или смотреть SQL DBA – Move Database mdf & ldf files to another drive

SQL DBA – Move Database mdf & ldf files to another drive

Step #1. select * from ManDB.sys.database_files
Step #2.
ALTER DATABASE ManDB SET OFFLINE;
GO
Step #3.
Move the file(s) to the new location manually.

Step #4. Change the system catalog settings:

ALTER DATABASE ManDB
MODIFY FILE (
NAME = 'ManDB',
FILENAME = 'F:\SQLDBs\ManDB.mdf'
)
GO

ALTER DATABASE ManDB
MODIFY FILE (
NAME = 'ManDB_log',
FILENAME = 'F:\SQLDBs\ManDB_log.ldf'
)
GO

Step #5.

ALTER DATABASE ManDB SET ONLINE;
GO

Step #6.

select * from ManDB.sys.database_files

If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
Leave a comment below with your thoughts.
Add it to a playlist if you want to watch it later.


Subscribe Here:   / networkingbitsabbirkhan  

**Follow me Socially 😀

Sabbir Ahmed Khan- https://goo.gl/dMwKcM (FB)
For more Tips Tutorial- http://networkingbit.info

**Facebook page: https://goo.gl/drRSZ3

**Twitter : https://goo.gl/mxp7Au

**Google+ : https://goo.gl/pfkggD

**LIKE ➡ SHARE ➡ SUBSCRIBE
Please Like, Subscribe and Share our tutorials :)