Re: Backup to UNC using Qizard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joshua Campbell (Joshua.Campbell_at_WellmanInc-DieSpamDie.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 07:55:02 -0400

For the first command you sent me, I do get a good response:
 Volume in drive \\0cltbkp02\SQL$ is New Volume
 Volume Serial Number is 1807-8BC6
NULL
 Directory of \\0cltbkp02\SQL$
NULL
06/14/2004 01:44p <DIR> .
06/14/2004 01:44p <DIR> ..
06/14/2004 01:44p 14 New Text Document.txt
               1 File(s) 14 bytes
               2 Dir(s) 778,372,308,992 bytes free
NULL

For the second command you sent me, it processes fine as well, and a backup
file is created on the drive.
Processed 2056 pages for database 'master', file 'master' on file 1.
Processed 1 pages for database 'master', file 'mastlog' on file 1.
BACKUP DATABASE successfully processed 2057 pages in 0.703 seconds (23.959
MB/sec).

So, any ideas why it isn't working for me if I run it through the wizard?

"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
news:%23ZGegTkUEHA.3512@TK2MSFTNGP12.phx.gbl...
So, from the SQL Server box, this command returns a directory list?

exec master..xp_cmdshell 'dir \\0cltbkp02\SQL$'

Does this work when you run it from Query Analyzer?
BACKUP DATABASE master TO DISK = '\\0cltbkp02\SQL$\master.bak' WITH INIT 

-- 
Keith
"Joshua Campbell" <Joshua.Campbell@WellmanInc-DieSpamDie.com> wrote in
message news:u0NKDJkUEHA.1356@TK2MSFTNGP09.phx.gbl...
> Yes to both.
>
>
>
> "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
> news:eV$naDkUEHA.2028@TK2MSFTNGP11.phx.gbl...
> Do you have a hidden share on machine 0cltbkp02 called SQL?
> Does the account that SQL erver is running under have permissions to that
> share?
>
>
> -- 
> Keith
>
>
> "Joshua Campbell" <Joshua.Campbell@WellmanInc-DieSpamDie.com> wrote in
> message news:esHoBgjUEHA.2816@TK2MSFTNGP11.phx.gbl...
> > I'm using the database maintenance plan wizard to set up my backup
> routine.
> > I'm trying to get the backups to go to a remote share via a UNC.
However,
> > whenever I try to do that, I get an error that says:
> > BackupDiskFile::CreateMedia: Backup device
> > '\\0cltbkp02\SQL$\BACKUP\WLMPetProData_db_200406141322.BAK' failed to
> > create. Operating system error = 3(The system cannot find the path
> > specified.).
> >
> > MSSQLSERVER runs as an account that has access to this share, and so
does
> > SQL Server Agent.
> >
> > I've even tried mapping a drive (T:) to this share, but then I get this
> > error:
> > BackupDiskFile::CreateMedia: Backup device
> > 'T:\BACKUP\Accolade_KN4_db_200406141329.BAK' failed to create. Operating
> > system error = 3(The system cannot find the path specified.).
> >
> > Any ideas why this isn't workign for me?
> >
> > Thanks.
> > Joshua
> >
> >
>
>

Relevant Pages

  • Re: Restart Services
    ... How to restart SQL Server at regular intervals? ... > After that schedule this batch using the Windows scheduler or use the AT ... > See the help of AT command by executing the below from command prompt:- ... >> Do you want to stop the services so that you can backup your databases? ...
    (microsoft.public.sqlserver.clients)
  • Re: Schedule to backup MSDE 2000 to overwrite the previous file
    ... Run the SQL Server using a domain account with appropriate rights to the ... Then the backup will be able to reach outside the server. ... I am try to backup MSDE database with the following command: ...
    (microsoft.public.sqlserver.msde)
  • Re: Automatic Backup
    ... The command to backup a database is "backup database" you can schedule this ...
    (microsoft.public.sqlserver.msde)
  • Re: Is database available during a backup?
    ... I get time outs on both connects and when trying to run a command. ... Run BACKUP commands from SSMS, just like they are specified in the ... Also when the backup is running monitor the load on the server, ... afterwards check the SQL Server errorlog and the event log for messages. ...
    (microsoft.public.sqlserver.server)
  • Re: Backup into another machine.
    ... I used the following command ... but there are Few Pre requisites to do backup ... You Should start SQL server using Domain user who got access to remote ... > Backup to remote machine will not work if you start SQL server using Local ...
    (microsoft.public.sqlserver.clients)