![]() ![]() ![]() |
"--datadir=%DB_HOME%\data" as "--datadir=D:\Eventlog\data"
whereas, the D:\Eventlog\data is the new folder on D:\ drive.
use eventlog
go
sp_helpfile
go
use master
go
sp_detach_db 'eventlog'
go
use master
go
sp_attach_db 'eventlog' , '<New Location>\eventlog.mdf' , '<New Location>\eventlog_log.LDF'
go
use eventlog
go
sp_helpfile
go
![]() ![]() ![]() |