Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> HowTo: Backup to UNC name using Database Maintenance Wizard
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>