|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Transaction Log Backups
SQL Server 2000
Will a transaction log backup occur via a maintenance plan if there are no changes to the database? There is a maintenance plan on the server that does a complete backup and transaction log backups on several databases. However, I noticed that only one of the databases is actually getting transaction log backups so I was wondering if it is because there are no changes to the other databases occurring. Thanks! If t-log backups are setup in the plan, all databases in Full or Bulk-Logged
recovery model will be backed up. Right click the database, go to Properties, then options to check the recovery model. Backup will happen regardless of activity for Full and BL -- Show quoteHide quoteKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. Twitter: Kevin3NF "Anonymous" <Anonym***@discussions.microsoft.com> wrote in message news:BC2F1954-C4E1-41A2-9FB5-3B87B52002C7@microsoft.com... > SQL Server 2000 > > Will a transaction log backup occur via a maintenance plan if there are no > changes to the database? > > There is a maintenance plan on the server that does a complete backup and > transaction log backups on several databases. However, I noticed that > only > one of the databases is actually getting transaction log backups so I was > wondering if it is because there are no changes to the other databases > occurring. > > Thanks! I thought the same thing, i.e., the databases were set to simple recovery but
they weren't. All the databases are set to full recovery. Any other ideas why the transaction log backups are not being created. There are no errors when I run the plan. Show quoteHide quote "Kevin3NF" wrote: > If t-log backups are setup in the plan, all databases in Full or Bulk-Logged > recovery model will be backed up. Right click the database, go to > Properties, then options to check the recovery model. > > Backup will happen regardless of activity for Full and BL > > -- > > Kevin3NF > SQL Server dude > > You want fries with that? > http://kevin3nf.blogspot.com/ > > I only check the newsgroups during work hours, M-F. > Hit my blog and the contact links if necessary...I may be available. > > Twitter: Kevin3NF > > "Anonymous" <Anonym***@discussions.microsoft.com> wrote in message > news:BC2F1954-C4E1-41A2-9FB5-3B87B52002C7@microsoft.com... > > SQL Server 2000 > > > > Will a transaction log backup occur via a maintenance plan if there are no > > changes to the database? > > > > There is a maintenance plan on the server that does a complete backup and > > transaction log backups on several databases. However, I noticed that > > only > > one of the databases is actually getting transaction log backups so I was > > wondering if it is because there are no changes to the other databases > > occurring. > > > > Thanks! > > > How about the Maintanence Plan history and job history? Is there any clue
in those logs? -- Show quoteHide quoteEkrem Önsoy "Anonymous" <Anonym***@discussions.microsoft.com> wrote in message news:0C386A16-14DC-4DC9-BAC3-27EF96FAF157@microsoft.com... >I thought the same thing, i.e., the databases were set to simple recovery >but > they weren't. All the databases are set to full recovery. > > Any other ideas why the transaction log backups are not being created. > There are no errors when I run the plan. > > "Kevin3NF" wrote: > >> If t-log backups are setup in the plan, all databases in Full or >> Bulk-Logged >> recovery model will be backed up. Right click the database, go to >> Properties, then options to check the recovery model. >> >> Backup will happen regardless of activity for Full and BL >> >> -- >> >> Kevin3NF >> SQL Server dude >> >> You want fries with that? >> http://kevin3nf.blogspot.com/ >> >> I only check the newsgroups during work hours, M-F. >> Hit my blog and the contact links if necessary...I may be available. >> >> Twitter: Kevin3NF >> >> "Anonymous" <Anonym***@discussions.microsoft.com> wrote in message >> news:BC2F1954-C4E1-41A2-9FB5-3B87B52002C7@microsoft.com... >> > SQL Server 2000 >> > >> > Will a transaction log backup occur via a maintenance plan if there are >> > no >> > changes to the database? >> > >> > There is a maintenance plan on the server that does a complete backup >> > and >> > transaction log backups on several databases. However, I noticed that >> > only >> > one of the databases is actually getting transaction log backups so I >> > was >> > wondering if it is because there are no changes to the other databases >> > occurring. >> > >> > Thanks! >> >> >> Query your msdb..backupset table to see if they are being created but not in
the location you expect... -- Show quoteHide quoteKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. Twitter: Kevin3NF "Anonymous" <Anonym***@discussions.microsoft.com> wrote in message news:0C386A16-14DC-4DC9-BAC3-27EF96FAF157@microsoft.com... >I thought the same thing, i.e., the databases were set to simple recovery >but > they weren't. All the databases are set to full recovery. > > Any other ideas why the transaction log backups are not being created. > There are no errors when I run the plan. > > "Kevin3NF" wrote: > >> If t-log backups are setup in the plan, all databases in Full or >> Bulk-Logged >> recovery model will be backed up. Right click the database, go to >> Properties, then options to check the recovery model. >> >> Backup will happen regardless of activity for Full and BL >> >> -- >> >> Kevin3NF >> SQL Server dude >> >> You want fries with that? >> http://kevin3nf.blogspot.com/ >> >> I only check the newsgroups during work hours, M-F. >> Hit my blog and the contact links if necessary...I may be available. >> >> Twitter: Kevin3NF >> >> "Anonymous" <Anonym***@discussions.microsoft.com> wrote in message >> news:BC2F1954-C4E1-41A2-9FB5-3B87B52002C7@microsoft.com... >> > SQL Server 2000 >> > >> > Will a transaction log backup occur via a maintenance plan if there are >> > no >> > changes to the database? >> > >> > There is a maintenance plan on the server that does a complete backup >> > and >> > transaction log backups on several databases. However, I noticed that >> > only >> > one of the databases is actually getting transaction log backups so I >> > was >> > wondering if it is because there are no changes to the other databases >> > occurring. >> > >> > Thanks! >> >> >>  
Other interesting topics
Problems with NOEXPAND
SQL 2008: How to recursive Procedure for parentNavigation? Command to quit executing query through script Pending Reboot Requirement html encoding Commands SQL Server 2000 EM to SQL Server 2005 SSMS Using xp_delete_file to delete rar files Lost my CD Windows NT Login in SQL Server 2000 sql2005 log file is full |
|||||||||||||||||||||||
