I want to make a copy of a largish SQL 2008 database (1TB). I only have 1.9TB of disk space free so I don't have enough to create a backup of the database and restore it into another.
Are there any other techniques I can use? How to I do it quickly as possible?
Is it ok to just make a copy of the MDF, LDF and NDF files - rename them and then just attach the database?