I have a database I am about to Archive.
1) is it better to take a full backup of the database and archive that or to move the ldf and mdf files to the archive location.
2) the database is currently offline. do I need to detach from offline status or bring the database back to online before I detach it.
thanks a bunch!