I started this thread 2 year ago. And it still seems to be actual.

For all this time I'm using the following funtions for banker's rounding and seems it work great:

[font="Courier...

Tyson, as I see your script is not using banker's rounding. ROUND - uses traditional arithmetic (5 always is rounded up).

If you are rounding only on DB level it's better to...

I've investigated it: seems like that's due to inaccuracy with double - very small amounts (like 0.0000000005) are added while calculating. So, I think it' s problem with double calcualations....

Also, I've found "banker's" round in VB from Microsoft

http://support.microsoft.com/default.aspx?scid=kb;EN-US;196652

I've translated it to T-SQL, here it is:

create function BankRoundDotNet (@val as numeric(30,15), @factor as int)

returns money

as

begin

declare @result double...

Jeff, you are right - STR behaves like Math.Round in .NET. But I found one exception I can't explain:

In .NET:

Math.Round(40.645161290322584,2) --> 40.65

Math.Round(41.645161290322584,2) --> 41.65

Math.Round(40.645,2) --> 40.65

Math.Round(41.645,2) --> 41.64

STR in SQL:

select...

Jeff, STR seems to round only last digit before precision. It doesn't take into account digits to the rigth.

Try this number: 3.4546

banker's round -> 3.46

STR -> 3.45

Thank you Carl!!! That's what I need.

That's realy baker's rounding but with one weakness - it rounds only one digit before precision digit.

For instance: rounding of 3.445657545 to second digit after dot takes no account...

Thanks Jeff. But none of them is banker's rounding.

Banker's rounding bahaves like arithmetic rounding with one exception: if value is halfway between two numbers, one of which is even and...

There is enough free space on destination disk.

I tried to create maintenance plan only for those 2 database but it failed with the same error

I've got both letters. I tried a lot of variants to solve this issue.

Of course all folders exist.

In Enterprise Manger select all stored procedures and choose All Tasks->Generate SQL Script in context menu. It'll generate SQL-script to text file. Run this script on the destanation server.

Also...

I'm backuping to network machine on it's HDD.

Symantec antivirus is running on the destanation machine.

Event Log contains next errors :

3041 : BACKUP failed to complete the command BACKUP...

SQL Server's & SQL Server Agent's accounts have Administrator's rights on both machines.

All backups are being made to the same location.

I've created one maintenance plan for 6 databases. So, they are backuped within one job.

When I run the job it...