I have three databases named XDW, XOLTP, XOLTPSchema. All of these are for only one application. In the application, user should do backup/restore using GUI.
1. How I should do backup/restore in one transaction? i.e. all of three actions should be success elsewhere all of them should fail.
2. Is it possible to backup them into only one file e.g. X.bak?
3. Or, What is the standard solution in this condition?
Thanks in advance.
LEARN "LINQ TO DATASET" DURING A QUICK SIMPLE HOW TO:
How To: Joining multiple DataTable using “LINQ to DataSet”
View Complete Post