This is a discussion on Multiple Backup statements for backup multiple databases? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi I am trying to Backup my SQL server using the VDI (Virtual Device Interface) APIs I have the ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi I am trying to Backup my SQL server using the VDI (Virtual Device Interface) APIs I have the capability of creating and mounting snapshot. I have already looked at the sample called "snapshot". As far as It is one DB it is OK, everything goes smoothly. But when I have more then one database on the same partition,I need to ensure all the databases are at "Hot backup state" and flush all the metadata of all the DB in order to ensure a consistency state. I have tried almost everything but it seems that nothing works, any Idea? I have tried to create one Virtual device set, and open a virtual device per DB. The Backup statement is per database, and when I am trying to run more then one statement I failed to open the devices. any solution will be appreciated. Thanks |