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 |
|
msc_timor
Starting Member
11 Posts |
 Posted - 2007-09-04 : 08:20:32
|
| hi, last week one strange thing happened to our database. at midnight the data auto backup (the sp isp_backup) ran and at midway as the low space was encountered the sp terminated and the primary and the log files were missing from the drive. so first thing in the morning i restored the latest backup. can someone explain why this happened. how can i prevent is from happening in futurergds,mipham |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-04 : 08:33:57
|
There is an error at Line 377 in your script 
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-04 : 09:17:26
|
| "can someone explain why this happened"Nope, sorry!I could understand the database being "suspended" so that no new transactions are possible, until more disk space is made available the SQL Service restarted, or database changed to "available". But I cannot see how the physical database files (e.g. .MDF / .LFD) could be deleted.Kristen |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 15:15:47
|
| check your recycle bin, they might still be there--------------------keeping it simple... |
|
|
|
|
|
|
database deleted automatically