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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-31 : 07:45:56
|
Raj writes "Hi I have my databases operating in "truncate log on checkpoint" mode. I need to be able to recover to the time of the last backup and do not require point of failure recovery. On recently trying to do a test recovery I came across an error that read something like 'Unable to complete recovery due to non-logged operation ...
please revert to a later backup to restore from'.
First of all I was under the impression that a non-logged operation shld not be allowed while the database is being backup up. Evidently my assumption was wrong.
How do i prevent such a situation in the future. Is using sp_dboption to change the "select into/bulk copy" before starting the recovery going to help. Or am I better of swithcing the flags for 'dbo use only' and 'single user'.
These do not prevent existing users from continuing with their work does it.Is there a way for me to dynamically kick out users
before I start my backup ... without shutting down my server first?
Thanks,
Rajarshi" |
|
|
|
|
|
Backup/Restore on Sqlserver 7.0 S.P 3 WINT 4.0 SP4