You cannot perform a LOG backup on a database that has "Truncate Log On Checkpoint" set. This mean that the Transaction Log is automatically truncated. You can either disable "Truncate Log On Checkpoint" or only perform full backups of these databases.
FYI, Northwind and Pubs are sample databases supplied by MS and don't need to be backed up. Ken -----Original Message----- From: Callan, Chris [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 3:15 PM To: NT 2000 Discussions Cc: [EMAIL PROTECTED] Subject: Backing Up SQL When I goto backup some of my SQL DBases I get the following error from Backup Exec. How do I get past this? Unable to open the item Northwind?PRIMARY - skipped. An error occurred on a query to filegroup pubs..PRIMARY. ^ ^ ^ ^ ^ SQL Server returned the following error message: BACKUP LOG is not allowed while the trunc. log on chkpt -----Original Message----- From: Andrew S. Baker [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 02:36 To: NT 2000 Discussions Cc: [EMAIL PROTECTED] Subject: RE: :-( @ auto respond Only because you're slow. ASB http://www.ultratech-llc.com/KB -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David N. Precht Sent: Saturday, December 21, 2002 5:34 PM To: NT 2000 Discussions Subject: RE: :-( @ auto respond Test failed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Emmanuel Adebayo Sent: Friday, December 20, 2002 11:27 To: NT 2000 Discussions Subject: RE: :-( @ auto respond test -----Original Message----- From: Andrew S. Baker [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 15:28 To: NT 2000 Discussions Subject: RE: :-( @ auto respond You'd think so, but then we wouldn't find it so difficult to get proper funding for network security if common sense actually ruled the land... :) ASB http://www.ultratech-llc.com/KB -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Roger Seielstad Sent: Friday, December 20, 2002 8:08 AM To: NT 2000 Discussions Subject: RE: :-( @ auto respond Personally, I figure the recent rash of home breakins based on the content of out of office messages would be a bigger deterent. ------------------------------------------------------ Roger D. Seielstad - MCSE Sr. Systems Administrator Inovis - Formerly Harbinger and Extricity Atlanta, GA > -----Original Message----- > From: Adam Smith [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 10:56 PM > To: NT 2000 Discussions > Subject: :-( @ auto respond > > > > To those of you who use Auto-Responders when you're away from the > office, PLEASE for EVERYONE'S sake read: > > http://www.goldmark.org/netrants/auto-resp/ > > Of all the list's I'm on, *this list* is the biggest offender. For > each message I send to it I recieve at least 3 auto-responses from > people I have never heard of. Please, please, please read it. > > > ------- > > I just calculated these rough statistics: > > Average auto-response received per post : 2.5 > My average no. list posts per week : 7.5 > Average size of auto response : 3k > > > This means I could recieve 975 unwarranted auto responses per year! > > > :( > > > -- > Adam Smith > Information Technology Officer > SAGE Automation Ltd. > > [EMAIL PROTECTED] > http://www.sageautomation.com ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
