ninjabeaver Posted January 14, 2009 Posted January 14, 2009 Hi guys, I've been volunteered to do the patches and upgrades on the SIMS.net system we have here. There's been one or two little patches that needed running on the DB recently to fix minor bugs but each time we patch it's taken apporximately 45 minutes to do a complete DB backup. The reason I'm asking this is that when the CAPITA techy came in to setup the SIMS Gateway he was telling me it should not be taking that long and there is a 'fix' for it. I'm curious to what other people patch backup times are and if there is a fix. Cheers, Simon.
jamesb Posted January 14, 2009 Posted January 14, 2009 What's the actual size of your database, and which backup method are you using? Depending on what its doing it may take this long, particularly if its compressing a large backup to a .zip format. One thing to try might be using one of the other available methods to do a backup, without compressing the result, and see if there's a difference in time. If there is then you can run the dbupgrade console without doing a backup using the command dbupgrade /nobackup. 1
matt40k Posted January 14, 2009 Posted January 14, 2009 There is a few options. First you need the dynazip patch, which is basically now useless. The other is to turn off compression on the backup file, patch 12460. The final is to run dbupgrade with /nobackup. Just make sure you backup before you start! It should be resolve in the march 09 release. 1
bossman Posted January 14, 2009 Posted January 14, 2009 @ninjabeaver: About the same time here and it does get a little tedious if you are having to just do a couple of patches i know but it all seems to work. I save updates and patching until a Thursday night so i have the time to do it usually get out about 6 - 6:30 after everyone has logged out at 4:30, stop the terminal services on the remote Sims access and then update the terminal server Sims.net job done then on to McDonalds with webman and then on to college after that. 1
mcloum Posted January 14, 2009 Posted January 14, 2009 Mines takes about 30 mins usually. for just over 1gb database 1
Jeremy69 Posted January 14, 2009 Posted January 14, 2009 Used to take 7 minutes. Went to over half an hour last year but I've now installed the patches(including the dynazip one), run the backups from dbattach and it is back to about 6 minutes for SIMS (2.5gb) and under 3 minutes for FMS 1
AyatollahPies Posted January 16, 2009 Posted January 16, 2009 Also depends on your hardware. What spec is the server?
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