I don't need to upgrade to sql 2008 right now.

If you read my post you will see that I only need to replicate or move sql 2K to a new...

The new data center is based on vmWare.

Microsoft says:

Generally, you should not be concerned with fragmentation levels of indexes with less than 1,000 pages.

The purpose of doing backup is to be able to restore your data without any problems.

If you use SQL Server native tools you are safe.

In case of any problems you...

4.0

already done, I am waiting for a reply.

Thank you.

You need to install a cumulative update from Microsoft:

http://support.microsoft.com/kb/2315727

Also have a look at this:

http://support.microsoft.com/kb/981356

I would also have a look at Microsoft Best Practices for storage:

http://technet.microsoft.com/en-us/library/cc966534.aspx

Please use the following command to see the dimensions of the data file and the log file:

use master

restore filelistonly from disk = N'C:\your_path\your_file.bak'

For what I have understood you have to automate a SSIS Package by using SQL Server Agent in order to perform the Maintenance Cleanup Tasks.

You can find additional information and...

Thank you for your reply.

I'll give it a try in a TEST environment.

Wrong, SQL Server 2000 Enterprise Edition support up to 4 nodes.

From Microsoft:

SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition support up to four nodes for failover clustering,...

Thank you for the link.

From Microsoft:

SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition support up to four nodes for failover clustering, including an Active/Active/Active/Active failover clustering configuration, up to 16 total...

Thank you very much.

Thanks a lot for the detailed explanation and for your time.

Regards.