And can you ping the server?

I'd put the inserts into a transaction.

Cannot see any reason to use a view or triggers here...

could be the SQL Server Agent connecting to the database?

Log into the server where you are running SQL. Start SQL Server Management Studio and log in. Right-click the SQL Server...

Hi

I'm starting to look at mirroring to provide failover. Am trying to avoid clustering as I have had problems setting it up and maintaining it.

However, we are thinking to...

The vb code you posted uses:

Matrix(i, j) = Matrix(i, j) + (Matrix(P, j) * -m)

... is this minus m? You don't seem to use it in the SQL...

Hi

I checked the numbers in your original post.

When I used:

declare @x float

set @x=2.77555756156289E-17

declare @y float ...

Dont forget to back up the tail of the log - you may need the latest transactions:)

The degrading performance may be due to more data on your system. If so, then a re-think on the stored proc may be required.

An easy thing to check - are...

You have already loaded your database from the flat files once.

Assuming the database files don't change, truncate all the tables and then re-run the process to load the database.

The truncate...

I've had good compression rates with Red Gate.

http://www.red-gate.com/products/SQL_Backup/index.htm

Hi

How are you trying to restore?

SQLCMD may be an option - see BOL "How to: Restore the master Database (Transact-SQL)"

C:\> sqlcmd

1> RESTORE DATABASE master FROM DISK = 'Z:\SQLServerBackups\master.bak';

2> GO

My gotcha...

Does this work?

EXEC master.dbo.sp_dropdevice @logicalname = N'somename'

Good luck!:)

Have you applied SP2?

Try right-clicking on (say) a database, then  Reports -> Standard Reports

this is quick & dirty. It assumes that you know the statements are OK and will work cleanly. Build a table holding all your SQL, then run. TEST...

Hi

Not sure I understand your last paragraph:

"I was tried to move database to another SQL server so, that I was restore database from older backup on the another SQL server"

I...