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:2419 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=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
