backup error 17055 description 3041

I am getting this error when trying to bakup a database to a file. I am using the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKUP DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\fordev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSKIP , STATS = 10, NOFORMAT
Any help would be appreciated.
Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there are network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Did you ever get this resolved?
I am wondering what you did?

backup error 17055 description 3041

I am getting this error when trying to bakup a database to a file. I am usin
g the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKU
P DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\ford
ev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSK
IP , STATS = 10, NOFORMAT
Any help would be appreciated.Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there a
re network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Did you ever get this resolved?
I am wondering what you did?

Backup device?

Hi all,
I want to store bakup file on the computer on netword, so make a backup device on the other computer, it ok. after that i make an full backup, there is an error : "Can not open the bakup device " .
please show me,
best regard.share that network PC drive and if u still have any problem login into both pc with same login id...

that will surely resolve ur problem..

Cheers!!|||Originally posted by thanhtung2003
Hi all,

I want to store bakup file on the computer on netword, so make a backup device on the other computer, it ok. after that i make an full backup, there is an error : "Can not open the bakup device " .
please show me,
best regard.
Make sure you have write permission in that folder.
Or create log on credential at that newwork PC.

Backup All Databases

Is there a way to backup all database at once in SQL Server 2000 ?

Or an easy way to bakup a lot of databases.....to make a posterior restore ?

Thanks

If you have a maintainance windows you can shut the server down and copy the files to the backup location (cold backup). Otherwise you would have to use the SQL maintainance Plan wizard or code the appropiate statements on your own.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

have a look at this article, http://www.sqlservercentral.com/columnists/pluis/2574.asp, it goes through setting up a process to automate the creation of backup devices and systems for the complete database server.

Backup & Restore in MSDE, How

Hi all;

I am looking to add "Make Bakup" and "Make Restore" functionalty in my applicayion menu which uses MSDE for database.

My question is How to add these two functionalty (What is the source code)??

Thanks in advanced!You'll need to use SQLDMO to accomplish this.view post 373287 andview post 389472 should help you get started.

Terri