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-07-06 : 11:10:59
|
| Hi All,is it possible to take the backup across two files? instead of a single file? i've read the thread in the below link. it means if we are taking a backup on D:\ drive with the name backupfile1.bak and suddenly the drive is full, so can i start the rest of backup in E:\ drive with the file name backupfile2.bak?it means my database backup is in two different files in two different drives. is it possible like this kind of stripping?Ref : http://www.sqlservercentral.com/Forums/Topic747342-357-1.aspxArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-07-06 : 14:11:56
|
| You can backup to multiple files; I have tested it with up to 50 files. You can split any type of backup to multiple files: full, file, filegroup, differential, or transaction log. SQL Server will split the backup evenly across all the backup files.You must specify all the backup files that will be used in your original BACKUP command. There is no way to add another file to the backup after you run out of space on the first drive.CODO ERGO SUM |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2009-07-06 : 15:05:52
|
| Got it. Thank you MVJ.can you provide me some steps how to accomplish this?actually i've faced the question in IBM interview.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-06 : 15:11:24
|
quote:
Originally posted by sunsanvin
Got it. Thank you MVJ.can you provide me some steps how to accomplish this?
Have you consulted books online?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
backup the database in two different files????