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 |
|
Roccofox
Starting Member
6 Posts |
 Posted - 2013-11-04 : 10:48:14
|
| Hi Folks,I'm new to the administration side of SSMS and recently had to create a backup job so that it backed up the transactions logs to a .trn file rather than storing them in the LDF file.However when my backup job for the transaction logs runs, every 30 mins, it seems to be doing a FULL backup and slowing down our system.My current backup schedule should be a Full backup at 1am every Saturday and then differential backups at 1am every night apart from Saturday and then the transaction logs every 30 mins.Using SQL 2008 R2 and the recovery model of the db in question is Full.So where am I going wrong folks?Many ThanksTomThere are 10 types of people in this world. Those that understand binary and those that don't. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-04 : 12:44:39
|
| Open up SSMS, under Servername -> Management -> Maintenance Plans, right click on the maintenance plans you have, select modify and examine what they do. YOu can right-click and edit the steps. For the transaction log backup, the Backup Type should show "Transaction Log". If that is not the case, make appropriate changes. |
 |
|
|
Roccofox
Starting Member
6 Posts |
Posted - 2013-11-05 : 03:14:40
|
| Hi James,Thanks for the reply but everything that side in management plans is OK. The backup type is already set to transaction log.There are 10 types of people in this world. Those that understand binary and those that don't. |
|
|
|
Roccofox
Starting Member
6 Posts |
Posted - 2013-11-05 : 03:44:04
|
| i think i have probably not described this issue correctly. I am backing up the db Full backup once a week, differential every night and transaction logs every 30 mins. Looking at the job activity it looks like the transaction logs are backing up as the job succeeds and only lasts 10 seconds or so depending on activity. I can see the .trn files in the location where i have them set to backup to disk.The issue is that when i got to restore a Point in Time it shows one backup and says it is a full backup when it is not its a transaction backup.so why does SSMS think or label that the last transaction backup was a FULL backuphope that makes more sense to someone.There are 10 types of people in this world. Those that understand binary and those that don't. |
|
|
|
|
|
|
Transaction Logs backup job running full backup