January 11, 2010 at 5:45 am
Hai
how to back the data in my server for every 3 hrs automatically
January 11, 2010 at 5:53 am
praveen640 (1/11/2010)
Haihow to back the data in my server for every 3 hrs automatically
1. create new job, with t-sql statement to back your DB's, schedule to run every 3 hours.
2. Maintenance plan - schedule included.
3. Create dtsx package in SSIS, with Backup tasks, schedule package in job for every 3 hours.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 7:56 am
If there are large databases, you might want to do a FULL backup at night, then a Differential every 3 hours and transaction log backups more frequently, such as every 15 minutes... The plan you choose depends on how critical your data is and how often it changes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply