Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kevintink
Starting Member
1 Post |
 Posted - 2011-10-21 : 10:40:08
|
| i am trying to back up my sql data base to a clienti am using the following steps:BACKUP DATABASE [EVEREST_KEVIN] TO DISK = N'\\ktsony\c$\bu\kevinsdata.bak' WITH NOFORMAT, INIT, NAME = N'EVEREST_KEVIN-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GOit works sometimes, sometimes it doesntthe error log says 10/21/2011 07:46:00,Back Up Database - EVEREST_KEVIN,Error,1,EXCHANGE3,Back Up Database - EVEREST_KEVIN,1,,Executed as user: KEVINSBIZ\user1. The backup data at the end of "\\ktsony\c$\bu\kevinsdata.bak" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media<c/> use RESTORE HEADERONLY. To determine the usability of the backup sets<c/> run RESTORE VERIFYONLY. If all of the backup sets are incomplete<c/> reformat the media using BACKUP WITH FORMAT<c/> which destroys all the backup sets. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.,00:00:00,16,3013,,,,0the media is not damaged, it is my hard drive?any body know what i can doKevin Tinkelman |
|
|
|
|
|
|
|
trying to back up database to workstation