SQL Database Backup

looking for ways to back up Database from remote server

[zolat1]

Is there a way to backup an SQL Database locally when it is being hosted by someone else. The hosting company does a daily incremental, weekly, monthly and a full backup and rotates the tapes to an off site storage facility.

Problem is, if we wanted to change hosting companies, how would we have all the information that we have uploaded thus far without having to do it all over again?

I can access it through MS Access also and was wondering if there is a way to extract the DB with ALL the info about our products intact. I don't know much about Access, is it as simple as Exporting the data? or is there more?

Any information would be much appreciated.

Thanks

[sun818]

Are you talking about Microsoft Access or Microsoft SQL Server? If you have a licensed copy of Microsoft SQL Server (even Developer Edition), there is an Enterprise Manager tool that will let you import and export the data in full to and from your desktop. There is a variety of import/export formats you can use, Microsoft Access being one of them.

[wackal]

ms access has a feature called an access data project. basically, access is the front end client that connects to a sql server db. you can then backup db in the tools option. hope that helps.

[Corey Bryant]

Do you have MS SQL on your local computer? You can also ask the hosting company to send you a back up. Most should comply with that request

-Corey

[martyt]

My hosting company does a nightly backup for me and places the file in a directory I can access via FTP.

It's trivial for them to set up the backup job, and if they refuse, I'd consider taking my business elsewhere (provided you can get a backup on your way out!)

[zolat1]

No I don't have MS SQL on my local computer.

Thanks for all the input.