Backup on network!

[debian mojo]

hello group,
a few days ago i used the following backup statement and everthing
worked fine:

sp_addumpdevice 'disk','pipedump','\\192.x.x.x\L\Data\test.bak'

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!

Thanks in advance
Debian

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

[Stu]

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]

debian mojo (de*********@yahoo.com) writes:

a few days ago i used the following backup statement and everthing
worked fine:

sp_addumpdevice 'disk','pipedump','\\192.x.x.x\L\Data\test.bak'

Backup database Test to pipedump
The same statement is not working today!!!!!

What's the reason?

I think you are in the wrong newsgroup. If you are into making quizzes,
rec.games.trivia 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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[debian mojo]

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]

"debian mojo" <de*********@yahoo.com> wrote in message
news:dI**************@news.uswest.net...

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 ***

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\)]

"debian mojo" <de*********@yahoo.com> wrote in message
news:bM**************@news.uswest.net...

hello group,
a few days ago i used the following backup statement and everthing
worked fine:

sp_addumpdevice 'disk','pipedump','\\192.x.x.x\L\Data\test.bak'

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!

Sounds like a permissions problem though.

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


Thanks in advance
Debian

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

[Erland Sommarskog]

debian mojo (de*********@yahoo.com) writes:

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?

Seems like server cannot find or write to \\192.x.x.x\L\Data\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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[debian mojo]

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]

\\192.x.x.x\L\Data

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

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?

[Wendy]

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" <de*********@yahoo.com> wrote in message
news:Wz**************@news.uswest.net...

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 ***

[Wendy]

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" <de*********@yahoo.com> wrote in message
news:Wz**************@news.uswest.net...

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 ***

[Wendy]

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" <de*********@yahoo.com> wrote in message
news:Wz**************@news.uswest.net...

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 ***