SQLTeam.com | Weblogs | Forums

Copy MDF and LDF to new location


#1

HI gurus

I would like to know the best practice to copy MDF and LDF files from one location to another LUN location

Thanks a bunch


#2

Have a look on this error discussed here in detail: https://dba.stackexchange.com/questions/52007/how-do-i-move-sql-server-database-files
Simply you could do this with detach/attach of SQL Server Database files.
Also, have a look on this explained the procedure to attach MDF file