That's not what I mentioned, I don't know your recovery strategy of Service Level Agreements.

I would say writing is slower compared to reading and reading is slower compared to CPU usage, but ...

- Could you provide the statements?

- If this query is doing the...

I don't have a clear answer to your question ("It depends" :D:D ), but you can use tools like

- BCP (Bulk copy program)

- SSIS package

- T-SQL statements

- Buy a third-party...

Not possible.

In the .LDF file you see transactions like: (simplified version)

1) update customer set address='4th Avenue' where custid = 235235

2) insert into contract values(1,"johnson",$1000000)

3) delete from salesrep where salesrepid=26

4) create...

If load balancing is spreading your users over more servers, that's not possible with MSSQL (Buy Oracle RAC in that case, but you'll have to win the lottery first ;)...

The .LDF file contains transactions, not the data. The data is in the .MDF and .NDF file.

- make sure you'll be notified in an early stage

- so monitor your database and server (or let your windows guys monitor this server)

- review this disk, remove unnecessary programs,...

Are you saying the data is the same, but mixed? Or is it totally different data?

Have you looked at the execution plan?

If the data is the same but in a...

No, If you use sp_msforeachdb, the questionmark will be replaced by the databasename (by MSSQL). What you can do is create a cursor for each existing database, like this:

declare c_db...

sp_msforeachdb 'select ''?'' as Databasename,* from [?].dbo.sysobjects where name = ''@@@@@@@'''

Replace @@@@@@@ with your search criteria

You tried to attach the file to a directory which doesn't exist (it's probably the original directory on the 2000 server). Check directories for both .mdf and .ldf files

Well, Microsoft offers the software, but normally, you start with the hardware. I think your question is not suitable for this forum. You probably won't setup a high-availability environment based...

Or do you mean migrating from MySQL to MSSQL ?

Just to be clear:

- Which backup solution are you using?

- Which SQL version (including SP/hotfixes please)

- Which edition

- x86 or x64?

Here's a script I use to monitor you databasesize

print '*** Creating objecten voor DBSize'

print ''

if not exists (select 'yes' from sysobjects where name = 'dbsize')

BEGIN

CREATE TABLE DBSize(

[Servername] sysname DEFAULT @@SERVERNAME

,...