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)
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!