SQL Server backups not appending

We are taking full backups of a SQL DB and the transaction logs.  Both are set to append.  Both jobs have been running since Monday. When we check the restore options for the DB and the logs, the logs show multiple restore points, while the DB only shows the most recent backup.  they both appear to be set the same, so why the difference?
Damian GardnerIT AdminAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
What is the environment like? Appendix not advisable, if you set a time frame for how long it is valid, the first part might be dealing with clearing out expired backups from the combined file.
Backup transaction log and full backups other own uniquely identifiable files.
What are you using to backup? SQL jobs,or powershell cmdlets?
Damian GardnerIT AdminAuthor Commented:
Thanks for your reply Arnold.  It is a SQLServer 2008 server on Windows 2008 R2, single standalone SQL system.  Using SQL Server jobs to do the backups, through the Studio.  So if I read your comments right, you're saying that APPENDING is not advisable, and that we should instead set it to over write?  strange thing is that the transaction backups show up as unique backups, while the full db backup does not.
arnoldCommented:
I am not sure what or how you are scheduling the job.  Often , the name of the backup file should be randomized based on the date/time when the backup runs.

It seems your transaction log is so setup, but your full backup seems to be using a backup device which has a static filename based on the device.
if you are using management plan, for transaction, make sure the same destination is used.

if you are manually creating the job, you need to use the convert and combination of date format 112 for yyyymmdd and the hhmmss from format 114,108

http://vadivel.blogspot.com/2011/09/convert-datetime-into-yyyymmddhhmmss.html
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Damian GardnerIT AdminAuthor Commented:
ok - I will try.  thank you
Vitor MontalvãoMSSQL Senior EngineerCommented:
When we check the restore options for the DB and the logs, the logs show multiple restore points, while the DB only shows the most recent backup.
Can you post a screenshot of that?
Damian GardnerIT AdminAuthor Commented:
sorry guys - forgot about this one.  there has been a space problem for the last week, and so there have been no successful job runs recently.  I need to clear the space and let it run tonight to show a screen shot.  standby.  thanks
Damian GardnerIT AdminAuthor Commented:
Well - now I only have the option to restore the full database from the most recent backup (last night) - the "Transaction Log" option is greyed out in spite of having run 5 hourly log backups since yesterday.  when I created this post, I was seing the option to restore any one of the various hourly log backups. not sure why now.
arnoldCommented:
once a full backup is run, it in validates the prior transaction logs.  What options are set on the database? If it was changed to simple, that will explain why transactional backups/restores are not available.

appending backups to a single file ..... not sure with ever growing size of backup it is a good idea.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Damian_Gardner, do you still need help with this question?
Damian GardnerIT AdminAuthor Commented:
I've requested that this question be deleted for the following reason:

lost track and got bogged down with other issues.
Damian GardnerIT AdminAuthor Commented:
thanks for your help guys.  I turned off APPEND and am using a script to juggle the backu8ps around so I don't lose them.  thanks again
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.