SQL 2008 Database Backup.
I'm having a problem with Transaction file backups.
Here is how I am currently setup.
VEEAM Backup Server:
I use VEEAM to backup my SQL2008 Server every day at 8:30 PM and it finishes at about 10:30 PM.
SQL 2008 Server:
I have 3 databases that are for our document management server
I run a maintenance task that
Reorganizes 3 databases at 9:00
Rebuild the index of these 3 databases at 9:30
Update statistics on these 3 databases at 10:00
then backs up these 3 databases at 11:00 PM to:
C:\Program Files (x86)\Microsoft SQL Server\Backup\"Database name 1"
C:\Program Files (x86)\Microsoft SQL Server\Backup\"Database name 2"
C:\Program Files (x86)\Microsoft SQL Server\Backup\"Database name 3"
I run a separate maintenance task that backs up the transaction logs dtabases of the 3 above databases, it backs up evey 2 hours and backs up to this location:
D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup
I run another plan that shrinks the transactiol log evey 4 hours at 1:00 5:00 9:00 PM and 1:00 5:00 9:00 PM .
My problem is two fold:
1. I do not know much about SQL and what is needed in order to restore a database. I've started reading a little bit but was hoping for someone to just tell me in laymans terms how the backup and restorte is supposed to work and what is needed.
2a. The transaction log shrinking never runs - it always fails.
2b. the transaction log backup task fails often it actually only succesfully runs at 10:00 PM 12:00 AM 2:00 AM and 4:00 AM - then at 6:00 AM and evey 2 hrs until 10:00 PM it fails.
I see the failures in the log file viewer - I can attach a picture if needed.
Let me know what information to post and as long as I can find it , I'll provide the info.
Thanks for you assistance