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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  backup/restore

Author  Topic  rdas Starting Member 2 Posts Posted - 2001-05-24 : 16:25:07 Hi I operate my databases in "truncate on checkpoint" mode as I do not require point of failure recovery.On doing a test recovery from a backup I get the foll. message "recovery has failed because a nonlogged operation could no be redone.Use the RESTORE statement to restore all data in filegroup 'PRIMARY'(1) to a point beyond the nonlogged changes'. Am i wrong in thinking that a non-logged operation should not have got through while my database was being backed.How do i prevent the above from recurring ...do i have to use sp_dboption with 'single user'...How can i prevent existing connections from issuing non-logged without bouncing sqlserver. Thanks for all your opinions.