My MS SQL version is Standard Edition/SP4/9.00.5000.00 I have maintenace Plan to make full backup to all databases. It is working with no problem. The problem occur when I try to backup one of db manually by start enterprise management and right click on database then ->Task->Back up (Recovery model: SIMPLE; Backup type: Full; Destinantion file). Backup process starts and then go up to 10% and raise error like that :
quote: TITLE: Microsoft SQL Server Management Studio ------------------------------ Backup failed for Server 'Server1'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Uplynal limit czasu. Limit uplynal przed ukonczeniem operacji lub serwer nie odpowiada. (Microsoft SQL Server, Error: -2) This is polish - bellow translation
quote: Timed out. Limit expired before completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)
Location of backup file is the same as in maintenance plan case and also other database CAN be backup in this location so is no problem with files permissions. No additional info or errors are in SQL logs or system logs.
Maybe you are running management studio on your client machine and not on the server and then the destination path is a drive E: (for example)... This drive E: is on the server and not on your local machine. Try to open mstsc (remote desktop) and do it on the server...
Your solution could be: 1.) In the backup dialog when ready don't click ok --> click the script button (upper left corner of the dialog) instead 2.) Close the backup dialog (with X, not with OK) 3.) In that new query window (with the backup command generated by the dialog) do a right click 4.) Choose "Query Options" 5.) In the upcoming dialog set the "execution time out" to 6000 and click ok 6.) Now run the backup statement by hitting F5 or click on execute query 7.) good luck!
Last suggestion is ok. Backup was start and finish well. But if it can be use in case of manual backup from management studio ? Can I set "execution time out" to value 6000 as default ?
You can try to set a default in management studio as follows: - Menu: Tools - Options... - Query Execution (on the left side) - Enter the value for "Execution time-out" (on the right side) - click OK
but I don't know if it works for that problem and I don't know if it is a good idea always to have 6000 as default - just try!
Backup problem
Posted - 11/13/2012 : 05:13:42
