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 |
|
mcleanap
Starting Member
3 Posts |
 Posted - 2011-08-31 : 21:32:27
|
| I am doing a backup of all user databases to a remote server. 19 out of 20 databases backup correctly, however there is one database in which I get the following error:Write on "\\VBOXSVR\Backup\SQL Server Databases\all_databases.bak" failed: 87(The parameter is incorrect.)Any ideas? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-09-01 : 04:56:44
|
| What does the Error log show ?PBUH |
 |
|
|
mcleanap
Starting Member
3 Posts |
Posted - 2011-09-01 : 08:46:23
|
| \\\\V..." failed with the following error: "Write on "\\\\VBOXSVR\\Backup\\SQL Server Databases\\all_databases.bak" failed: 87(The parameter is incorrect.)BACKUP DATABASE is terminating abnormally.12 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-01 : 10:26:44
|
| probably no help, but we never backup across the network. We backup to local drive and then COPY the file to the remote location. We have found that this means when the COMMs fail a) we still have a backup on the local drive at least (and in my experience a COMMs failure often also means that noone notices that the backups etc. have failed) and b) the interference to other processes is kept to a minimum.We use RoboCopy to copy backup files to remote location. It has parameters to keep folders in sync (so will delete remote when backup is deleted from local, if you want), and parameters to be "gentle" to the network and not flood it with data - this can be particularly important if network connections are shared with other high-priority traffic. I'm sure they should not, for example, be shared with SAN traffic, but we've had situations where it has been! |
|
|
|
|
|
|
Remote Backup failing on specific databases