Backup on network!

**Stu** · Jul 23 '05, 09:30 AM

Re: Backup on network!

What's the error message you are receiving? That would help narrow down
the problem a bit.

Just taking a wild-ass guess at it, though, you didn't drop the device
before attempting to add it again today.

Stu

**Erland Sommarskog** · Jul 23 '05, 09:30 AM

Re: Backup on network!

debian mojo (debian_mojo@ya hoo.com) writes:[color=blue]
> a few days ago i used the following backup statement and everthing
> worked fine:
>
> sp_addumpdevice 'disk','pipedum p','\\192.x.x.x \L\Data\test.ba k'
>
> Backup database Test to pipedump
>
>
> The same statement is not working today!!!!!
>
> What's the reason?[/color]

I think you are in the wrong newsgroup. If you are into making quizzes,
rec.games.trivi a or rec.puzzles are the groups I would recommend.

I mean, if you were really asking for help, you would have posted the
error message, wouldn't you? How could anyone be able tell you the
reason something is wrong, if you don't tell us what is wrong?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

Microsoft SQL Server

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

**debian mojo** · Jul 23 '05, 09:30 AM

Re: Backup on network!

This is the error message!

-------------------------------------------------------
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'pipedump'. Device error or device off-line.
See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
--------------------------------------------------------

Now?

*** Sent via Developersdex http://www.developersdex.com ***

**Simon Hayes** · Jul 23 '05, 09:30 AM

Re: Backup on network!

"debian mojo" <debian_mojo@ya hoo.com> wrote in message
news:dIaye.7$8h 6.1770@news.usw est.net...[color=blue]
>
>
> This is the error message!
>
> -------------------------------------------------------
> Server: Msg 3201, Level 16, State 1, Line 1
> Cannot open backup device 'pipedump'. Device error or device off-line.
> See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP DATABASE is terminating abnormally.
> --------------------------------------------------------
>
> Now?
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

At the risk of asking an obvious question, did you "see the SQL Server error
log for more details", and if so, what extra information was there?

Simon

**Greg D. Moore \(Strider\)** · Jul 23 '05, 09:30 AM

Re: Backup on network!

"debian mojo" <debian_mojo@ya hoo.com> wrote in message
news:bMwxe.6$oV 4.3467@news.usw est.net...[color=blue]
> hello group,
>
>
> a few days ago i used the following backup statement and everthing
> worked fine:
>
> sp_addumpdevice 'disk','pipedum p','\\192.x.x.x \L\Data\test.ba k'
>
> Backup database Test to pipedump
>
>
> The same statement is not working today!!!!!
>
> What's the reason?
>
> Please dont tell me that check if the network path exists or not! I've
> checked the path and permissions. Everything is ok![/color]

Sounds like a permissions problem though.

Sure you're running the command from the same login you ran the other day?

[color=blue]
>
> Thanks in advance
> Debian
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

**Erland Sommarskog** · Jul 23 '05, 09:30 AM

Re: Backup on network!

debian mojo (debian_mojo@ya hoo.com) writes:[color=blue]
> This is the error message!
>
> -------------------------------------------------------
> Server: Msg 3201, Level 16, State 1, Line 1
> Cannot open backup device 'pipedump'. Device error or device off-line.
> See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP DATABASE is terminating abnormally.
> --------------------------------------------------------
>
> Now?[/color]

Seems like server cannot find or write to \\192.x.x.x\L\D ata\test.bak today.
I played around a little, and that is typically the error message
you get when the directory does not exist, the server name is wacko
or the file is write protected. I would do as Simon says, check if the
SQL Server error log gives any more hints. If all you find there is a
OS error number, say 4711, try this:

NET HELPMSG 4711

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

Microsoft SQL Server

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

**debian mojo** · Jul 23 '05, 09:31 AM

Re: Backup on network!

Hi again,

Checked the error log and found this info:

-----------------------------------------------------------
2005-07-06 19:47:13.48 spid60 BackupDiskFile: :CreateMedia: Backup
device '\\192.x.x.x\L\ Data\test.bak' failed to create. Operating system
error = 5(Access is denied.).
2005-07-06 19:47:13.48 backup BACKUP failed to complete the command
backup database test to pipedump
-----------------------------------------------------------

From what i could understand, there's a problem with access
privileges! Anything else i should check?

Thanks again and again
Debian

