473,836 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Backup on network!

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!

Thanks in advance
Debian

*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #1
11 6489
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

Jul 23 '05 #2
debian mojo (de*********@ya hoo.com) writes:
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?


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, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3


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 ***
Jul 23 '05 #4

"debian mojo" <de*********@ya hoo.com> wrote in message
news:dI******** ******@news.usw est.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
Jul 23 '05 #5

"debian mojo" <de*********@ya hoo.com> wrote in message
news:bM******** ******@news.usw est.net...
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!

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

Jul 23 '05 #6
debian mojo (de*********@ya hoo.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\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, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #7
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 ***
Jul 23 '05 #8
\\192.x.x.x\L\D ata

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?

Jul 23 '05 #9
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*********@ya hoo.com> wrote in message
news:Wz******** ******@news.usw est.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 ***

Jul 23 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
13395
by: nt | last post by:
I am having a problem with a regular backup of an SQL Server (MSDE 2000) database to a local drive. I initiate the backup once a week, by issuing the required T-SQL, via ADO. In this case, the T-SQL is: BACKUP DATABASE GPRS_Dimensioning_Archive TO local_backup WITH RETAINDAYS=21, NAME='GDA_20040706' Note that "local_backup" is a file sitting on the same physical drive as the database itself, and has > 80 GB free. It is not a RAID...
2
1366
by: Damn fool | last post by:
Hi again, I am able to schedule a backup and default it to the server. However, is there an option or a way to locate the backup somewhere else on the network? regards, gilbert
20
2453
by: My Internet | last post by:
Hello, I am in the process to define if our product can use PostgreSQL. Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects? Our application has a table with more than 300000 rows. There are complexe query with many joins. And we must respect some time constraints. Also the application is running 24 hours per day, so the product must be stable, with
4
2647
by: DMTman | last post by:
Who can help me to create a backup strategy that will copy the backend.mdb into separate folders representing either the time, or just folders that are sequentially numbered. I need this for rollback purposes.
0
1724
by: Massimiliano Campagnoli | last post by:
Can you explain me what is going on here ? J:\ is a network drive located on a samba server. DB2 is V7.2 fixpak 14. net use j: \\linuxserver\backupdb2 The command completed successfully. DB2 BACKUP DATABASE SAMPLE USER MAXI USING 110ELODE TO J:\
0
3202
by: Massimiliano Campagnoli | last post by:
I am trying to backup sample database to network drive J:\ which maps to a SAMBA share. The first time the backup is successfull but the the next time fails. I've to delete J:\sample.0 if I want to backup again. Here is the log: NET USE J: \\LINUXSERVER\BACKUPDB2 The command completed successfully.
9
2885
by: gabe101 | last post by:
I've searched enough to know that this ability probably doesn't exist in our current setup, thus the reason I'm coming to the community now. When doing a database backup in Enterprise Manager (SQL Server 2000 sp4), is there a priority level setting so that I can put less load on the CPU? Our small office uses one server for everything and when I do a 12:00 pm full backup of our live DB, the server slows to a crawl for about 4 or 5...
0
1555
by: debian75 | last post by:
Hi. I have two servers in the same MS network area: 1: MS 2000 Server, with an Oracle 9 installed (with license 1), and a DB1. 2: MS 2003 Enterprise R2, with an Oracle 10.2.0.3 installed (with license 2), and a DB2. I want to realize a daemon/script/cmd to backup DB1 to prevent any type of inactivity/anomaly (oracle.exe at 100% during improbable day time, other relevant job that required more system resources) of the server 1, and to...
0
899
by: psadel | last post by:
I am using MS SQL 2000 with service Pack 4, on XP Professional PC with NTFS file system. Now i am facing problem, when i take backup of a DATABASE on networkdevice (created by using "EXEC sp_addumpdevice 'disk', 'networkdevice', '\\<servername>\<sharename>\<path>\<filename>.bak'") but when I scheduled the backup it gives the error and not done. Error is BACKUP failed to complete the command BACKUP DATABASE TO WITH NOINIT , NOUNLOAD , ...
2
2389
by: Kevin Wilcox | last post by:
Iím backing up my BE from within Access; although the filesize is relatively modest (15Mb) for this day and age it can take 3 or 4 minutes for the backup to be completed. Thereís nothing I can do about that, itís a network issue beyond my control. My problem is that Access is semi-suspended whilst the backup takes place; I say semi-suspended because if the user goes into another windows app e.g. explorer, word etc, and then back into access, the...
0
9812
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
10823
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10532
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10243
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7775
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Duprť who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5642
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4443
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4003
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3103
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.