If you're going to back up the log, then you need to not have the truncate log on checkpoint option on.
This is what it means when you view the sql server properties in Enterprise manager and it says you have "simple recovery" enabled. Either of the other two recovery options (Full or bulk) will allow you to backup the transaction log. Truncate log on checkpoint is like saying "forget the transaction log, I dont' need it" to SQL Server. Tim ->-----Original Message----- ->From: [EMAIL PROTECTED] ->[mailto:[EMAIL PROTECTED]]On Behalf Of Callan, Chris ->Sent: Monday, January 06, 2003 12: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]
