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?
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.
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
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.