Hubman
asked on
SQL 2005 backups
I got this message:
Your SQL Server database is currently set to Full recovery model. Without regular transaction log backups, they will eventually consume all available disk space.
Looking for a article to setup backup correctly. I use backup exec for backup .bak files not live sql data.
Your SQL Server database is currently set to Full recovery model. Without regular transaction log backups, they will eventually consume all available disk space.
Looking for a article to setup backup correctly. I use backup exec for backup .bak files not live sql data.
If you run your database in Full recovery, you need to backup your transaction log files. It sounds like you are backing up your data files. Here is a step by step guide to back up the log files. It's 2008, but it should still apply.
http://blogs.msdn.com/b/john_daskalakis/archive/2010/02/09/9960381.aspx
Greg
http://blogs.msdn.com/b/john_daskalakis/archive/2010/02/09/9960381.aspx
Greg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, I wil go over these and make a new post if I have any new questions
ASKER