Post reply

mirrored DB backup help please

  • March 24, 2016 at 3:53 am

    #326016

    Good morning

    I have a databases at 1.15TB but the Log file is 184GB. So i need space for 966GB

    1MDF file and 28 NDF files.

    I have to backup using a SQL script but i want to split the load of the backups over a few drives. I have one drive which is 560GB free, 310GB and one at 120GB

    with 28ndf files. i want to specifically say which nfd files go one to which drive. I need to backup the database

    The script i am using is. Taken out names for security purposes. Its a Mirrored databases Asynchronous. So need sot be Copy only.

    BACKUP DATABASE DB TO DISK ='L:\Backup\\_1.bak'

    , DISK ='L:\Backup\\.bak'

    , DISK ='L:\Backup\\3.bak'

    , DISK ='L:\Backup\\4.bak'

    , DISK ='L:\Backup\\5.bak'

    , DISK ='L:\Backup\\6.bak'

    , DISK ='L:\Backup\\7.bak'

    , DISK ='L:\Backup\\8.bak'

    , DISK ='L:\Backup\\9.bak'

    , DISK ='L:\Backup\\10.bak'

    , DISK ='L:\Backup\\11.bak'

    , DISK ='L:\Backup\\12.bak'

    , DISK ='L:\Backup\\13.bak'

    , DISK ='L:\Backup\\14.bak'

    , DISK ='L:\Backup\\15.bak'

    , DISK ='L:\Backup\\16.bak'

    , DISK ='L:\Backup\\17.bak'

    , DISK ='L:\Backup\\18.bak'

    , DISK ='L:\Backup\\19.bak'

    , DISK ='L:\Backup\\20.bak'

    , DISK ='L:\Backup\\21.bak'

    , DISK ='L:\Backup\\22.bak'

    , DISK ='L:\Backup\\23.bak'

    , DISK ='L:\Backup\\24.bak'

    , DISK ='L:\Backup\\25.bak'

    , DISK ='L:\Backup\\26.bak'

    , DISK ='L:\Backup\\27.bak'

    , DISK ='L:\Backup\\28.bak'

    , DISK ='L:\Backup\\29.bak'

    WITH COPY_ONLY,

    STATS = 1

    many thanks

  • March 24, 2016 at 3:59 am

    #1867337

    I have found a way through the guid

    Backup component. i can specify which files to get backed up. Then i specify which location in the Destination field.

    If any one has a TSQL version i would be grateful too

    many thanks

    Sean

  • March 24, 2016 at 3:59 am

    #1867338

    Please don't post multiple questions for the same problem.

    No replies here. Replies to http://www.sqlservercentral.com/Forums/Topic1772009-24-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 24, 2016 at 4:36 am

    #1867354

    This is not working. 🙁

    can someone suggest another way please..

    i have tried this too

    B. Creating a full file backup of the secondary filegroups

    The following example creates a full file backup of every file in both of the secondary filegroups.

    --Back up the files in SalesGroup1.

    BACKUP DATABASE Sales

    FILEGROUP = 'SalesGroup1',

    FILEGROUP = 'SalesGroup2'

    TO DISK = 'C:\MySQLServer\Backups\Sales\SalesFiles.bck'

    GO

  • March 24, 2016 at 5:05 am

    #1867360

    seanthomas2010 (3/24/2016)

    This is not working. 🙁

    You mean you don't like my answers in the other thread?

    Please stick to a single thread, otherwise people end up wasting their time (and your time) offering suggestions that have already been made.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply