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 |
|
toshidas2000
Starting Member
1 Post |
 Posted - 2007-06-12 : 14:35:07
|
| I am new to SQL Server. When the backup fails because of the disk space. I do not see backup file of incompleted or failed backup. Does window removes the file, because it is a failed backup??How do find the location on T-Logs.ThanksToshi |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-12 : 16:35:49
|
| "Does window removes the file, because it is a failed backup??"No ... well, yes, maybe!The file is created, written to, the disk is full (or some other error occurs) and the partially written file is deleted - because on its own it is useless.An error is written to the log.Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 20:16:46
|
| Right click on the db in em or ssms and go to properties -> files tab, you'll see log file path, or query sysfiles1 (sql2k) or sys.sysfiles (sql2k5). |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-13 : 03:05:47
|
| To see what was recently backed up:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#273265 |
|
|
|
|
|
|
Backup of SQL Server