Backup question

Not sure if this is the correct group......
The tape drive on our SQL Server 2000 box died and I have just had it
replaced. The new tape drive is a Dell Powervault 110T DLT VS 80. The
problem I am having is that after every single backup job...or every step in
a backup job if it has multiple steps...the tape ejects on its own. I have
made no changes to the backup jobs, just changed the physical tape drive.
Any ideas where to start looking for the cause?
Thanks
Eric StewartCheck out the section in BooksOnLine for Backup and the Options UNLOAD and
NOUNLOAD. I suspect the old tape drive just didn't support this
functionality and you might now need to set NOUNLOAD.
--
Andrew J. Kelly
SQL Server MVP
"Eric Stewart" <stewarte@.repsilverstate.com> wrote in message
news:OZrLr246DHA.2264@.tk2msftngp13.phx.gbl...
> Not sure if this is the correct group......
> The tape drive on our SQL Server 2000 box died and I have just had it
> replaced. The new tape drive is a Dell Powervault 110T DLT VS 80. The
> problem I am having is that after every single backup job...or every step
in
> a backup job if it has multiple steps...the tape ejects on its own. I have
> made no changes to the backup jobs, just changed the physical tape drive.
> Any ideas where to start looking for the cause?
> Thanks
> Eric Stewart
>|||Thanks Andrew. I will check this out first thing in the morning!
Eric
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OEAd2956DHA.2996@.tk2msftngp13.phx.gbl...
> Check out the section in BooksOnLine for Backup and the Options UNLOAD and
> NOUNLOAD. I suspect the old tape drive just didn't support this
> functionality and you might now need to set NOUNLOAD.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Eric Stewart" <stewarte@.repsilverstate.com> wrote in message
> news:OZrLr246DHA.2264@.tk2msftngp13.phx.gbl...
> > Not sure if this is the correct group......
> >
> > The tape drive on our SQL Server 2000 box died and I have just had it
> > replaced. The new tape drive is a Dell Powervault 110T DLT VS 80. The
> > problem I am having is that after every single backup job...or every
step
> in
> > a backup job if it has multiple steps...the tape ejects on its own. I
have
> > made no changes to the backup jobs, just changed the physical tape
drive.
> > Any ideas where to start looking for the cause?
> >
> > Thanks
> >
> > Eric Stewart
> >
> >
>|||That was it!!!
Thanks again Andrew for the very helpful advice.
Eric
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OEAd2956DHA.2996@.tk2msftngp13.phx.gbl...
> Check out the section in BooksOnLine for Backup and the Options UNLOAD and
> NOUNLOAD. I suspect the old tape drive just didn't support this
> functionality and you might now need to set NOUNLOAD.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Eric Stewart" <stewarte@.repsilverstate.com> wrote in message
> news:OZrLr246DHA.2264@.tk2msftngp13.phx.gbl...
> > Not sure if this is the correct group......
> >
> > The tape drive on our SQL Server 2000 box died and I have just had it
> > replaced. The new tape drive is a Dell Powervault 110T DLT VS 80. The
> > problem I am having is that after every single backup job...or every
step
> in
> > a backup job if it has multiple steps...the tape ejects on its own. I
have
> > made no changes to the backup jobs, just changed the physical tape
drive.
> > Any ideas where to start looking for the cause?
> >
> > Thanks
> >
> > Eric Stewart
> >
> >
>sql

Backup question

Not sure if this is the correct group......
The tape drive on our SQL Server 2000 box died and I have just had it
replaced. The new tape drive is a Dell Powervault 110T DLT VS 80. The
problem I am having is that after every single backup job...or every step in
a backup job if it has multiple steps...the tape ejects on its own. I have
made no changes to the backup jobs, just changed the physical tape drive.
Any ideas where to start looking for the cause?
Thanks
Eric StewartCheck out the section in BooksOnLine for Backup and the Options UNLOAD and
NOUNLOAD. I suspect the old tape drive just didn't support this
functionality and you might now need to set NOUNLOAD.
Andrew J. Kelly
SQL Server MVP
"Eric Stewart" <stewarte@.repsilverstate.com> wrote in message
news:OZrLr246DHA.2264@.tk2msftngp13.phx.gbl...

quote:

---

> Not sure if this is the correct group......
> The tape drive on our SQL Server 2000 box died and I have just had it
> replaced. The new tape drive is a Dell Powervault 110T DLT VS 80. The
> problem I am having is that after every single backup job...or every step

---

in

quote:

---

> a backup job if it has multiple steps...the tape ejects on its own. I have
> made no changes to the backup jobs, just changed the physical tape drive.
> Any ideas where to start looking for the cause?
> Thanks
> Eric Stewart
>

---

|||Thanks Andrew. I will check this out first thing in the morning!
Eric
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OEAd2956DHA.2996@.tk2msftngp13.phx.gbl...

quote:

---

> Check out the section in BooksOnLine for Backup and the Options UNLOAD and
> NOUNLOAD. I suspect the old tape drive just didn't support this
> functionality and you might now need to set NOUNLOAD.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Eric Stewart" <stewarte@.repsilverstate.com> wrote in message
> news:OZrLr246DHA.2264@.tk2msftngp13.phx.gbl...
step[QUOTE]
> in
have[QUOTE]
drive.[QUOTE]
>

---

|||That was it!!!
Thanks again Andrew for the very helpful advice.
Eric
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OEAd2956DHA.2996@.tk2msftngp13.phx.gbl...

quote:

---

> Check out the section in BooksOnLine for Backup and the Options UNLOAD and
> NOUNLOAD. I suspect the old tape drive just didn't support this
> functionality and you might now need to set NOUNLOAD.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Eric Stewart" <stewarte@.repsilverstate.com> wrote in message
> news:OZrLr246DHA.2264@.tk2msftngp13.phx.gbl...
step[QUOTE]
> in
have[QUOTE]
drive.[QUOTE]
>

---

backup operator

I have to assign a group db_backupoperater permissions. Do they need any other role like db_dbwriter or dbreader? I don't usually assign roles like this.

Thanks

Hello,

This of course will depend upon what permissions you want the group to have. If you only want the group to be able to issue backup commands against the database in question, then db_backupoperater is all that is needed.

Cheers
Rob

backup operator

I need to give a group the role of db_backup operator. do they need anything else like db_datareader or writer? I'm not sure what they will be able to do other than backup? I've never given anyone this role.
ThanksThis is SQL forum (language, not database). Your question seems to be database-dependant, so you'd perhaps better ask it in forum which covers the database you use (is it MS SQL Server, DB2, ...?).

Backup on network!

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 ***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|||debian mojo (debian_mojo@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||
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 ***|||"debian mojo" <debian_mojo@.yahoo.com> wrote in message
news:dIaye.7$8h6.1770@.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|||"debian mojo" <debian_mojo@.yahoo.com> wrote in message
news:bMwxe.6$oV4.3467@.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 ***|||debian mojo (debian_mojo@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||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 ***|||\\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?|||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@.yahoo.com> wrote in message
news:WzSye.15$dl.5102@.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 ***|||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@.yahoo.com> wrote in message
news:WzSye.15$dl.5102@.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 ***|||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@.yahoo.com> wrote in message
news:WzSye.15$dl.5102@.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 ***