I agree. There's no point in putting tables in different filegroups if you are going to keep files of each filegroup on the same drive.

Yes, it's good to follow some standard while naming any database and I guess you are following the right procedure. Your database name should depict the product and the team/purpose...

Try to shrink the data files. If this also does not work, restart SQL Server.

The client is not accepting these differences hence we need to arrive to the same precision as Sybase.

Thanks,

Shakeel

Actually, we have migrated from sybase 12.5.1 to SQL Server 2005. But because of different behaviour of numeric datatype in Sybase and SQL we are experiencing differences in calculations/reports.

Sybase...

I would suggest you take backup in more than one stripe. In this way you will not have one large backup file but many (as you specify) and would be...