| Author |
Topic |
|
Jasmine
Starting Member
4 Posts |
 Posted - 2008-07-24 : 03:01:18
|
| In Query Analyzer , execute the code : declare @sql varchar(500)select @sql='\\192.168.10.5\50backup\mworks'+'_db_'+convert(varchar(10),getdate(),112) +'.bak'exec master..xp_cmdshell 'net use \\192.168.10.5\50backup 111 /user:backup\netback'backup database mworks to disk=@sql go-------------------------------------------------------------------Error Message :Server: Msg 3013, Level 16, State 1, Line 4 BACKUP DATABASE is terminating abnormally .My database is 56G , bakup time is about 2.5 hours.When I bakup other database, for example ,pubs , backup is successly.-----------------------------------------------------------------Error Log :BackupDiskFile::RequestDurableMedia: failure on backup device '\\192.168.10.5\50backup\mworks_db_2008072116.bak'. Operating system error 64(The specified network name is no longer available.).I hope anyone could help me , thanks~~~ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-24 : 13:18:24
|
| Sounds network connection issue, can you see the share in file explorer? May need let your network guys to trace network traffic. |
 |
|
|
Jasmine
Starting Member
4 Posts |
Posted - 2008-07-25 : 02:08:43
|
quote:
Originally posted by rmiao
Sounds network connection issue, can you see the share in file explorer? May need let your network guys to trace network traffic.
There is a special line between database server and backup server . they are connected directly . |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-07-25 : 13:00:22
|
quote:
Originally posted by Jasmine
quote:
Originally posted by rmiao
Sounds network connection issue, can you see the share in file explorer? May need let your network guys to trace network traffic.
There is a special line between database server and backup server . they are connected directly .
It's still a "remote" server, correct? This could be be any number of things, network connectivity being the most obvious. I'd check that "special line", your nic cards and also look in the event logs. I saw something today relating to the OS causing an issue when trying to move large files between servers. I'm still leaning towards rmiao's reason as I've seen that before.Terry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-25 : 13:10:32
|
| I would do 2 steps :1)Backup to local drive and zip it2)send those files to network rather than backing up directly to UNC. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-26 : 18:57:08
|
| What to do if doesn't have enough space on local disk? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-26 : 23:07:50
|
| Then spread files across several disks.You can backup your DB into multiple files. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-27 : 00:50:59
|
| Multiple backup files doesn't make more free space on local disks, right? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-27 : 09:44:28
|
| What??????So do you put everything in one drive. I didn't say it makes free space. My point is you can spread files accross several disks which has space and remove when it is copied to network share. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-27 : 15:09:13
|
| Hate to argue like this. What I said is 'What to do if doesn't have enough space on local disk', didn't say 'one of local disk'. By the way, how to copy file to network share when you have network issue? That's the error PO got. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-27 : 17:20:23
|
| Its needles to say that OP is getting that network error when he/she is backing up large database. Ofcourse , if it is critical database, you have to atleast have temporary space for backup and remove whenever you are done. Also you are copying to network share in small size (not a whole big database) |
|
|
|
Jasmine
Starting Member
4 Posts |
Posted - 2008-07-28 : 21:26:14
|
| I can see the share in file explorer . and I try to backup to local server and then move it to remote server .it's ok . when our database is 40G , there is no problem .but now database is bigger than before , and it becomes more unsteadiness . In Query Analyzer , execute the backup code , it shows error and create the backup file in remote server . when I do full restore with this file .it succeed. but differential restore failed. So I don't know how to correct ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-28 : 22:06:35
|
| >> it shows error and create the backup file in remote server . Same error as in original post? How big is the backup file created?>> when I do full restore with this file .it succeed. but differential restore failed. How can you restore it when get error during backup? What's error you got from diff. restoe? What's your fuul restore statement? Used 'with norecovery' option? |
|
|
|
Jasmine
Starting Member
4 Posts |
Posted - 2008-08-07 : 20:54:47
|
| the error message shows when backup will be over . backup file is 56G.I use error backup file to restore .when I choose 'Leave database operational. No additional transaction logs can be restored.' option .full restore is ok. the database's statement is normal. when I choose 'Leave database nonoperational but able to restore additional transaction logs.' complete restore is ok .but Database-diferential restore is error. and now this database's statement is suspect.Can't believe it .right ? me too ~~ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 22:20:10
|
| That sounds your diff backup file is bad, double check it with 'restore verifyonly'. |
|
|
|
|
Net back problem