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 |
|
fazle_rabbee
Yak Posting Veteran
63 Posts |
 Posted - 2012-11-21 : 03:17:42
|
| At the time of taking a database full backup an error returns as follows.Msg 1823, Level 16, State 2, Line 1A database snapshot cannot be created because it failed to start.Msg 7928, Level 16, State 1, Line 1The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation.Msg 7926, Level 16, State 1, Line 1Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.Msg 845, Level 17, State 1, Line 1Time-out occurred while waiting for buffer latch type 3 for page (1:896443), database ID 5.Any one has a solution??fazle rabbee |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-21 : 04:21:02
|
| If you have a valid backup, restore. Otherwise, call MS Support. You can try cycling SQL and rerun it to see if that helps.-Chad |
 |
|
|
|
|
|
|
|
Buffer Latch type Error