1. Overview
2. Getting Started
3. Backing Up
4. Verifying the backup

Comments

1. jayender.vs
   06 Jun 2005 at 11:11

   here  the solution for Backup the database in VC++:
   

   
   

   
   

   
   int backup::OnButton1()
   

   
   {
      HRESULT hr;
      if FAILED(hr = CoInitialize (NULL))
      {
          //_tprintf(TEXT("CoInitialize Failed\n"));
          return (0);
      }
   

   
      LPSQLDMOSERVER pSQLServer = NULL;
   

   
      if FAILED(hr = CoCreateInstance(
          CLSIDSQLDMOServer,
          NULL,
          CLSCTXINPROCSERVER,
          IIDISQLDMOServer,
          (LPVOID*)&pSQLServer))
      {
          //_tprintf(TEXT("CoCreateInstance Failed\n"));
          return (0);
      }
   

   
      pSQLServer->SetLoginTimeout(10);
      pSQLServer->SetLoginSecure(TRUE);
      
      if FAILED(hr = pSQLServer->Connect((L"ws-45"),(L"sa"),(L"")))
      {
          AfxMessageBox("Backup connection Failed");
          return DisplayError();
      }
   

   
      else
      {
          LPSQLDMODATABASES    pDatabases = NULL;
          LPSQLDMODATABASE    pDatabase = NULL;
          LPSQLDMOFILEGROUPS  pFileGroups = NULL;
          LPSQLDMOFILEGROUP    pFileGroup = NULL;
          LONG                lCount = 0;
          LPSQLDMODBFILE        ppDBFile = NULL;
          LPLONG                pRetVal = NULL;
          long    mdatasize;
          CString temp;
          
          float  mdatasizeMB;
          CString datasize;
   

   
          SQLDMOBSTR        strDB;
      //    long *strDB;
      
   //        char* mstr = new char[100];
   

   
          //pSQLServer->GetDatabaseCount(&lCount);
   

   
          hr = pSQLServer->GetDatabases(&pDatabases);
   

   
          for (LONG i = 0; i < 1; i++)
          {
              pDatabases->GetItemByOrd(i, &pDatabase);
   

   
              pDatabase->GetName(&strDB);
              
              pDatabase->Release();
              pDatabase->GetSpaceAvailableInMB(&m_datasizeMB);
              pDatabase->GetFileGroups(&pFileGroups);
   

   
          
              pDatabase->GetSize(&m_datasize);
   

   
          //    pDatabase->GetFileGroupByName(_T("DOTS"),&pFileGroup);
          //    pFileGroup->GetDBFileByOrd(0,&ppDBFile);
   

   
          //    temp = mdatasize;
              datasize.Format("%d",mdatasize);
              temp.Format("%d",mdatasizeMB);
              SetDlgItemText(IDCEDIT1,datasize);
              //AfxMessageBox(datasize);
              
              //AfxMessageBox(temp);
              
              //    sprintf(mstr,"%lf",msize);
   

   
          
          
          //    wprintf(T("database %s"), strDB);
          //    wprintf(T(" Total size  %i \n"), msize);
          //    wprintf(T("Free space %lf \n"), m_sizeMB);
          }
          
                      
   }
   

   
      LPSQLDMOBACKUP pSQLBackup = NULL;
   

   
      if FAILED(hr = CoCreateInstance(
          CLSIDSQLDMOBackup,
          NULL,
          CLSCTXINPROCSERVER,
          IIDISQLDMOBackup,
          (LPVOID*)&pSQLBackup))
      {
      //    _tprintf(TEXT("CoCreateInstance Failed\n"));
          return (0);
      }
   

   
      LPCONNECTIONPOINTCONTAINER pMyConnectionPointContainer;
      LPCONNECTIONPOINT pMyConnectionPoint;
   

   
      CMyBackupSink* pMyBackupSink = new CMyBackupSink();
      pMyBackupSink->AddRef();
      
      if (!pMyBackupSink)
      {
          return(0);
      }
   

   
      DWORD dwCookie;
   

   
      // ask the connectable object (pSQLBackup) about its outgoing interface,
      // by using QI on IIDIConnectionPointContainer. If fails, this object
      // does not support outgoing interface
      //
      if FAILED(pSQLBackup->QueryInterface(
          IIDIConnectionPointContainer,
          (LPVOID FAR*) &pMyConnectionPointContainer))
      {
          return DisplayError();
      }
   

   
      // find the specific outgoing interface IID_ISQLDMOBackupSink and retrieve
      // a pointer to the connectionpoint object. If fails, the object does not
      // support this outgoing interface
   

   
      if FAILED(pMyConnectionPointContainer->FindConnectionPoint(
          IID_ISQLDMOBackupSink,
          (LPCONNECTIONPOINT FAR*)&pMyConnectionPoint))
      {
          return DisplayError();
      }
   

   
      // establish the connection between the Sink and the ConnectionPoint object.
      // Retrieve a key (cookie) value for terminating the connection later. If
      // this fails, the Sink and ConnectionPoint object do not support the same interface
      
      if (S_OK != (hr = pMyConnectionPoint->Advise((LPUNKNOWN)pMyBackupSink, &dwCookie)))
      {
          return DisplayError();
      }
   

   
      if FAILED(hr = pSQLBackup->SetFiles((L"e:\test123.dmp") ))
      {
          return DisplayError();
      }
   

   
      if FAILED(hr = pSQLBackup->SetDatabase((L"dots")))
      {
          return DisplayError();
      }
   

   
   //    hr = pSQLBackup->EXEC sp_spaceused ;
   

   
      if FAILED(hr = pSQLBackup->SetTruncateLog(SQLDMOBackupLogTruncateOnly))
      {
          return DisplayError();
      }
   

   
   

   
    

2. vpolv
   29 Jan 2005 at 14:28

   Hi
   

   
   I tried your code, seems it is not working for remote database backup.
   do u have any update version for taking backups.
   

   
   thanks

3. Developer Fusion Bot
   01 Jan 1999 at 00:00

   This thread is for discussions of Using SQL-DMO To Backup and Verify a Database.