Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Drigomaniac
Starting Member
1 Post |
 Posted - 2010-06-14 : 10:33:59
|
Well....I have created a sqldump bash script to be submitted in cronjobs. I tried using it and it works (since I have backed it up) but the size of my .sql backed up output keeps increasing from 12MB initially until it gets to 12GB. I type du -h * and you can see it increaases.I think it is very big for the database I have. Probably it is being overwrited several times. Any suggestions to back up my database?I have to do this every day but 11GB per day is more than what I expected.Thanks in advance! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-14 : 10:48:06
|
Is it MS SQL Server?Is the database recovery model set to full and you are not making log-backups?Then your log is growing.Is it MYSQL?Then I don't know because this forums are MS SQL Server forums.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-06-14 : 10:52:02
|
| Cron job? Bash script?SQL Server doesn't run on *nix, so I'm guessing we're talking about a different database platform here. Which one?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
My sqldump keeps increasing.