MSSQL database backup

JohnWarr · 10-10-2005, 10:56 AM

Hi,

I have a client with a dynamic website using an MSSQL database. The client is paranoid about losing this data and would like to have it backed up independently from the hosting environment. (also useful if doing many website changes and wishes to restore a previous version)

Does anyone have any recommendations on how best to do this. Can one use the online enterprise manager? Is there some cheap backup software that could perform regular backup to store the datafile copy on clients own PC for instance?

Thoughts welcomed

John

WhiskyFudge · 10-10-2005, 02:12 PM

Your best bet is create a local DTS that runs every night (or so).

10-10-2005, 10:56 AM	#1 (permalink)
JohnWarr Registered User Join Date: Oct 2005 Posts: 5	MSSQL database backup Hi, I have a client with a dynamic website using an MSSQL database. The client is paranoid about losing this data and would like to have it backed up independently from the hosting environment. (also useful if doing many website changes and wishes to restore a previous version) Does anyone have any recommendations on how best to do this. Can one use the online enterprise manager? Is there some cheap backup software that could perform regular backup to store the datafile copy on clients own PC for instance? Thoughts welcomed John

10-10-2005, 02:12 PM	#2 (permalink)
WhiskyFudge Administrator Join Date: Oct 2003 Posts: 1,484	Your best bet is create a local DTS that runs every night (or so). __________________ Jason Robbins jason@catalyst2.com

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: