From: esquel@sommarskog.se   
      
   Tim Ritberg (tim@server.invalid) writes:   
   > I startet Server Manager Studio as local admin and created a user for sql.   
   >   
   > This is my backup command:   
   > sqlcmd -U remotebackup -P foobar -S tcp:office2,49762 -Q "BACKUP   
   > DATABASE [contura] TO DISK = 'testback' WITH NOFORMAT, NOINIT, NAME =   
   > 'demodb-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"   
   >   
   > Strange that port 49762 and backup went into a sqlserver subfolder. I   
   > guess sql server can't write directly to net shares.   
      
      
   The port number is instead of the instance name. Which you need if the   
   Browser server is not running or blocked by firewall.   
      
   It went to that folder, because you did not specify the full path. You can   
   change the default path from SSMS under Server Properties, but I don't   
   really recommend that.   
      
   SQL Server can write to net shares - but the service account for SQL Server   
   needs to have write access to the share.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)