Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - Backup database into multiple files and restore from multiple files

Jul 4 2011 11:38PM by Ramireddy   

Few times, we will not have enough space in a single drive to take the database backup. Assume that you have 50GB database, You have 2 drives having free space 30GB each, in this scenario, backup needs to be split into 2 files. Just learned from Pinal's post that we can split the backup using below query.

BACKUP DATABASE AdventureWorks
TO  DISK = 'C:\Backup\MultiFile\AdventureWorks1.bak',
    DISK = 'D:\Backup\MultiFile\AdventureWorks2.bak',
    DISK = 'E:\Backup\MultiFile\AdventureWorks3.bak'
GO

We can restore the database using multiple files by using below query

RESTORE DATABASE [AdventureWorks]
FROM    DISK = N'C:\Backup\MultiFile\AdventureWorks1.bak',
    	DISK = N'D:\Backup\MultiFile\AdventureWorks2.bak',
    	DISK = N'E:\Backup\MultiFile\AdventureWorks3.bak' 
GO
Read More..   [89 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Ramireddy
2 · 40% · 12972
8
 
4
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

2  Comments  

  • hi simple but nice post

    commented on Jul 5 2011 6:25AM
    Deepak kelath
    210 · 1% · 222
  • Thanks deepak.. Glad you liked it..

    commented on Jul 5 2011 6:35AM
    Ramireddy
    2 · 40% · 12972

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Backup database into multiple files and restore from multiple files" rated 5 out of 5 by 8 readers
SQL Server - Backup database into multiple files and restore from multiple files , 5.0 out of 5 based on 8 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]