I have a sql server backup fiile which is 30 gigs in size, and I want to put it on my google drive. However, my google drive has a limit of either 10 gig files, or max 100 gig total. I have plenty of room left, but it wont copy it because the file is greater than 10 gigs. Is there any way to back up in peices, or any tools which might make this work?
- 편집됨 danielsn 2012년 6월 29일 금요일 오전 4:36
SQL Server supports the option to create "striped" backups, means to spread the backup over several backup files.
You can do this manually using T-SQL or with this little PowerShell script found here: http://gallery.technet.microsoft.com/scriptcenter/Striped-Backup-of-Sql-0b20f712
This method can also increase the backup performance.
- 편집됨 Olaf HelperMVP 2012년 6월 29일 금요일 오전 4:50
you can split the backup into multiple files like :
BACKUP DATABASE <DATABASENAME>
TO DISK = 'File1.bak',
DISK = 'File2.bak',
DISK = 'File3.bak'
You can add multiple file to split the backup & can restore the database by spcifying all files..
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
- 편집됨 RohitGargMicrosoft community contributor 2012년 7월 4일 수요일 오전 9:26