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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-06-16 : 01:32:08
|
| Hi all,while taking a database backup, in middle say out of 200GB, after 100GB, i got the message that disk is full. can we change the path at that time? ofcource we have to check everything before backing up a database, but what we have to do in this scenario? this is an interview question....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-16 : 05:54:47
|
| If the backup runs out of space it will fail.--Gail ShawSQL Server MVP |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-06-16 : 06:16:20
|
| In other words...you will have to do the entire backup again. You can however take a backup of selected filegroups and put each of the backups on a separat device but afaik you have to do this "manually" one at a time...- Lumbago |
|
|
|
|
|
|
disk full while backing up a DB.