I want to backup a SQL Server database by copying its files manually. Is copying the
database.LDF files enough or should I also add more files?
It might be not the proper way for backing up a database, but in certain cases it might help for testing purposes for example.
Suppose you are left with a corrupted OS with no any DB backups ,but you can still plug it as HDD and get those files containing the data available in C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQL2008\MSSQL\DATA and run the following commands
Create database dbname. On. ( Filename= 'mymdf.MDF', Filename ='mylog.LDF'. ). For attach;