• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

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!
0
jamesmetcalf74
Asked:
jamesmetcalf74
1 Solution
 
Scott PletcherSenior DBACommented:
Vastly better to take a full backup, for several reasons:
1) it will be smaller than the mdf and ldf files
2) you can use compression to make it even smaller (if you have Enterprise or other edition than can compress backups)
3) (mildly) easier to restore it.

I'm not 100% sure if you can backup an offline db or not -- easiest would be to just try it and see if it works :-).
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now