How can I safely detach a data base from GFI MAILARCHIVER and move it to backup server as a .BAK file?

I just started a new job and they use GFI Mailarchiver 6.4 for their mail archiving. I can see the server is running out of space and it appears the previous engineer used to detach older databases and moved them to a mapped drive on another server as a .bak file.  I am in the GFI configuration and am logged into the server also. If someone could point me in the right direction, I would appreciate it..thanks
LVL 1
Thor2923Asked:
Who is Participating?
 
jrriConnect With a Mentor Commented:
I do this with GFI also, the below should help

1st in GFI go to the particular DB you want to remove and edit it,uncheck searchable,and the other check box that allows writing.

2nd simply detach them in the SQL management program and then move the actual .MDF file to where ever you want.

3rd i backup the removed DBs in there new location on my monthy ONLY backup

4th if you need to view mail from an old DB, simply copy it back into the directory where the current DBs are and attach it, then go to GFI and add it in and only make it searchable not writeable.

The .bak is an acutal backup performed by SQL not the actual database.
0
 
Kobe_LenjouCommented:
Is this using a SQL server? (I'm not familiar with GFI Mailarchiver).

But detaching/attaching is a quite simple. Using SSMS, right click the database and select 'detach'. Move the files and re-attach then using SSMS
0
 
Thor2923Author Commented:
yes we are using SQL 2008 R2...I will check into your suggestion. It appears the previous guy was able to get them into BAK format. Does that make sense?
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Kobe_LenjouCommented:
BAK would suggest that those are backup files. But the extention of files is free in SQL server.

Do you actually need the old databases to be online? Or just archived?
0
 
Thor2923Author Commented:
archived at this point. I am told GFI cannot access them properly if they are dragged to a mapped drive on another server. The databases would need to remain no the physical hard drives, as I understand it. I also have a ticket in with GFI to confirm this
0
 
Thor2923Author Commented:
thanks for the info irri....I want to ask kobe though. How can I back up an individual data base and have a .bak file end up on a mapped drive on the SQL server. I am assuming I would use the object explorer and right click the database I need to back up and select TASKS then BACKUP...is that correct? If I point to the mapped drive with a .bak file end up being saved there?
0
 
Kobe_LenjouCommented:
THe mapped drive won't work, since you're taking the backup as the user running the SQL Engine.
But you can backup directly over the network, just type in the UNC path by hand and make sure permissions are ok
0
 
jrriCommented:
Thanks for the points, this has worked well for us and once the DB is detached and moved to the archive directory, you can use your regular MONTHLY backup instead of the daily or weekly which cuts down on their size.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.