wlyeung_191be5

updated

12 years ago

0

1147

May 24th, 2014 12:00

NMM SQL VDI / VSS

I have checked the Microsoft site but still have some question.  Basically, I want to backup all database on a standalone SQL server at the same time.  If I use VSS, it should be possible.  However, what if I use SQL VDI.  If I define the saveset as MSSQL: (assume default instance), will it create a point in time copy of all the database in the SQL server?

  • ble1

    6 Operator

    14354 Posts

    56186 Points

    785

    1

    Posted May 24th, 2014 13:00

    No, it will do then sequentially.  What you can do with VDI is:

    MSSQL:database1

    MSSQL:database2

    [etc]

    and make sure client parallelism is big enough to have them all run at the same time.

  • 785

    0

    Posted May 26th, 2014 06:00

    Thanks guys.  I will just stick with VSS then.  At least, the snapshot for databases in the SQL box are created at the same time.  That will be easier to manage savesets instead of defining multiple savesets in the backup. 

  • crazyrov

    6 Operator

    1319 Posts

    785

    2

    Posted May 26th, 2014 06:00

    Make the client parallelism equivalent to the number of Database on the SQL server. Also ensure you have a device that is capable and free to take in all these streams.

  • ble1

    6 Operator

    14354 Posts

    56186 Points

    785

    0

    Posted May 26th, 2014 07:00

    Actually I prefer VDI because I can use transaction logs at least.