You can use DTS Backup 2000 http://www.sqldts.com/242.aspx to make this move. The DTS Backup 2000 product retains DTS package layout and annotations, with most other DTS export/import methods lose.

If you have a MSDTC instance local to your SQL Server instance, they can use memory to communicate. If MSDTC and SQL Server are on separate nodes they have...

Another link with good advice is http://blogs.technet.com/b/clinth/archive/2009/09/03/the-case-of-the-enormous-page-file.aspx from Clint Huffman, a Microsoft PFE.

I run my machine at home without a page file and have had no problems, but probably I...

Build a W2008 guest machine and see if SQL7 works. You will be outside of Microsoft support as W2008 never was a supported environment for SQL7, but what does...

All I can suggest is ask someone who knows about network troubleshooting.

If no-one else has better advice and you cannot fix the problem, raise a case with Microsoft. They...

If you want to buy retail then you may still find shrinkwrapped version of older versions of SQL Server. The license terms will apply to the version you buy...

When you destroy a clustered service, very often the IP address is not deleted from the DNS server and the cluster name record is not deleted from Active Directory. ...

You should also never restore MSDB from an older version of SQL Server. Each new version introduces new things to MSDB, and they will not work as expected if...

If I was in your position, I would ask for Windows to be re-installed.

IMHO it is never worth uninstalling SQL Server. After it is installed, it should be considered...

Depending on the version of Windows you are using and the version and edition of SQL Server, not all of the pre-requisite software is included in the SQL Install media.

See...

Very true! There are very few situations where enabling this option is helpful, and many where...

Does the upgrade have to install and pre-requisite software before it can start the SQL 2008 R2 install?

To get from SQL 2005 to SQL 2008 R2 you need...

If you are cloning a system image, Windows would typically be stopped when the master image was made. A cloned image does not use Sysprep.

When you first boot a...

Clustering for SSRS will give you a high-availability solution. It is not a scale-out solution because only one instance of SSRS can be active at a given time on...

No-one else has picked this up, which often means there is little expertise available for this aspect of SQL Server.

You should not have a SQL Server crash because of a...