none
File splitter for SQL Server bak files

    질문

  • 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
    2012년 6월 29일 금요일 오전 4:35

모든 응답

  • Hello danielsn,

    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 Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing


    2012년 6월 29일 금요일 오전 4:49
  • 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!


    2012년 7월 4일 수요일 오전 9:25