creese Posted March 5, 2010 Posted March 5, 2010 In the last couple of days one school has started zipping it's SQL backups. This has stopped our backup working. Any ideas anyone? I have checked the version od DBAttach and upgraded to 7.126.
creese Posted March 5, 2010 Author Posted March 5, 2010 Confused. Can you explain a bit better? As from, I think, 7.124 DBAttach is not supposed to zip the backups. This school was running along nicely backing up to a .bak file until 2 or 3 days ago when it started to zip again. I upgraded to 7.126 and it is still zipping. I run a script with DBattach (DBATTACH /AUTO /SERVER=nnnn-OFFICE\SIMSSQL /database=simsdatabase /USER=XXX:confused: /PASSWORD=XXXXXX /BACKUP) I even uninstalled EasyZip.
timzim Posted March 5, 2010 Posted March 5, 2010 What a couple of monkeys! Cheeky! I'm a chimp, not a monkey!!
creese Posted March 5, 2010 Author Posted March 5, 2010 Cheeky! I'm a chimp, not a monkey!! ...and I'm an ape..... or 2
matt40k Posted March 5, 2010 Posted March 5, 2010 (edited) As from, I think, 7.124 DBAttach is not supposed to zip the backups. This school was running along nicely backing up to a .bak file until 2 or 3 days ago when it started to zip again. I upgraded to 7.126 and it is still zipping. I run a script with DBattach (DBATTACH /AUTO /SERVER=nnnn-OFFICE\SIMSSQL /database=simsdatabase /USER=XXX:confused: /PASSWORD=XXXXXX /BACKUP) I even uninstalled EasyZip. It won't be dbattach unless they've restored the database. Are they use tidybackups? There is an option with MSSQL, but I though that was only the enterprise edition that could use it. Any reason why them being a zip would break your backup?? http://sourceforge.net/projects/tidybackups/ Edited May 11, 2010 by ZeroHour
creese Posted March 8, 2010 Author Posted March 8, 2010 Fresh eyes this morning. I found out the script was set to backup MSSQL.1 but someone had at some time created MSSQL.2 and didn't delete .1. Script amended and now creating .bak files.
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