Backup Database on the network

I tried to backup the database on the network, which is in the same
workgroup; i received an ERROR message, Which says
"BackupDiskFile::CreateMedia: Backup device
'\\Servername\SharedName\FileName.BAK' failed to create. Operating system
error = 5(Access is denied.)."
Is there anyone have an idia to solve my problem. I appreciate your help.
Thanks.The account that SQL Server runs under must have permissions to read and
write to that share.
--
Andrew J. Kelly SQL MVP
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.|||Also, check to make sure your SQL Service account is a domain account (but i
guess that would be implied).
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.|||We don't have any Domain, we are working in Workgroup model. The SQL Server
and the Server which I want to have backup on it, are in different Workgroup.
Is there any methode to solve this?
"Shaun Beane" wrote:
> Also, check to make sure your SQL Service account is a domain account (but i
> guess that would be implied).
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
> >I tried to backup the database on the network, which is in the same
> > workgroup; i received an ERROR message, Which says
> > "BackupDiskFile::CreateMedia: Backup device
> > '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> > error = 5(Access is denied.)."
> > Is there anyone have an idia to solve my problem. I appreciate your help.
> >
> > Thanks.
>
>|||Hi
Make sure SQL Server runs under an account where there is the same account
on both machines, with exactly the same passwords.
BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
names. So you have to write T-SQL with the BACKUP command in it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
> We don't have any Domain, we are working in Workgroup model. The SQL
Server
> and the Server which I want to have backup on it, are in different
Workgroup.
> Is there any methode to solve this?
>
> "Shaun Beane" wrote:
> > Also, check to make sure your SQL Service account is a domain account
(but i
> > guess that would be implied).
> >
> > "betrek" <betrek@.discussions.microsoft.com> wrote in message
> > news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
> > >I tried to backup the database on the network, which is in the same
> > > workgroup; i received an ERROR message, Which says
> > > "BackupDiskFile::CreateMedia: Backup device
> > > '\\Servername\SharedName\FileName.BAK' failed to create. Operating
system
> > > error = 5(Access is denied.)."
> > > Is there anyone have an idia to solve my problem. I appreciate your
help.
> > >
> > > Thanks.
> >
> >
> >|||There is a way to use Maintenance plans and UNC names together.
Here is a comprehensive set of instructions on exactly how to do it.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ecSnti9MFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Hi
> Make sure SQL Server runs under an account where there is the same account
> on both machines, with exactly the same passwords.
> BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
> names. So you have to write T-SQL with the BACKUP command in it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
>> We don't have any Domain, we are working in Workgroup model. The SQL
> Server
>> and the Server which I want to have backup on it, are in different
> Workgroup.
>> Is there any methode to solve this?
>>
>> "Shaun Beane" wrote:
>> > Also, check to make sure your SQL Service account is a domain account
> (but i
>> > guess that would be implied).
>> >
>> > "betrek" <betrek@.discussions.microsoft.com> wrote in message
>> > news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>> > >I tried to backup the database on the network, which is in the same
>> > > workgroup; i received an ERROR message, Which says
>> > > "BackupDiskFile::CreateMedia: Backup device
>> > > '\\Servername\SharedName\FileName.BAK' failed to create. Operating
> system
>> > > error = 5(Access is denied.)."
>> > > Is there anyone have an idia to solve my problem. I appreciate your
> help.
>> > >
>> > > Thanks.
>> >
>> >
>> >
>