Backing up secured database

[Bill0722]

If I back up a secured database, with user level security, how do I restore and use it if my original database became trashed. As always, thanks.

 

[Ed2020]

How are you backing it up?

If you're just copying it to a separate physical location then simply make sure you are copying all system files including the MDW file. If you need to restore copy all the files back to their original locations.

Ed Metcalfe.

Please do not feed the trolls.....

 

[Bill0722]

Actually, I'm not doing anything yet. I'm just finishing up my first project and am looking for the best way to back it up. I was just going to use the backup command under the file menu, but will this also back up my security file. And if my original database gets trashed, how would I restore it from this file.

If you have any better back up solutions, I'd appreciate them.

Thanks,

Bill

 

[ClydeData]

Im using Mozy the automated internet backup service

https://mozy.com/?ref=9YU2YK

2Gb of free Offsite backup (30 Gb of extra space can be bought for 5 dollars a month).
All my database files are backed up remotely every night.

I also use this in conjunction with

http://www.backup995.com

for a local backup to a USB drive, and

http://www.box.net/

another remote backup service with drag and drop.

Hope this helps

Jimmy

 

[Ed2020]

The backup command in MS Access only backs up the currently open database (I believe) so this will not back up your workgroup file. Nor will it backup the backend if you are in the frontend (or vice versa).

For a simple solution I'd use the FileCopy command to backup the frontend, all associated backends, and the MDW file to a physically (not logically) separate drive.

Assuming the database resides on a network drive it should be getting backed up, along with the rest of the files on the network, on a nightly basis anyway...

Ed Metcalfe.

Please do not feed the trolls.....