** Myself
Relocate physical logfile
*) Detach the database. Use SP_Detach_db procedure
*) Move the log file alone from C: drive to D: drive
*) Attach the db using SP_attach_db procedure as shown below
sp_attach_db 'TEST','C:\sql\test.mdf','D:\sql\test_log.ldf'
0 comments:
Post a Comment