I used to have SIMS on a 2000 server, and had a scheduled task to back it up every night, now, I have just moved it to a 2008 server but there are no scheduled tasks there, anyone know how to do it?
Printable View
I used to have SIMS on a 2000 server, and had a scheduled task to back it up every night, now, I have just moved it to a 2008 server but there are no scheduled tasks there, anyone know how to do it?
You can set up maintenance routines in SQL server to schedule database backups. I always used SQL tools to backup SIMS never had a problem always restored fine.
How were you backing up with the scheduled task? What backup software do you use? Can this connect to SQL (most can)?
PS Do remember there are other locations that should always be backed up:
DocStore (in fact most of the SIMS folder, except for the Setups folder)
Look on the old server at the scheduled task, it'll prob run a batch file that runs dbattach with all the settings, should be able to copy it over, change a few bits and setup as a scheduled task again.
I might be missing something obvious here, but when you say there are no scheduled tasks....
Start > Administrative Tools > Task Scheduler ?
Bit of a basic way of taking a backup. Does your backup server software not have a sql agent?