Wednesday, August 20, 2014

Method to Move the database Log files (MS SQL)





alter database <db_name>


MODIFY FILE ( NAME = 'WPSBankDB_Log2', filename = 'path where it needs to be moved')


 

alter database <db_name>


MODIFY FILE ( NAME = 'WPSBankDB_Data2', filename = 'path where it needs to be moved' )