Grommit Posted October 17, 2006 Posted October 17, 2006 How do you back up SIMS.. Do you get SIMS to do its own backup via the System Manager everynight ? (how do I automate this?) Or just use Backup exec or NTbackup to backup the whole MSSQL folder to tape and disk ?
MkII Posted October 17, 2006 Posted October 17, 2006 We have some sort of scheduled job(set up by our central team), plus another to stop the database, copy those locked files then re-start.
kingswood Posted October 18, 2006 Posted October 18, 2006 We have some sort of scheduled job(set up by our central team), plus another to stop the database, copy those locked files then re-start. That's kind of what we have too.
apeo Posted October 18, 2006 Posted October 18, 2006 We use Backup exec to back up the sims database nightly and use the System Manager backup to do on the fly backups.
djm968 Posted October 18, 2006 Posted October 18, 2006 One option I have used in the passed, was to write a script to stop the SQL service, xcopy the SIMS.LDF and SIMS.MDF pair (the SQL database) and xcopy the entire SIMS folder to another server. The advantage of this is that you could have a "warm" backup.
stitch Posted October 18, 2006 Posted October 18, 2006 We use Backup Exec along with the SQL agent add on.
ajbritton Posted October 18, 2006 Posted October 18, 2006 Custom script which calls DBATTACH to make a SIMS backup then calls NTBACKUP to backup to tape.
Grommit Posted October 18, 2006 Author Posted October 18, 2006 Custom script which calls DBATTACH to make a SIMS backup then calls NTBACKUP to backup to tape. Thanks Guys... I am using Backup Exec with SQL add on... but I would like to have what ajbritton or djm968 use... AJ do you have the script that can co Backup exec as that would alsso be a warm backup someting like djm968's
vsnider Posted October 19, 2006 Posted October 19, 2006 We do what Mark does. Scheduled job to stop the service, give it plenty of time to do the backup (run a test first and add a couple of hours), run whatever backup (we use windows backup), scheduled job to restart the service. Over the last couple of years I remember it not working twice.
steve Posted October 19, 2006 Posted October 19, 2006 We also run Backup Exec with SQL agent and the DBATTACH script. dbattach.exe /user:"username" /password:"password" /backup /SERVER:"SERVERNAME" /DATABASE:"sims" /AUTO The dbattach file is located in something like C:\Program Files\Microsoft SQL Server\MSSQL\Binn - depends if you run MSDE or full SQL. We run it as a nightly scheduled task, just keep an eye on the build up of the backup files - they soon eat into your diskspace.
klawd Posted October 20, 2006 Posted October 20, 2006 Is there a reason for starting and stopping the SQL Services? I assumed volume shadow copy was designed so you didnt have to do this. We currently use dbattach to backup the SIMS db then copy it to another server + upload it offsite. Other backups (Exchange + sql) are done using a custom NTbackup script.
MkII Posted October 20, 2006 Posted October 20, 2006 You can't copy the database files if they're live klawd
Grommit Posted October 21, 2006 Author Posted October 21, 2006 The problem that i am having is that after the Backup exec has run (with SQL add on) is that the 2 SIMS files are not there ? any reason why ?
meastaugh1 Posted October 22, 2006 Posted October 22, 2006 The problem that i am having is that after the Backup exec has run (with SQL add on) is that the 2 SIMS files are not there ? any reason why ? When using BE SQL agent, I believe the database will be represented as Microsoft SQL Server "SIMS" and not as flat files in your backup/restore selections. I use both the SQL agent and the DBAttach command line, just in case.
klawd Posted October 22, 2006 Posted October 22, 2006 You can't copy the database files if they're live klawd Can you elaborate on this? All the documentation I have seen on this implies that Volume Shadow Copy Service can handle "live" files without a problem. I have not noticed any problems backing up SQL Server 2000 with NTbackup. But I would like to make sure I am doing backups that will actually restore.
tosca925 Posted October 29, 2006 Posted October 29, 2006 You can't copy the database files if they're live klawd I take it this apples to CMIS as well?
john Posted October 29, 2006 Posted October 29, 2006 I would say so, any database thats live and open cannot be backed up properly.
t_guest Posted October 30, 2006 Posted October 30, 2006 How do you back up SIMS.. Do you get SIMS to do its own backup via the System Manager everynight ? (how do I automate this?) Or just use Backup exec or NTbackup to backup the whole MSSQL folder to tape and disk ?
bossman Posted October 30, 2006 Posted October 30, 2006 Anyone use Cobian 8? I am just evaluating at the mo but am getting good results Backing up to Buffalo NAS. This has a function to stop services such as MSSQL and it's agents but as i say just testing at the mo. Don't know if this has been covered on the forum and if it has well sorry for wasting peoples time. Anyone have any other info on how well or badly cobian worked for them i would like to know. Cheers
djm968 Posted October 30, 2006 Posted October 30, 2006 I have used previous versions of Cobian backup with good results. Is it still free?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now