home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,602 of 19,505   
   Gene Wirchenko to All   
   Moving a Database   
   02 May 12 09:06:16   
   
   XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Dear SQLers:   
      
        What is the proper way for moving a database from location to   
   location?   
      
        I put together a simple database, backed it up, and sent it to   
   the other location.  It will not restore.  (No, I was not told the   
   error message.)  My opposite number says that the database is supposed   
   to be unattached and attached, but he does not know all the ins and   
   outs either.   
      
        How can I simply create a database and send it elsewhere, or   
   receive one from elsewhere and then have it get installed on the   
   destination?   
      
        Scripts are not acceptable in this case as the databases will   
   eventually be operational databases, and we need to cover this.  For   
   debugging purposes, I may need to receive and install a full database.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca