Jim Metcalf
asked on
archiving a database question
I have a database I am about to Archive.
2 questions.
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!
2 questions.
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.