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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
jrriCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.