Well, If your sysadmin is worth his salt (MCDBA) there will be at least 5 days backup for a given week all of which should be backed up offsite as both hard copy (CD/Tape) or online - using something like Iron Mountain.
Of course, if you can access the SQL machine from your local machine (I do hope its only by VPN!!) then just take your own backup of the .BAK file, though this could have impact on bandwidth depening on your DB size. It is not good practive to use Enterprise Manager to connect to a Production DB - you shoudl certainly not connect to a table via EM in production. N Maureen wrote: > Do you have SQLServer administrator on your local machine. or access > to the administrator on on the remote machine? If so, you should be > able to just set up data sources to the remote data and the local data > and copy everything over as often as you wish, or run a backup with > the local machine the destination. You can also configure SQLServer > to send you an email if the backup runs successfully, or if it fails.. > > On 12/10/05, mkear @ afpwebworks. com mkear @ afpwebworks. com > <[EMAIL PROTECTED]> wrote: > >> I'm sorry if this is a really elementary question, but can you backup a >> remote SQLServer database to the local machine? >> >> I'm not convinced my Sysadmin is being as diligent in doing backups as he >> says he is, and just to be on the safe side, I'd like to be taking backups >> of my web site databases myself. I don't want to find out whether he's >> doing the backups by not having one when it's required. >> >> Up to now, I've been covering my a$$ by using DTS to take copies of the data >> to my local machine but the problem with that is I only have one copy of the >> data, and can never go back further than the last DTS copy. I'd like to >> have an organised backup process, where the backups are automatically taken >> from the remote databases, but the backup files are held here on my own >> machine. >> >> Is this possible? If so, can someone give me details? >> >> >> Cheers >> Mike Kear >> Windsor, NSW, Australia >> Macromedia Certified Advanced ColdFusion Developer >> AFP Webworks Pty Ltd >> http://afpwebworks.com >> Full Scale ColdFusion hosting from A$15/month >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2420 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
