Mar 23 2012

Backup Resources

SQL Server 2012 Administration (includes the chapters I wrote on backup/restore):

4 Comments

  • By Paul OBrien, April 12, 2013 @ 8:40 pm

    I recently started a new job and am looking for a bit of help, as I’m not very familar with MYSQL.

    I’m running a Symantec Backup Exec every night and the program has been outputting an error.

    It states that my MYSQL database transaction log is in Full and that I should either change it to simple or schedule log backups.

    This is really annoying since my database’s total size is 10.38 MB. Yup that’s right 10.38 MB. The log is not even 1 MB.

    However, I don’t see it fitting to change from Full to Simple.

    I watched your backup tutorial on YouTube and found it most informative. I was hoping however you might give me some direction on Automating/Scheduling the procedure. I browsed through a handful of google pages and youtube videos and they were not of much help.

    Thank You.

  • By Grant Fritchey, April 13, 2013 @ 6:40 am

    Hello Paul,

    If we’re talking MySQL as you say, I’m not sure I can help you much. I’m working within Microsoft SQL Server. The mechanisms and tools are different between the two. But, if you are looking for more information on SQL Server, my chapters in the book linked above include backups and show how to automate it. For even more detail you can check out Shawn McGehee’s book: https://www.simple-talk.com/books/sql-books/sql-backup-and-restore/

    It’s free to download.

    But if we are talking MySQL you’ll need to search some more for better resources.

  • By Steven Mahaffey, March 11, 2014 @ 3:56 pm

    Just registered for the blog. Is this the appropriate place to ask questions?

    Thanks Steve

  • By Grant Fritchey, March 11, 2014 @ 6:06 pm

    I suppose you can ask pretty much what you like where you like, although if it was on topic for the given page it would make my life a little easier. But, go for it!

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment