Quick Answer Please.

Sorry, I need to run backups to a shared drive on another server, and
everything I have tried for the last hour will not work..
I have full access to the drive, can copy and paste anything into it, but
when I run this Query
BACKUP DATABASE ArnesPriceBook
TO DISK = 'L:\ArnesPriceBook_db.BAK'
WITH INIT, SKIP
It comes back with "Cannot open backup device 'I:\ArnesPriceBook_db.BAK'.
Device error or device off-line"
The local drives are compressed and there are space issues. How can I back
this up to a mapped or UNC location'
Thank you :-)WANNABE wrote:
> Sorry, I need to run backups to a shared drive on another server, and
> everything I have tried for the last hour will not work..
> I have full access to the drive, can copy and paste anything into it, but
> when I run this Query
> BACKUP DATABASE ArnesPriceBook
> TO DISK = 'L:\ArnesPriceBook_db.BAK'
> WITH INIT, SKIP
> It comes back with "Cannot open backup device 'I:\ArnesPriceBook_db.BAK'.
> Device error or device off-line"
> The local drives are compressed and there are space issues. How can I back
> this up to a mapped or UNC location'
> Thank you :-)
>
*YOU* may have access to that share, but does SQL? Look at the
properties of the SQL Server and SQL Agent services - are they running
as "Local System" or as a domain user? To access network resources,
they must run as a domain user, and that user must have access to the
network resources.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I am logged in as Administrator, and YES it's a bad thing SQL server
and the agent run off the domain administrator ID.. The Id has full access
to all it needs and more. After I create a device for that UNC location the
script works when backing up to the device across the network, but That will
require many changes to what the plan for tonight was, and I am not sure how
to restore a device back up to a different server. ANY further suggestions
and help would be much appreciated.
=========================================="Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:44EA1E4D.2070305@.realsqlguy.com...
> WANNABE wrote:
>> Sorry, I need to run backups to a shared drive on another server, and
>> everything I have tried for the last hour will not work..
>> I have full access to the drive, can copy and paste anything into it, but
>> when I run this Query
>> BACKUP DATABASE ArnesPriceBook
>> TO DISK = 'L:\ArnesPriceBook_db.BAK'
>> WITH INIT, SKIP
>> It comes back with "Cannot open backup device 'I:\ArnesPriceBook_db.BAK'.
>> Device error or device off-line"
>> The local drives are compressed and there are space issues. How can I
>> back this up to a mapped or UNC location'
>> Thank you :-)
> *YOU* may have access to that share, but does SQL? Look at the properties
> of the SQL Server and SQL Agent services - are they running as "Local
> System" or as a domain user? To access network resources, they must run
> as a domain user, and that user must have access to the network resources.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||It looks to me like you are using a mapped drive which you
don't want to use with services. Use a UNC path to a share
that the service account for SQL Server has access to. If
you created a share on the other server named SQLBackups,
you would use something like:
\\ServerName\SQLBackups\
to reference the directory. So the backup would be:
BACKUP DATABASE ArnesPriceBook
TO DISK = '\\ServerName\SQLBackups\ArnesPriceBook_db.BAK'
WITH INIT, SKIP
-Sue
On Mon, 21 Aug 2006 16:53:15 -0500, "WANNABE" <breichenbach
AT istate DOT com> wrote:
>Yes, I am logged in as Administrator, and YES it's a bad thing SQL server
>and the agent run off the domain administrator ID.. The Id has full access
>to all it needs and more. After I create a device for that UNC location the
>script works when backing up to the device across the network, but That will
>require many changes to what the plan for tonight was, and I am not sure how
>to restore a device back up to a different server. ANY further suggestions
>and help would be much appreciated.
>==========================================>"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
>news:44EA1E4D.2070305@.realsqlguy.com...
>> WANNABE wrote:
>> Sorry, I need to run backups to a shared drive on another server, and
>> everything I have tried for the last hour will not work..
>> I have full access to the drive, can copy and paste anything into it, but
>> when I run this Query
>> BACKUP DATABASE ArnesPriceBook
>> TO DISK = 'L:\ArnesPriceBook_db.BAK'
>> WITH INIT, SKIP
>> It comes back with "Cannot open backup device 'I:\ArnesPriceBook_db.BAK'.
>> Device error or device off-line"
>> The local drives are compressed and there are space issues. How can I
>> back this up to a mapped or UNC location'
>> Thank you :-)
>> *YOU* may have access to that share, but does SQL? Look at the properties
>> of the SQL Server and SQL Agent services - are they running as "Local
>> System" or as a domain user? To access network resources, they must run
>> as a domain user, and that user must have access to the network resources.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com
>|||WANNABE wrote:
> Yes, I am logged in as Administrator, and YES it's a bad thing SQL server
> and the agent run off the domain administrator ID.. The Id has full access
> to all it needs and more. After I create a device for that UNC location the
> script works when backing up to the device across the network, but That will
> require many changes to what the plan for tonight was, and I am not sure how
> to restore a device back up to a different server. ANY further suggestions
> and help would be much appreciated.
I just noticed you're using mapped drives... Try backup up to the UNC
path name instead, i.e. \\servername\sharename\ArnesPriceBook.BAK
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I know I had tried that, but I just tried it again, and using the UNC
worked.. Thanks, I must have fat fingered something the first time
..whatever... Thank you very much!!!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:96bke2d6p571jnmidup6bld6li16thvm48@.4ax.com...
> It looks to me like you are using a mapped drive which you
> don't want to use with services. Use a UNC path to a share
> that the service account for SQL Server has access to. If
> you created a share on the other server named SQLBackups,
> you would use something like:
> \\ServerName\SQLBackups\
> to reference the directory. So the backup would be:
> BACKUP DATABASE ArnesPriceBook
> TO DISK = '\\ServerName\SQLBackups\ArnesPriceBook_db.BAK'
> WITH INIT, SKIP
> -Sue
> On Mon, 21 Aug 2006 16:53:15 -0500, "WANNABE" <breichenbach
> AT istate DOT com> wrote:
>>Yes, I am logged in as Administrator, and YES it's a bad thing SQL server
>>and the agent run off the domain administrator ID.. The Id has full
>>access
>>to all it needs and more. After I create a device for that UNC location
>>the
>>script works when backing up to the device across the network, but That
>>will
>>require many changes to what the plan for tonight was, and I am not sure
>>how
>>to restore a device back up to a different server. ANY further
>>suggestions
>>and help would be much appreciated.
>>==========================================>>"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
>>news:44EA1E4D.2070305@.realsqlguy.com...
>> WANNABE wrote:
>> Sorry, I need to run backups to a shared drive on another server, and
>> everything I have tried for the last hour will not work..
>> I have full access to the drive, can copy and paste anything into it,
>> but
>> when I run this Query
>> BACKUP DATABASE ArnesPriceBook
>> TO DISK = 'L:\ArnesPriceBook_db.BAK'
>> WITH INIT, SKIP
>> It comes back with "Cannot open backup device
>> 'I:\ArnesPriceBook_db.BAK'.
>> Device error or device off-line"
>> The local drives are compressed and there are space issues. How can I
>> back this up to a mapped or UNC location'
>> Thank you :-)
>> *YOU* may have access to that share, but does SQL? Look at the
>> properties
>> of the SQL Server and SQL Agent services - are they running as "Local
>> System" or as a domain user? To access network resources, they must run
>> as a domain user, and that user must have access to the network
>> resources.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com
>|||It's more robust to use UNC than use a mapped drive letter. But if you must,
you can run EXEC master..xp_cmdshell 'net use L: \\theServer\theShare' to map
the drive before running the backup step in the same T-SQL script.
Linchi
"WANNABE" wrote:
> Yes, I am logged in as Administrator, and YES it's a bad thing SQL server
> and the agent run off the domain administrator ID.. The Id has full access
> to all it needs and more. After I create a device for that UNC location the
> script works when backing up to the device across the network, but That will
> require many changes to what the plan for tonight was, and I am not sure how
> to restore a device back up to a different server. ANY further suggestions
> and help would be much appreciated.
> ==========================================> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:44EA1E4D.2070305@.realsqlguy.com...
> > WANNABE wrote:
> >> Sorry, I need to run backups to a shared drive on another server, and
> >> everything I have tried for the last hour will not work..
> >> I have full access to the drive, can copy and paste anything into it, but
> >> when I run this Query
> >> BACKUP DATABASE ArnesPriceBook
> >> TO DISK = 'L:\ArnesPriceBook_db.BAK'
> >> WITH INIT, SKIP
> >> It comes back with "Cannot open backup device 'I:\ArnesPriceBook_db.BAK'.
> >> Device error or device off-line"
> >> The local drives are compressed and there are space issues. How can I
> >> back this up to a mapped or UNC location'
> >> Thank you :-)
> >
> > *YOU* may have access to that share, but does SQL? Look at the properties
> > of the SQL Server and SQL Agent services - are they running as "Local
> > System" or as a domain user? To access network resources, they must run
> > as a domain user, and that user must have access to the network resources.
> >
> >
> > --
> > Tracy McKibben
> > MCDBA
> > http://www.realsqlguy.com
>
>