Re: Backup Device Doesn't Seem To Exist

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 10/09/03 

Date: Wed, 08 Oct 2003 15:34:18 -0700

On Wed, 8 Oct 2003 15:17:46 -0400, "Steve Thompson"
<SteveThompson@nomail.please> wrote:
 in <eF$YcDdjDHA.2364@TK2MSFTNGP11.phx.gbl>

>With SQL Server 2000, there is no need to create a dump device...
>
>You'll need to configure your MSSQLServer service to run under a domain user
>account that has write permissions on the target UNC.
>
>Then use the native BACKUP T-SQL to invoke the backup, which can be set up
>as a re-occuring task in SQL Server Agent.
>
>Here's an example of one I created, that will over-write the target UNC each
>time:
>
>BACKUP DATABASE SMSL01 TO disk='\\<servername>\smsextract\SMSL01.dat'
>WITH INIT
>
>Steve

Thanks Steve. The issue was running the service under a domain
user account with write permissions to the UNC, but I'm happier
with an automated T-SQL procedure rather than the old manual
method. :-)

Relevant Pages