*** Sent via Developersdex http://www.developersdex.com ***

**serge** · Jul 23 '05, 09:31 AM

Re: Backup on network!

\\192.x.x.x\L\D ata

Check the windows share and file permissions on that folder.
Obviously this is a permissions problem.

[color=blue]
> Checked the error log and found this info:
>
> -----------------------------------------------------------
> 2005-07-06 19:47:13.48 spid60 BackupDiskFile: :CreateMedia: Backup
> device '\\192.x.x.x\L\ Data\test.bak' failed to create. Operating system
> error = 5(Access is denied.).
> 2005-07-06 19:47:13.48 backup BACKUP failed to complete the command
> backup database test to pipedump
> -----------------------------------------------------------
>
> From what i could understand, there's a problem with access
> privileges! Anything else i should check?[/color]

**Wendy** · Jul 23 '05, 09:32 AM

Re: Backup on network!

Whatever account you are using to start your MSSQL and SQL Agent services
must have access to the referenced share where you are backing up. If you
are using the local SYSTEM account to start the services it is not going to
work.

The way I do it is I have a SQL service account in the domain. I make that
account a System Admin in SQL (and many times a Local Administrator on the
box) and then I give it full access the share I am backing up to.

"debian mojo" <debian_mojo@ya hoo.com> wrote in message
news:WzSye.15$d l.5102@news.usw est.net...[color=blue]
> Hi again,
>
> Checked the error log and found this info:
>
> -----------------------------------------------------------
> 2005-07-06 19:47:13.48 spid60 BackupDiskFile: :CreateMedia: Backup
> device '\\192.x.x.x\L\ Data\test.bak' failed to create. Operating system
> error = 5(Access is denied.).
> 2005-07-06 19:47:13.48 backup BACKUP failed to complete the command
> backup database test to pipedump
> -----------------------------------------------------------
>
> From what i could understand, there's a problem with access
> privileges! Anything else i should check?
>
> Thanks again and again
> Debian
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

**Wendy** · Jul 23 '05, 09:32 AM

Re: Backup on network!

Whatever account you are using to start your MSSQL and SQL Agent services
must have access to the referenced share where you are backing up. If you
are using the local SYSTEM account to start the services it is not going to
work.

The way I do it is I have a SQL service account in my domain. I make that
account a System Admin in SQL (and many times a Local Administrator on the
SQL box) and then I give it full access the share I am trying to back up to.

"debian mojo" <debian_mojo@ya hoo.com> wrote in message
news:WzSye.15$d l.5102@news.usw est.net...[color=blue]
> Hi again,
>
> Checked the error log and found this info:
>
> -----------------------------------------------------------
> 2005-07-06 19:47:13.48 spid60 BackupDiskFile: :CreateMedia: Backup
> device '\\192.x.x.x\L\ Data\test.bak' failed to create. Operating system
> error = 5(Access is denied.).
> 2005-07-06 19:47:13.48 backup BACKUP failed to complete the command
> backup database test to pipedump
> -----------------------------------------------------------
>
> From what i could understand, there's a problem with access
> privileges! Anything else i should check?
>
> Thanks again and again
> Debian
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

**Wendy** · Jul 23 '05, 09:32 AM

Re: Backup on network!

Whatever account you are using to start your MSSQL and SQL Agent services
must have access to the referenced share where you are backing up. If you
are using the local SYSTEM account to start the services it is not going to
work.

The way I do it is I have a SQL service account in the domain. I make that
account a System Admin in SQL (and many times a Local Administrator on the
box) and then I give it full access the share I am backing up to.

"debian mojo" <debian_mojo@ya hoo.com> wrote in message
news:WzSye.15$d l.5102@news.usw est.net...[color=blue]
> Hi again,
>
> Checked the error log and found this info:
>
> -----------------------------------------------------------
> 2005-07-06 19:47:13.48 spid60 BackupDiskFile: :CreateMedia: Backup
> device '\\192.x.x.x\L\ Data\test.bak' failed to create. Operating system
> error = 5(Access is denied.).
> 2005-07-06 19:47:13.48 backup BACKUP failed to complete the command
> backup database test to pipedump
> -----------------------------------------------------------
>
> From what i could understand, there's a problem with access
> privileges! Anything else i should check?
>
> Thanks again and again
> Debian
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

Backup on network!

Backup on network!

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment